Access.06 - COMPREHENSIVE Access Tutor ial 6 Using For m...

Info iconThis preview shows pages 1–10. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: COMPREHENSIVE Access Tutor ial 6 Using For m Tools and Creating Custom For ms New Per spectives on M icr osoft Office Access 2007 2 Objectives Change a lookup field to a Text field View and print database documentation Create datasheet, multiple items, and split forms Modify a form and anchor form controls in Layout view Plan, design, and create a custom form in Design view and in Layout view Select, move, align, resize, delete, and rename controls in a form New Per spectives on M icr osoft Office Access 2007 3 Objectives Add a combo box to a form Add form headers and footers to a form Add a combo box to a form to find records Add a subform to a form Add calculated controls to a form and a subform Change the tab order in a form I mprove the appearance of a form Designing Forms To create a custom for m , you can modify an existing form in Layout view or in Design view, or you can design and create a form from scratch in Layout view or in Design view A combo box is a control that provides the features of a text box and a list box; it lets you choose a value from the list or type an entry New Per spectives on M icr osoft Office Access 2007 4 Designing Forms New Per spectives on M icr osoft Office Access 2007 5 Using the Documenter Start Access and open the database you want to document I n the Analyze group on the Database Tools tab, click the Database Documenter button Select the object(s) you want to document I f necessary, click the Options button to select specific documentation options for the selected object(s), then click the OK button Click the OK button, print the documentation, then close the Object Definition window New Per spectives on M icr osoft Office Access 2007 6 Using the Documenter New Per spectives on M icr osoft Office Access 2007 7 Creating Forms Using Form Tools The Datasheet tool creates a form in a datasheet format that contains all the fields in the source table or query New Per spectives on M icr osoft Office Access 2007 8 Creating Forms Using Form Tools The M ultiple I tems tool creates a customizable form that displays multiple records from a source table or query in a datasheet format New Per spectives on M icr osoft Office Access 2007 9 Creating Forms Using Form...
View Full Document

Page1 / 32

Access.06 - COMPREHENSIVE Access Tutor ial 6 Using For m...

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online