SQL and Access Help

Soldato
Joined
19 Jul 2006
Posts
2,913
Location
Leicester
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 :D Steve
 
Soldato
Joined
9 Jul 2006
Posts
3,322
Location
London
You'll need to install Oracle on your PC/laptop, which i was told not to do, so i just use the machines at uni that have it installed.

Have you tried making the table in access, and using the SQL view?
 
Soldato
Joined
21 Oct 2002
Posts
18,022
Location
London & Singapore
MS Access is the devil's financial advisor, don't use it! MS SQL Express with Management Studio Express has a better, friendlier and more powerful GUI.
 
Soldato
Joined
19 Jul 2006
Posts
2,913
Location
Leicester
Thanks for the replies :)
I have my 1st Database Desgin Concepts lesson at 11am, so I will see what happens and I'l get back to you :)
 
Top Bottom