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.

 

Sample Microsoft Office Access 2010 Form