Chapter 8. Working with Data on Access Forms


  • Viewing and modifying data in Form view

  • Editing form data

  • Printing Access forms

  • Understanding form properties

  • Adding form headers and footers

  • Adjusting a form's layout

  • Adding calculated controls to a form

  • Converting a form to a report

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 Layout view.

An Access application's user interface is made up of forms. Forms display and change data, accept new data, and interact with the user. Forms convey a lot of the personality of an application, and a carefully designed user interface dramatically reduces the training required of new users.

Most often, the data displayed on Access forms is bound (either directly or indirectly) to Access tables. Changes made to a form's data affect the data stored in the underlying tables.


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

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

Get Access® 2010 Bible now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.