Create a Microsoft Access 2007 Database Using a Template

Start a new database using Access 2007 or later

Database sending data

svilen001 / Stock.xchng

Microsoft provides quite a few prebuilt database templates to assist you in jumpstarting your database development process. There are templates for personal and professional use available. In this tutorial, we'll walk through the process of creating an Access database using these templates.

Instructions in this article apply to Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, and Access 2007.

of 05

Open Microsoft Access to the "Getting Started" Screen

Screenshot of Access templates on Getting Started screen

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.

of 05

Select the Template Source

Screenshot of Access templates

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, select Local Templates. Standard templates include Asset Tracking, Contacts, Task Management, and others, but selecting More Templates will provide a lengthier list. You can also look for other templates online using the Search box.

of 05

Choose a Database Name

Screenshot of Database Name field

After you select a database template, a new pane will appear. You must now name your Access database. You may either use the name suggested by Access or type in a custom 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, select the Create button to create your database.

of 05

Enter Login Information

Screenshot of Access login

Some Access templates will display a Login dialog box. If so, choose a name from the list or select New User.

  1. Fill in the User Details form.
  2. Select Save & Close.
  3. Select the user name you just entered and choose Login.
of 05

Begin Working With Your Database

Screenshot of Enable Content in Access

After a brief delay, Access will open your new database, as shown in the image above. Select the Enable Content button if it appears below the ribbon. This will allow you to begin adding information and editing the database. 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.

Be sure to save any changes to the new database before exiting Access by selecting the Save icon or pressing the keyboard shortcut Ctrl+S.