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.
- Go to the Forms section in Access.
- Double-click 'Create form by using wizard'.
- Select tbl_Sales from the drop-down box 'Tables/Queries'.
- Depending on the fields you want, click the single arrow to add selected fields or the double arrow to add all fields.
- Select the Columnar layout and click Next.
- Select any style and click Next.
- Change the title as desired and click Finish.
- Open your form and check it out.
- 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.