microsoft access training class - Microsoft Access 2003 and SQL

The UK's most regular instructor-led training courses.
Training information: microsoft access training class · Courses in microsoft access · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Microsoft Access 2003 and SQL

Dave has attended:
No courses

by - delegate Dave bronze contributer [32 posts] (2007 Jul 27 Fri, 14:57) Reply

Hi,

I was just wondering wheather Microsoft Access 2003 uses SQL. I have had somne experience of Microsoft Access 2003 but know I want to learn how to use sql with Microsoft Access 2003.

Thanks

Dave

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 2 Tue	Southwark	3	book now	£210	£215
2003	2008 Sep 9 Tue	Bloomsbury	6	book now	£193	£215
2002/XP	2008 Sep 11 Thu	Tooting	0	FULL
2003	2008 Sep 19 Fri	Bayswater	5	book now	£195	£205
2007	2008 Sep 23 Tue	Bloomsbury	5	book now	£212	£224
2002/XP	2008 Sep 24 Wed	Tooting	0	FULL
Full Schedule: See all 73 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Microsoft Access 2003 and SQL

by - trainer David gold contributer [428 posts] (2007 Jul 27 Fri, 15:57) Reply

Hi Dave

You will be pleased to know that Microsoft Access 2003 does use SQL. You will be able to see and edit SQL whilst using Microsoft Access 2003, if you go into the SQL view whilst creating a query.

Hope this helps

David

· MS Access Top Tips: Takeaways From Microsoft Access Advanced Training
· Access VBA Training Adds Power to your Databases
· Take an Access Course to Learn About Relational Databases
· Get More Out of MS Access Courses
· The Benefits of Certified Microsoft Training in Access

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips