SQL and Access Help

Steve09 · 3 Oct 2006 at 20:18

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

Welshy · 3 Oct 2006 at 20:34

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?

NathanE · 3 Oct 2006 at 20:41

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.

noob · 3 Oct 2006 at 20:55

http://www.fontstuff.com/access/acctut14.htm - Here is some help.

You can either create a query (under the query tab) in access using SQL or embed SQL into some code to use on a form, etc.

Steve09 · 4 Oct 2006 at 08:44

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