- Introduction
- 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
This chapter is from the book
This chapter is from the book
This chapter is from the book
Creating a Custom Database Template
When you create a blank database in the Getting Started with Microsoft Office Access 2007 dialog box, Access uses a database file called Blank.accdb for Access 2007 or Blank.mdb for earlier versions of Access located in the templates folder. If you want to create a custom blank template, you can save your own database file with the name Blank in the templates folder. The new custom blank template can contain any object type you want, such as forms, reports, macros, or additional tables. If you no longer want to use a custom blank database, delete or rename the file named Blank, and Access creates a new default blank database for you.
Create a Custom Blank Template Database
)
)
Start Access, or click the Office button and then click New.
In the left pane, click Featuring.
Click Blank Database.
Click the Browse button.
Click the Save in list arrow, and then select one of the following locations:
-
System template folder. C:\Program Files\Microsoft Office\Templates\1033\Access.
A template in the System folder overrides a template in the User folder.
-
User template folder. C:\Users\user name\Documents (Vista), or C:\Documents and Settings\user name\App Data\Microsoft\Templates (XP).
Click the Save as type list arrow, and then click a file type.
Type Blank.accdb (or Blank.mdb, if you are creating an earlier-version template) in the File name box.
Click OK.
Click Create.
Create a Custom Template Database from an Existing Database
)
)
Start Access, click the Office button and then click Open.
Click the Files of type list arrow, and then click a file type.
If the file is located in another folder, click the Look in list arrow, and then navigate to the file.
Click the database file you want to use as a blank template.
Click Open.
Click the Office button, click Save As, and then select the format you want: Access 2007 Database, Access 2002 - 2003 Database, or Access 2000 Database.
Click the Save in list arrow, and then select one of the following locations:
-
System template folder. C:\Program Files\Microsoft Office\Templates\1033\Access.
-
User template folder. C:\Users\user name\Documents (Vista), or C:\Documents and Settings\user name\App Data\Microsoft\Templates (XP).
Type Blank.accdb (or Blank.mdb, if you are creating an earlier-version template) in the File name box.
Click Save.