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

Part 5. Using Access > Task 2 How to Use the Database Wizard

Task 2 How to Use the Database Wizard

When you first open Access, you have the option of creating a blank database, using a database wizard, or opening an existing database. The easiest way to create a database is with a database wizard. Access includes several different database wizards that you can use to help you create the tables, forms, and reports you will need. Choose the kind of database you want to build and follow the wizard steps for completing the database structure. To begin, click the General Templates link in the New File task pane. (If the task pane is not visible, choose File, New from the menu bar.)

  1. Choose a Database

    In the Templates dialog box, look through the wizards on the Databases tab to find the type of database you want to create and double-click the wizard name. To create a contact management database, for example, double-click Contact Management. The File New Database dialog box opens.

  2. Name the Database

    Name your new database file. Either accept the name supplied by Access or type your own in the File name text box. Make the name something that will be easily identifiable the next time you want to use the database. Click Create to continue.

  3. Determine the Structure

    The first wizard dialog box tells you that you are creating a database. Click Next. The next dialog box has options for the actual structure of your database, including the tables that will be created and the fields to be included. Choose the table from the left pane and select any additional fields you want to use from the right pane. Click Next.

  4. Choose a Screen Display

    The next dialog box offers you several choices of backgrounds for screen displays and forms in the database. Click each name in the list to display the sample background. Choose a background and click Next.

  5. Choose a Style for Reports

    From the next dialog box, choose the style for your printed reports and click Next to continue.

  6. Enter a Title

    Enter a title for your database (the title can be the same or different from the filename used in Step 2). Indicate whether to include a picture on all reports. (If you choose to include a picture, you must locate the picture file you want to use by selecting that option and clicking the Picture button.) Click Next.

  7. Finish the Wizard

    In the final dialog box, you can choose to start the database immediately (note that "start the database" means to open it). Click Finish to create your new database.



Not a subscriber?

Start A Free Trial

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