SQL in Access 2007

[cimt]

I'm trying to use SQL in 2007 for one of my assignments but I can't find how to open SQL. For my assignment I need to create tables and querys using SQL.

[homealone]

any good?

http://www.fontstuff.com/access/acctut14.htm

- means nothing to me, the last database I used in anger was the DOS based Paradox

[punky]

Go to the database window (the one that says tables, queries, etc down the left hand side. If you can't see it, go to top menu, window and then unhide)

Click Queries, and then click new at the top.

Select design view

Click Close

In the menubar, goto View and then SQL view

You can enter your SQL in there and then click the exclamation mark to execute it

[cimt]

Originally Posted by homealone

any good?

http://www.fontstuff.com/access/acctut14.htm

- means nothing to me, the last database I used in anger was the DOS based Paradox

Nah, sorry. I know how to do it in 2003, just in 2007 I can't do figure it out.

Hi

Don't worry.....

please search in google in the keyword of sql tutorial ......

Then you can learn all information about sql..

-------------------------------

[cimt]

Thanks... I got it sorted by using the interactive guide that shows you where stuff is on 2003 and 2007.