943,948 Members | Top Members by Rank

Web Development > Databases > MS Access and FileMaker Pro > Plz Reply
Ad:
Permalink
Apr 8th, 2008
0

Where to write query in MS_Access

Expand Post »
sql Syntax (Toggle Plain Text)
  1. CREATE TABLE Persons
  2. (
  3. FirstName VARCHAR,
  4. [Last Name] TEXT,
  5. Gender INT,
  6. [DATE Of Birth] DATETIME,
  7. MaritalStatus INTEGER,
  8. IsMarried BIT,
  9. PersonalIncome Money,
  10. HouseholdIncome Currency
  11. );


Can u plz tell me where I have to write this Query in MS-Access to craete the Table.
Last edited by peter_budo; Apr 8th, 2008 at 7:44 am. Reason: Keep It Organized - please use [code] tags, also use proper thread title, please help this and that is not welcomed, check forum policies
Similar Threads
Reputation Points: 10
Solved Threads: 1
Light Poster
Yogesh Sharma is offline Offline
43 posts
since Apr 2008
Permalink
Apr 8th, 2008
0

Re: Plz Reply

You can look at and therefore add / edit sql statements by clicking the SQL view or View SQL button in the design view.
Reputation Points: 10
Solved Threads: 3
Newbie Poster
PCResolver is offline Offline
24 posts
since Mar 2008
Permalink
Apr 8th, 2008
0

Re: Plz Reply

Can u plz tell me in the more clear way,I m not getting.
Reputation Points: 10
Solved Threads: 1
Light Poster
Yogesh Sharma is offline Offline
43 posts
since Apr 2008
Permalink
Apr 9th, 2008
0

Re: Plz Reply

This is how you do it in Access 2007. It will be similar in Access 2000 but if you want 2000 instructions please let me know.

Open your database
Select the "Create" tab at the top
Select "Query Design"
Close the "Show Table" popup
Select "SQL View"
Enter the code
Press "Run" and the table will be created.

Good luck
Reputation Points: 10
Solved Threads: 3
Newbie Poster
PCResolver is offline Offline
24 posts
since Mar 2008
Permalink
Apr 9th, 2008
0

Re: Plz Reply

note: in 2007, you'll need to first click the button to create a Create Table query. Then click the SQL Viewer button. Enter your sql and click run to create the table.
Reputation Points: 10
Solved Threads: 0
Newbie Poster
jenny@okcinvest is offline Offline
2 posts
since Apr 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS Access and FileMaker Pro Forum Timeline: One to Many ?
Next Thread in MS Access and FileMaker Pro Forum Timeline: Assisteance Requested





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC