Microsoft Access 2010 Bible

(Rick Simeone) #1

289


CHAPTER


Working with Data


on Access Forms


IN THIS CHAPTER


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

I


n 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 inter-
face 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 CD-ROM
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 cre-
ate and design.

Free download pdf