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
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