- Creating a Custom Database Template
- Using a Custom Database Template
- Planning Tables
- Creating Tables in a Database
- Creating a Table by Entering Data
- Creating an Application Part 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 an Application Part Using a Template
An application part template is a predefined portion of a database, such as a table or form, or an entire database application that you can quickly insert and use in a database. Access provides several templates including: Comments, Contacts, Issues, Tasks, Users, and Blank Forms. You can also create your own custom application part template from a database. You can use the Create tab to quickly insert an application part template. When you insert an application part, such as Contacts, you get a table, form, and report, and the option to create a relationship. After you insert an application part, you can add and change fields to meet your own needs, and then name and save it in the database.
Create an Application Part Using a Template
- Click the Create tab.
- Click the Application Parts button.
- Click a template (Blank Forms and Quick Starts: Comments, Contacts, Issues, Tasks, or Users) you want.
- Follow the Create Relationship wizard as prompted to create a simple relationship.
- Add information and data to the template.
- When you’re done, click the Close button in the window.