Office 2007 Bible

Chapter 35. Creating and Entering Data with Basic Access Forms

In This Chapter

Creating different types of forms Understanding controls Adding controls to a form Using the Field List Using the Ribbon’s Controls group Selecting controls Manipulating controls Understanding control properties Using the Property Sheet Control naming conventions 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

Forms provide the most flexible way of viewing, adding, editing, and deleting your data. They are also used for switchboards (forms with buttons that provide navigation), dialog boxes that control the flow of the system, and displaying messages. Controls are the objects on forms such as labels, text boxes, buttons, and many others. In this chapter, you learn how to create different types of forms and get an understanding about the types of controls that are used on a form. You also learn how to enter data with a form and print a form.

ON the WEB

In this chapter, you use tblProducts in the Chapter35.accdb database to provide the data necessary to create the examples used in this chapter. That example database is available for download from http://www.wiley.com/TOCOME. When you open the file, you can click Options in the Security Warning bar, click Enable This Content in the Microsoft Office Security Options dialog box, and then click OK.