Create a Microsoft Access 2007 database using a template

Content
  1. Choose a template
  2. Open Microsoft Access from the Getting Started screen
  3. Select template source
  4. Click on the template you chose
  5. Select database name
  6. Getting started with your database

Choose a template

Microsoft offers quite a few ready-made database templates to help you speed up your database development process. In this tutorial, we walk through the process of creating an Access 2007 database using these templates.
This guide was developed with Microsoft Access 2007, but the steps are similar to those in previous versions of Access. If you’re using a later version of Access, the procedure is basically the same.

Open Microsoft Access from the Getting Started screen

After choosing a template, open Microsoft Access. If you already have access, close the program and restart it so that you see the Getting Started screen, as shown in the image above. This will be our starting point for creating our database.

Select template source

Then select your template source from the left pane, as shown in the image above. To use the template locally, click Local Templates. Otherwise, you can select one of the Office Online template categories to view the templates available online.

Click on the template you chose

After you select a template source, the right pane of the window lists all available templates from that source, as shown in the image above. Click once on the template you want to use to start the database creation process.

Select database name

After selecting a database template, a new panel will appear on the right side of the screen, as shown in the image above. You now need to name your Access database. You can use the name provided by Access or enter your own name. To change the default database location, click the file folder icon to navigate through the directory tree.
When you are happy with the selection, click the “Create” button to create the database.

Getting started with your database

That’s all! After a short delay, Access opens your new database, as shown in the image above. You can start entering data right away by entering the first open cell or explore the template options using the navigation bar on the left side of the screen.

Leave a Reply

Your email address will not be published.