April 2013
Intermediate to advanced
1296 pages
31h 42m
English
Chapter 18: 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
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 ...
