Microsoft Access Tables

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:

Click Here

Preventing Orphan Records

To learn about how to prevent orphan records then click here

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

To learn about how to add a prefix to an autonumber field then click here

This tip will explain how to add a prefix such as 'ABC' to an autonumber field.

Appending Autonumber Field

To learn about how to append data to an Autonumber field then click here.

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

Hiding a table in Microsoft Access

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

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.

Finished with Microsoft Access Tables then Return to Simply Access Home Page