- Introduction
- 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
This chapter is from the book
This chapter is from the book
This chapter is from the book
Using a Custom Database Template
Instead of creating a database from scratch, you can also create a new database from an existing one you already have. If you have a database that is close to what you want to create, you can select it from the Start or New screen to create an untitled database with the contents of a database template. When you place a template in the default Access template folder, you can select the database template from the Personal tab (New!) in the Start or New screen to create a new database from an existing one.
Create a New Database from a Custom Database Template
Start Access or click the File tab, and then click New.
Click Personal (New!).- Default templates folder. C:\Users\user name\AppData\Roaming\Microsoft\Templates\Access.
Click the custom template you want.
Type in a name for the desktop database.
Click the Browse button, click the Save in list arrow, select a save location, select an Access database format, and then click OK.
Click Create.
A new desktop database appears in the Access window.
)
)
View or Add Templates for Use in Access
- In the desktop, open the File or Windows Explorer.
- Navigate to the default Access templates folder
- Default templates folder. C:\Users\user name\AppData\Roaming\Microsoft\Templates\Access.
If the Access folder is not there, you can create one.
- To add a template to Access, copy and paste it in the default Access templates folder.
- Office.com. You can download Access templates directly from Office.com using your web browser.
- To use the template in Access, click Personal in the Start or New screen.
- Click the custom template you want.
- Type in a name for the desktop database, specify a save location, and then click Create.
A new desktop database appears in the Access window.
)
)