This page on Microsoft Access Tables, will in the future consist of lots of tips, questions/answers about Tables and the use of them in Microsoft Access. If you wish to know the basics on how to create Microsoft Access tables, then I suggest you download my free tutorial. This does not only include how to create tables in Microsoft Access, but will step you through the entire process of building your first database in MS Access. To learn the basics of Microsoft Access then:
Preventing Orphan Records
This tip will explain how to set up your tables so that records in a sub-table are always linked to a record in the main table.
Adding Prefix to an Autonumber Field
This tip will explain how to add a prefix such as 'ABC' to an autonumber field.
Appending Autonumber Field
There may be times when you import numbers (they maybe of data type AutoNumber or not) into an AutoNumber field which is also (and usually) your primary key. This tip explains how to append data from another table or data source to an autonumber field.
Hiding a table
Is there data in a table that you do not want your users to easily see. This tip will show you how to hide a table.
Printing a report with all your relationships
Do you have relationships in your database, that you would like to share with someone else or to print off to study yourself, then this tip should help you out.