Chapter 7. Creating Basic Access Forms


  • Creating different types of forms

  • Understanding controls

  • Adding controls to a form

  • Using the Field List

  • Using the ribbon's Controls group

  • Selecting controls

  • Manipulating controls

  • Understanding control properties

  • Using the Property Sheet

  • Control naming conventions

Forms provide the most flexible way for viewing, adding, editing, and deleting your data. They are also used for switchboards (forms with buttons that provide navigation), dialog boxes that control the flow of the system, and the o displaying messages. Controls are the objects on forms such as labels, text boxes, buttons, and many others. In this chapter, you learn how to create different types of forms and get an understanding about the types of controls that are used on a form.


In this chapter, you use tblProducts in the Chapter07.accdb database to provide the data necessary to create the examples used in this chapter.

Adding Forms Using the Ribbon

Use the Form group in the Create ribbon to add forms to your database. The commands in the Form group — shown in Figure 7-1 — let you create the following different types of forms:

  • Form: Creates a new form that lets you enter information for one record at a time. You must have a table, query, form, or report open or selected to use this command.

  • Split Form: Creates a split form that shows a datasheet in the upper section and a form in the lower section for entering information about the record selected in the datasheet.

  • Multiple Items: ...

Get Access™ 2007 Bible now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.