ms-access-course - Use of Access

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

Resolved · Low Priority · Version Standard

Use of Access

Maureen has attended:
Access Introduction course

by - delegate Maureen [2 posts] (2007 Mar 5 Mon, 09:58) Reply

What is Access

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 25 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Nov 26 Wed	Tooting	0	FULL
2003	2008 Dec 2 Tue	Southwark	5	book now	£198	£215
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
Full Schedule: See all 55 Access Intermediate course dates. Bookings currently available until 24th November 2009.

Use of Microsoft Access

by - trainer David gold contributer [428 posts] (2007 Mar 5 Mon, 10:19) Reply

Hi Maureen

I hope that you learnt lots from your Microsoft Access course.

As you probably know by now, Access is an application produced my Microsoft. It is a database application. This means that MS access works with tables of data that are linked. You can then create queries to extract data from this link tables. For example you if you have a customer table and an order table which are linked, you will be able to extract all the order for a customer.

Hope this helps
David

· Discover the Secrets within Your Business through Microsoft Access Training
· Microsoft Access Tighten your Security Controls
· Reasons to Consider Microsoft Access Training
· Microsoft Access Courses
· Microsoft Access Training Unleashes the Power of the Pivot Table

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