Access 2019 Bible

CHAPTER 18Working 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 ...