• 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 on-screen, click Database Wizard, then click OK. Or, if you've already closed the dialog box, select File, New Database. Either way, the New dialog box appears.

  2. Click the Databases tab to display the list of Wizards.

  3. Click on one of the Database Wizards. (They're the icons with the magic wands across them.) A preview appears in the Preview area. For this example, I'll choose Contact Management.

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

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

  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.

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

  8. (Optional) If you are creating this database as a learning experience only, click the Yes, include sample data check box. This tells Access to enter some dummy records into the database, so you can see how they will work in the database.

    Figure 5.4. These are the tables and fields that this wizard will create automatically for you.



Not a subscriber?

Start A Free Trial

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