Chapter 8. Working with Data on Access Forms


  • Using Form View

  • Navigating in a form

  • Editing data in a form

  • Entering pictures and data into OLE fields and Memo fields

  • Using the date picker

  • Switching views

  • Printing a form

  • Understanding form properties

  • Changing the form's layout

  • Setting the tab order

  • Using the Field List

  • Creating a calculated control

In Chapter 7, you learned about the tools necessary to create and display a form — Design View, bound and unbound controls, the Field List, and the ribbon's Controls group. In this chapter, you learn how to work with data on the form, view and change the form's properties, and use Access's new Layout View.


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

Using Form View

Form View is where you actually view and modify data. Working with data in Form View is similar to working with data in a table or query's Datasheet View. Form View presents the data in a user-friendly format, which you create and design.


For more information on working in Datasheet View, see Chapter 6.

To demonstrate the use of the Form View, follow these steps to create a new form based on tblProducts:

  1. Select tblProducts in the Navigation Pane.

  2. Click the Create tab on the ribbon.

  3. Click on the Form command in the Form group.

  4. Click the Form View button on the Home tab's Views group to switch from Layout View to Form View.

Figure 8-1 shows the Access window with the newly created ...

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.