Chapter 18: 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 17, you learned about the tools necessary to create and display a form — Design view, bound and unbound controls, the Field List, and the Controls group on the Ribbon. In this chapter, you learn how to work with data on the form, view and change the form's properties, and use 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.

On the Web

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

Using Form View

Form view is where you actually view and modify data. The data in Form view is the same data shown in a table or query's Datasheet view, just presented a little differently. Form view presents the data in a user-friendly format, which you create and ...

Get Access 2013 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.