Create a Microsoft Access 2007 Database Using a Template

01
of 06

Choose a Template

Access 2007 screenshot
Mike Chapple

Microsoft provides quite a few prebuilt database templates to assist you in jumpstarting your database development process. In this tutorial, we'll walk through the process of creating an Access 2007 database using these templates.

This tutorial was designed using Microsoft Access 2007 but the steps will be similar for those using earlier versions of Access. If you're using a later version of Access, you may wish to read ​Creating an Access 2010 Database from a Template or ​Creating an Access 2013 Database From a Template.

02
of 06

Open Microsoft Access to the "Getting Started" Screen

Access 2007 screenshot
Mike Chapple

Once you've selected a template, open Microsoft Access. If you already have Access open, close and restart the program so you're viewing the Getting Started screen, as shown in the image above. This will be our starting point for creating our database.

03
of 06

Select the Template Source

Selecting a template source.
Mike Chapple

Next, choose the source of your template from the left pane, as shown in the image above. If you wish to use a template on your local system, click "Local Templates." Otherwise, you can select one of the Office Online template categories to browse templates available on the web.

04
of 06

Click the Template You Selected

Selecting a template.
Mike Chapple

After you select a template source, the right window pane will display all of the templates available from that source, as shown in the image above. Click once on the template you'd like to use to begin the database creation process.

05
of 06

Choose a Database Name

Providing template information.
Mike Chapple

After you select a database template, a new pane will appear in the right portion of the screen, as shown in the image above. You must now name your Access database. You may either use the name suggested by Access or type in your own name. If you'd like to change the database location from the default, click the file folder icon to navigate through the directory structure.

Once you're satisfied with your selections, click the Create button to create your database.

06
of 06

Begin Working With Your Database

Beginning to work with database.
Mike Chapple

That's all there is to it! After a brief delay, Access will open your new database, as shown in the image above. You can either begin entering data immediately by typing in the first open cell or you can explore the features of the template using the navigation pane on the left side of the screen.