Access

The UK's most regular instructor-led training courses.
Training information: access vba courses · Access training · Microsoft Office VBA training

Resolved · Low Priority · Version Standard

Access

Alex has attended:
Access Introduction course
Access Intermediate course

by - delegate Alex [1 post] (2008 Feb 7 Thu, 12:07) Reply

Is it generally considered better to produce as many tables as possible, even if the amount of detail in each table many be only a couple of fields, or will this reduce memory space and speed of use?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jul 9 Wed	Southwark	6	book now	£214	£230
2003/XP	2008 Jul 16 Wed	Bayswater	6	book now	£195	£205
2007	2008 Jul 25 Fri	Bloomsbury	3	book now	£240	£245
2003/XP	2008 Jul 30 Wed	Bloomsbury	0	FULL
2003/XP	2008 Aug 6 Wed	Southwark	6	book now	£214	£230
2003/XP	2008 Aug 18 Mon	Bayswater	5	book now	£195	£205
Full Schedule: See all 57 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Access

by - trainer David gold contributer [428 posts] (2008 Feb 11 Mon, 11:45) Reply

Alex,

It is not best practice to create as many tables as possible! What you need to do is to design your database (what tables you need) so that the is:
1) No data duplication (apart from IDs which are used to link tables)
2) There are no many to many or 1 to 1 relationships (although you can have a 1 to 1 in some cases)

If you do have many to many relationships you will need to re-design that part of the database so that all relationships are many to 1 or 1 to many.

Hope this helps
David

· Microsoft Access: Unleash the True Potential Today
· Microsoft Access Cheat Sheet: Tips and Shortcuts
· The Benefits of Certified Microsoft Training in Access
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps
· Quick Access Database Courses: A 10 Step Lesson in Encrypting and Decrypting an Access Database

Please browse our web site to find out more about
access vba courses and other Microsoft training courses.