How to enter commands in Command Line to type queries.

[Pat32]

First off sorry for the newbie question.



So heres my situation... I have started my university and hope to progress in Computer Science.

I have had my 4th SQL/APP Dev lab class, however I missed the 5th.

Our 5th lab was .
1. Create 3 tables, populate with given data and create relationships. 'Customer, Invoice, Payment'
2. We were given 8 queries to try do, we had to come up with which commands would be used.

I have no 1 completed.
As for no 2.. we are still learning all the commands, so the lab here is for us to find what commands we think will be used. I have researched and have them all 6 queries we have to run.., I have all those commands written out on paper which I think are answers.. I'm just stuck as in to how find the command line to test them.

I'm using Access 2007 on Windows 7.

[ranman256]

Access does not use command lines to run queries.

NOW, if you mean 'VB code' to run queries, its Docmd.openquery "qsQry"
EVERYTHING you need to know about running things in access can be found in a macro.
Goto the macros tab
create macro
EVERYTHING you can do can be selected from this.