O'Reilly logo

Access® 2010 Bible by Michael R. Groh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

Note

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.

Note

For more information on working ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required