Create efficient and useful Microsoft Access 2007 forms! This course covers form design from the basics to advanced topics including calculated fields, lookup fields, and subforms. The class will concentrate on creating an efficient user interface through the use of custom dialog boxes. Custom dialog boxes can be used to feed queries, forms or reports. From a single prompt to a full screen of choices, this course will cover the ins and outs of custom dialog box development.

Prerequisites: Access Introduction

Key Topics Covered

1) Create a form using the form wizard and design view.
2) Modify the form’s design (size, move, align) and properties (format)
3) Use controls, such as labels, textboxes, and combo boxes.
4) Create a subform to show related records
5) Create menus and custom dialog boxes.
6) Add command buttons to the custom menus and dialog boxes.
7) Create macros to run from command buttons
8) Change database startup options.