- Creating a Custom Database Template
- Planning Tables
- Creating Tables in a Database
- Creating a Table by Entering Data
- Creating a Table Using a Template
- Importing Data into Tables
- Linking to Data in Tables
- Working with Table Records
- Working with a Table in Design View
- Specifying a Primary Key in Design View
- Planning Table Relationships
- Defining Table Relationships
- Creating and Printing a Table Relationship Report
- Ensuring Referential Integrity
- Identifying Object Dependencies
- Modifying Object Dependencies
Creating a Table Using a Template
A table template is a predefined table with fields you can quickly insert and use in a database. Access provides several table templates (New!) including: Contacts, Tasks, Issues, Events, and Assets. You can use the Create tab to quickly insert a table template. After you insert a table template, you can change fields to meet your own needs, and then name and save the table in the database.
Create a Table Using a Template
Click the Create tab.
Click the Table Templates button.
Click the table template (Contacts, Tasks, Issues, Events, or Assets) you want.
To change a field name, double-click the field name, type the new name, and then press Enter.
Click the Save button on the Quick Access Toolbar.
Type a table name.
To have Access set the primary key, click Yes.
When you’re done, click the Close button in the Table window.