Forms and Form Design
The first time
I tried to create a form in Microsoft Access
was the longest week I ever wasted. I cussed and ranted 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 was not aware that a Form is
just a pretty face on a Table. You need to have Tables, first. Then, the Form
can help
users fill in the blanks.
Forms can be simple: showing one record at a
time. Forms can be complex as well: filtering records and updating 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 database
has two tables: tblCustomers and tblMovies. This lesson will create a
Form using the Form Wizard.