Using a Database Template to Create a Database

You can use the Database Wizard to create a new database based on a template (a Customer database, for example). You can select options provided by the wizard to make the database suit your specific needs. After you have completed the process of running the wizard, you can then modify the design of any of the objects that the wizard creates.

To create a new database by using the Database Wizard, follow these steps:

  1. With the Database window active, select File | New. The New File panel appears on the right-hand side of the screen.

  2. Select On my computer from the list of options that appears below Templates on the right-hand side of the screen (see Figure 6.1). The Templates dialog box appears.

    Figure 6.1. Selecting On my computer from the list of options under Templates.


  3. Select the Databases tab in the Templates dialog box (see Figure 6.2).

    Figure 6.2. Database templates you can use to get started.


  4. Double-click the desired template (for example, Contact Management).

  5. Type the filename and location for the new database.

  6. Click the OK button. The Database Wizard appears.

  7. Click Next. The wizard prompts you with a list of selected tables and fields (see Figure 6.3).

    Figure 6.3. A list of suggested tables and fields.


  8. Scroll down to view the list of optional fields for each table (see Figure 6.4).

    Figure 6.4. A list of optional fields to include in tables.


  9. Click to include the desired optional fields.

  10. Click Next to continue.

  11. Select a style for the forms and click Next.

  12. Select a style for the reports and click Next.

  13. Select a title for the database and, if you want to, select a picture that Access should include on reports. Click Next.

  14. Click Finish to complete the process. The resulting application switchboard should look like the one shown in Figure 6.5.

    Figure 6.5. The application switchboard.




    The Database Wizard creates a switchboard that allows you to very easily add data to tables, view the data entered, and run reports. After you run the wizard, you can add new objects to the database and customize the existing objects to your liking.

  15. Press F11, and the Database window appears.

  16. Click Tables in the list of objects. Notice what tables the wizard has added to the database (see Figure 6.6).

    Figure 6.6. Tables added to the database.


  17. Click the various object categories (tables, queries, and so on) to view the other types of objects that the Database Wizard created.

    Part III: Creating Your Own Database and Objects
    Part V: Advanced Topics