O'Reilly logo

Access™ 2007 Bible by Gavin Powell, Joseph C. Stockman, Jennifer Reardon, Michael R. Groh, Michael R. Irwin, Cary N. Prague

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 7. Creating Basic Access Forms

IN THIS CHAPTER

  • 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.

Note

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: ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required