- 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 a Custom Database Template
When you start Access or open a database, you can create a database from an existing template from the Start or New screen. However, if you need a custom template, you can create your own. You can save an entire database as a template, save part of a database as an application part, or save a field or set of fields as a data type template. A database template (.accdt) is a file you can use the create a new database. An application part template (.accdt) are like database templates, however, you can also use them to add elements to an existing database. A data type template (.accft) is a file you can use to create new fields and field combinations. After you create a template file, you can share it with others. When you save a template in the default Access template folder, the database template becomes available on the Start or New screen under the Personal tab (
!), and the application part becomes available on the Applications Parts button on the Create tab.
Create a Custom Database Template or Application Part
- Open the database that you want to create a custom database template or application part.
- Click the File tab and then click Save As.
- Click Save Database As.
- Click Template (.accdt).
- Click Save As.
Specify the following in the Create New Template from This Database dialog box:
- Name. Enter a name for the template file. The template file is saved as name.accdt.
- Description. Enter text as a description, which appears in the tooltip.
- Category. Select User Templates to have it appear under Application Parts.
- Icon. Select an icon (64 x 32 pixels) to display for the template or application part. Click Browse to select it.
- Preview. Select a larger image to display for the template in the Start and New screen or Backstage view. Click Browse to select it.
Primary Table. Select a table for use as the primary table for the application part. This table relates the application part to other tables in a database.
- Instantiation Form. Select a form that opens by default when the template database opens.
- Application Part. Select to save the database as an application part; clear to save the database as a database template.
- Include Data in Template. Select to save the data in the database as part of the template.
- Click OK.
The template file is saved in the default Access templates folder.
- Default templates folder. C:\Users\user name\AppData\Roaming\Microsoft\Templates\Access.
- Click OK.