Home > Articles

  • Print
  • + Share This
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

yellow_circle_1.gif Start Access, or click the Office button and then click New.

yellow_circle_2.gif In the left pane, click Featuring.

yellow_circle_3.gif Click Blank Database.

yellow_circle_4.gif Click the Browse button.

yellow_circle_5.gif 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).

yellow_circle_6.gif Click the Save as type list arrow, and then click a file type.

yellow_circle_7.gif Type Blank.accdb (or Blank.mdb, if you are creating an earlier-version template) in the File name box.

yellow_circle_8.gif Click OK.

yellow_circle_9.gif Click Create.

Create a Custom Template Database from an Existing Database

yellow_circle_1.gif Start Access, click the Office button and then click Open.

yellow_circle_2.gif Click the Files of type list arrow, and then click a file type.

yellow_circle_3.gif If the file is located in another folder, click the Look in list arrow, and then navigate to the file.

yellow_circle_4.gif Click the database file you want to use as a blank template.

yellow_circle_5.gif Click Open.

yellow_circle_6.gif 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.

yellow_circle_7.gif 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).

yellow_circle_8.gif Type Blank.accdb (or Blank.mdb, if you are creating an earlier-version template) in the File name box.

yellow_circle_9.gif Click Save.

  • + Share This
  • 🔖 Save To Your Account