• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Lesson 5. Creating a New Database > Creating a Database with Database Wizard

Creating a Database with Database Wizard

A database wizard can create almost all the tables, forms, and reports you will ever need, automatically. The trick is choosing the right wizard to suit your purpose. Follow these steps:

  1. If you just started Access and the Microsoft Access dialog box is still onscreen, click Access database wizards, pages, and projects, and then click OK. Or, if you've already closed the dialog box, select File, New. Either way, the New dialog box appears.

  2. If it's not already on top, click the Databases tab to display the list of wizards.

  3. Click one of the database wizards (the icons with the magic wands across them). For this example, I'll choose Contact Management.

  4. When you've selected the wizard you want, click OK. The File New Database dialog box appears.

  5. Type a name for the database, and then click Create to continue. The wizard starts, and some information appears explaining what the wizard does.

  6. Click Next to continue. A list of the tables to be created appears (see Figure 5.4). The tables appear on the left, and the selected table's fields are on the right.

    Figure 5.4. This wizard creates these tables and fields automatically for you.

  7. Click a table and examine its list of fields. Optional fields are in italics. To include an optional field, click it to place a check mark next to it. Click Next to continue.


    I Don't Want These Tables and Fields! Sorry, that's the price you pay for going with a prefabricated wizard. You can't deselect any fields except the optional (italicized) ones. But you can delete the tables and fields you don't want later. See Lesson 9 to learn how to delete individual fields or an entire table. If the tables and fields appear totally inappropriate, perhaps you're using the wrong wizard for your needs; click Cancel and try another.

  8. The wizard asks you what kind of screen display style you want. Click a display style in the list and examine the preview of the style that appears. After you decide on a style, click it, and then click Next.

  9. The wizard asks you for a style for printed reports. Click a report style and examine the preview of it. When you decide on a style, click it, and then click Next.


    Report Background The colored backgrounds used for some report styles look nice onscreen, but they don't print well on a black-and-white printer. Stick to plain backgrounds for the best report printouts.

  10. The wizard asks what title you want for the database. This title appears on reports and can be different from the file name. Enter a title (see Figure 5.5).

    Figure 5.5. Enter a title for the database, and optionally, choose a graphic to use for a logo.

  11. (Optional) To include a picture on your forms and reports (for example, your company's logo), click the Yes, I'd like to include a picture check box. Then click the Picture button, choose a picture file (change the drive or folder if needed), and click OK to return to the wizard.

  12. Click Next to continue. Then, at the Finish screen, click Finish to open the new database. The wizard goes to work creating your database. (It might take several minutes.)



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint