98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Access
Access
Resolved · Low Priority · Version Standard
Thu 7 Feb 2008, 12:07Delegate Alex said...
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?
Mon 11 Feb 2008, 11:45Trainer David said...
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
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Combo box for finding recordsYou can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it |
