User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 401,481 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,156 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Views: 630 | Replies: 4
Reply
Join Date: Apr 2008
Posts: 38
Reputation: Yogesh Sharma is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 0
Yogesh Sharma Yogesh Sharma is offline Offline
Light Poster

Where to write query in MS_Access

  #1  
Apr 8th, 2008
  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 6: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
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Mar 2008
Location: Spain
Posts: 19
Reputation: PCResolver is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 2
PCResolver PCResolver is offline Offline
Newbie Poster

Re: Plz Reply

  #2  
Apr 8th, 2008
You can look at and therefore add / edit sql statements by clicking the SQL view or View SQL button in the design view.
Reply With Quote  
Join Date: Apr 2008
Posts: 38
Reputation: Yogesh Sharma is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 0
Yogesh Sharma Yogesh Sharma is offline Offline
Light Poster

Re: Plz Reply

  #3  
Apr 8th, 2008
Can u plz tell me in the more clear way,I m not getting.
Reply With Quote  
Join Date: Mar 2008
Location: Spain
Posts: 19
Reputation: PCResolver is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 2
PCResolver PCResolver is offline Offline
Newbie Poster

Re: Plz Reply

  #4  
Apr 9th, 2008
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
Reply With Quote  
Join Date: Apr 2008
Posts: 2
Reputation: jenny@okcinvest is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
jenny@okcinvest jenny@okcinvest is offline Offline
Newbie Poster

Re: Plz Reply

  #5  
Apr 9th, 2008
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.
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb MS Access and FileMaker Pro Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the MS Access and FileMaker Pro Forum

All times are GMT -4. The time now is 2:02 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC