Designing Your Own Database

In Access database design is a complex task that often requires training. Fortunately within Access templates exist to get you started.

Creating a database from a template

Before deciding to build your own database, you may want to look at the templates included in Access to see if any of them match your needs. When you select a template, Access creates a new database based on that template. Once it's created, you can fill the database with your own information or modify it to suit your needs.

To create a database from a template:

  1. Select the File tab. This will take you to Backstage view.
    Clicking the File tab to go to Backstage ViewClicking the File tab to go to Backstage View
  2. On the sidebar, click New.
    Creating a new database in Backstage ViewCreating a new database in Backstage View
  3. Template options will appear. Under the Office.com Templates heading, you can see a list of templates grouped by type. Select the template type that best fits your needs.
    Template groupsTemplate groups
  4. Access will display all of the available templates of that type. Select a template to see more information on it, including a visual preview, on the right.
    Selecting and previewing a templateSelecting and previewing a template
  5. When you have found the template you want to use, click Download. The template will open automatically once it's finished downloading.
    The Download commandThe Download command