Access: Form Design Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

 

How Do You Begin?

The longest week I ever wasted was the first time I tried to create a form in Microsoft Access. I cussed and fumed for 40 hours straight. I couldn’t figure out how to put the “blanks” on the form so people could enter and review their data. I might have gotten there faster if I read the book…

 

Designing a simple form

A form helps users fill in the blanks. Forms can be simple: showing one record at a time. Forms can be complex: filtering the records and updating the data automatically every time it is opened.

 

In general, forms are built from tables or queries. The table, or record source, presents the data. The table also provides the form fields. The Front Row Video.mdb has two tables: tblCustomers and tblMovieTitles.

 

Let’s build the first form with a Wizard.