Alex has attended:
Access Introduction course
Access Intermediate course
Access
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?
RE: Access
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
