SQL and Access Help

[Steve09]

I have no past experience with Microsoft Access, and as my University Course is doing the Module "Database Design Concepts" I think SQL will be involved somewhere.

Basically, I have built a very simple Database with called "Practice" it only has one column in it with the name "Name" then a list like this...

Steve
Andy
Ant
John

I now want to executed (I think is the correct term?) this SQL statement...
SELECT Name FROM Practice

The problem is, I don't know where to executed this statement!!!
On this webpage... http://www.w3schools.com/sql/sql_tryit.asp (about half way down) they have a little box to execute the SQL statements.

So could someone please tell me where to execute my SQL statements, in order to extract information from my Database.

Thank you so much Steve

 

[Craig321]

Do it on the page you want the results printed out on?

 

[Mel_P]

You have to execute the sql Query either from within Access or some other applciation that can connect to the database (e.g. VB.NET, ASP, etc)

 

[Thrash]

In the main Access database window go to the queries section and either build the query in design view or change to SQL view and type the query in, i.e.

SELECT name FROM Practice

Where name is the column you want and Practice is the table name within your database.

When you run this query it will return all the name column for all rows in table Practice.