MS Access and FileMaker...

Plz Reply

Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Apr 2008

Posts: 43

Reputation: Yogesh Sharma is an unknown quantity at this point

Solved Threads: 1

Yogesh Sharma Yogesh Sharma is offline

Offline

Light Poster

Where to write query in MS_Access

Apr 8th, 2008

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
CREATE TABLE Persons
(
FirstName VARCHAR,
[Last Name] TEXT,
Gender INT,
[DATE Of Birth] DATETIME,
MaritalStatus INTEGER,
IsMarried BIT,
PersonalIncome Money,
HouseholdIncome Currency
);
CREATE TABLE Persons
(
FirstName VARCHAR,
[Last Name] Text,
Gender int,
[Date Of Birth] DateTime,
MaritalStatus Integer,
IsMarried Bit,
PersonalIncome Money,
HouseholdIncome Currency
);

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

•

Join Date: Mar 2008

Posts: 19

Reputation: PCResolver is an unknown quantity at this point

Solved Threads: 2

PCResolver PCResolver is offline

Offline

Newbie Poster

Re: Plz Reply

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.

Steve
www.pcresolver.es

•

Join Date: Apr 2008

Posts: 43

Reputation: Yogesh Sharma is an unknown quantity at this point

Solved Threads: 1

Yogesh Sharma Yogesh Sharma is offline

Offline

Light Poster

Re: Plz Reply

Apr 8th, 2008

Can u plz tell me in the more clear way,I m not getting.

•

Join Date: Mar 2008

Posts: 19

Reputation: PCResolver is an unknown quantity at this point

Solved Threads: 2

PCResolver PCResolver is offline

Offline

Newbie Poster

Re: Plz Reply

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

Steve
www.pcresolver.es

•

Join Date: Apr 2008

Posts: 2

Reputation: jenny@okcinvest is an unknown quantity at this point

Solved Threads: 0

jenny@okcinvest jenny@okcinvest is offline

Offline

Newbie Poster

Re: Plz Reply

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.