Use the database wizard

Using Wizards

Wizards are helpers that guide you through a process, step-by-step. For each step, read the explanations and instructions that are provided.

The Wizard will also prompt you for input. Often, the Wizard will 'guess' what you want to achieve, so you may find that the defaults are already correct. But do look at the options that the Wizard provides at each step, answer the Wizard's questions, and make any choices or modifications according to your goal.

After each step, you simply click Next to continue to the next step. When all steps have been completed, you will be able to click Finish.

At any point in the process you can click Back to return to previous steps if you decide to modify your choices. You also have the option to click Cancel to exit the Wizard and your document will be unchanged.

  1. Choose File → New.
  2. In Access 2000, click the Databases tab. In Access 2002 or 2003, click the link General Templates in the New File task pane, then click the Databases tab.
  3. Double-click the wizard of your choice. Follow the prompts and on-screen instructions.
  4. You will be asked where to save the database. Examine the Save in box at the top of the dialog. If the folder is correct, continue to step 5. If not, click the drop-down arrow next to the Save in box and select the correct drive, then double-click folders to navigate down and locate the folder in which you wish to save the database.
  5. Enter a name in the File name box. Click Create.
  6. The Database Wizard will appear, introducing the database type to you. If it is the correct type, click Next, otherwise you may click Cancel.
  7. You will be given the opportunity to review tables and fields. Select each table in the left column and examine which fields will be created. You may add optional fields (shown in italics). You can not delete required fields yet. However, once the Wizard has finished creating the database, you can modify it to meet your needs exactly. After reviewing all tables, click Next.
  8. Select a style for forms. Click Next.
  9. Select a style for reports. Click Next.
  10. Enter a title for the database which will appear on screen. This does not have to be the same as the filename you indicated earlier, which was how the database is saved. If you wish to include a picture or logo on reports, click the appropriate checkbox then click the Picture button and locate the picture.
  11. Click Next.
  12. If you do not wish to launch the database right away, clear (by clicking) the checkbox Yes, start the database.
  13. Click Finish.
Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.