SQLConfigurationSQLConfiguration





Building Modified Forms   «Prev  Next»
Lesson 1

Building and modifying Access Forms

One of things Access does best is let you create objects such as forms and reports quickly.
By using wizards, you can create these objects with only a couple of clicks of the mouse. However, although forms and reports can be created quickly, that does not mean they are necessarily powerful tools or all that attractive. When you have forms that are attractive and exciting, people enjoy using the overall application all that much more.
By the end of this module, you will know how to:
  1. Create a form by using Design view and assign a record source
  2. Add a format to an existing form
  3. Insert a graphic onto a form
  4. Know the ways to view a form’s properties
  5. Modify various properties of a form
  6. View some of the ways to change control properties
  7. Work with multiple controls and know how to align and size them all at once
  8. Modify the various form sections (headers, footers, and detail)
As you can see, there is a lot to cover in this module.
In the next lesson, you will learn how to create a form by using Design view and how to assign a record source.

Creating labels and text boxes

If you add a field from the Field List pane, the field is often displayed as a text box with an associated label (attached to the text box). You can add other unbound text boxes and labels from the label and text box controls.
The forms you add to an Access database are a critical aspect of the application you create. In most situations, users should not be permitted direct access to tables or query datasheets. It is far too easy for a user to delete valuable information or incorrectly input data into the table. Forms provide a useful tool for managing the integrity of a database's data. Because forms can contain VBA code or macros, a form can verify data entry or confi rm deletions before they occur. Also, a properly designed form can reduce training requirements by helping the user understand what kind of data is required by displaying a message as the user tabs into a control. A form can provide default values or perform calculations based on data input by the user or retrieved from a database table.