T
TotallyConfused
I am trying to learn SQL. Can you use instructions from an SQL book in
Access 2003 without having to install MySQL? Thank you.
Access 2003 without having to install MySQL? Thank you.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jeanette Cunningham
There are some differences between MySql and Access. Do a web search for sql
tutorials on the web, there are many free ones for Access. Here is one
http://www.sqlcourse.com/
Jeanette Cunningham
tutorials on the web, there are many free ones for Access. Here is one
http://www.sqlcourse.com/
Jeanette Cunningham
J
Jeanette Cunningham
Here is another link for basic sql in Access, at this site there also
downloads for intermediate and advanced sql for Access.
http://msdn2.microsoft.com/en-us/library/aa140011(office.10).aspx
Jeanette Cunningham
downloads for intermediate and advanced sql for Access.
http://msdn2.microsoft.com/en-us/library/aa140011(office.10).aspx
Jeanette Cunningham
A
Albert D. Kallal
I am trying to learn SQL. Can you use instructions from an SQL book in
Access 2003 without having to install MySQL? Thank you.
Most of the basic sql examples should work. You can fire up the query
builder, and graphically create sql (that is what most of us do).
You can also hit the SQL button in the query designer, and type raw sql
directly into the window. This is not exactly the same as a command prompt
in MySql, but it is somewhat similar.
So, you can expose the sql used in ms-access, and you can type in sql
directly into the query builder..but, few of us approach tings that way when
you can sit back, relax, and use a mouse + drag and drop to create the sql
without typing in the commands directly....
T
TotallyConfused
Thank you both for responding. I will follow up on the links provided.