How to Create Form by Using Wizard

Microsoft Access Forms are used to simplify viewing, adding, or editing data in an Access database. Well-designed forms improve efficiency and accuracy, especially when multiple users are involved.

How to Create Form Using Wizard
  1. Go to the Forms section in Access.
  2. Double-click 'Create form by using wizard'.
    Form setup screenshot
  3. Select tbl_Sales from the drop-down box 'Tables/Queries'.
    Form setup screenshot
  4. Depending on the fields you want, click the single arrow to add selected fields or the double arrow to add all fields.
    Form setup screenshot
  5. Select the Columnar layout and click Next.
  6. Select any style and click Next.
  7. Change the title as desired and click Finish.
    Form setup screenshot
  8. Open your form and check it out.
    Form setup screenshot
Four Different Form Formats
  • Single Table FormA form corresponding to a single database table. Functional but basic, used to complete different tasks.
  • Single Table Form with Lookup FieldDisplays data from another table or database, or summarized values from a data range.
  • Master/Detail FormA master form directs one or more subforms, creating a parent/child relationship.
  • Master/Detail Form with Lookup FieldSimilar to master/subform relationship but includes lookup fields in either the master or subforms.

Have a question? Ask us!