O'Reilly logo

Access™ 2007 Bible by Gavin Powell, Joseph C. Stockman, Jennifer Reardon, Michael R. Groh, Michael R. Irwin, Cary N. Prague

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

  • Using Form View

  • Navigating in a form

  • Editing data in a form

  • Entering pictures and data into OLE fields and Memo fields

  • Using the date picker

  • Switching views

  • Printing a form

  • Understanding form properties

  • Changing the form's layout

  • Setting the tab order

  • Using the Field List

  • Creating a calculated control

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 new Layout View.

Note

In this chapter, you use tblProducts in the Chapter08.accdb database to provide the data necessary to create the examples used in this chapter.

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 in Datasheet View, see Chapter 6.

To demonstrate the use of the Form View, follow these steps to create a new form based on tblProducts:

  1. Select tblProducts in the Navigation Pane.

  2. Click the Create tab on the ribbon.

  3. Click on the Form command in the Form group.

  4. Click the Form View button on the Home tab's Views group to switch from Layout View to Form View.

Figure 8-1 shows the Access window with the newly created ...

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