new perspectives: access.04
DESCRIPTION
Microsoft Access 2010; New Perspectives, published by Course TechnologiesTRANSCRIPT
![Page 1: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/1.jpg)
®
Microsoft Access 2010
Tutorial 4
Creating Forms and Reports
![Page 2: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/2.jpg)
XPXPXPObjectives• Create a form using the Form Wizard• Apply a theme to a form• Add a picture to a form• Change the color and line type of items on a
form• Find and maintain data using a form• Preview and print selected form records
New Perspectives on Microsoft Access 2010 2
![Page 3: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/3.jpg)
XPXPXPObjectives• Create a form with a main form and a subform• Create a report using the Report Wizard• Apply a theme to a report• Resize fields in a report• Insert a picture in a report• Use conditional formatting in a report• Preview and print a report
New Perspectives on Microsoft Access 2010 3
![Page 4: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/4.jpg)
XPXPXPForm Displayed in Form View
New Perspectives on Microsoft Access 2010 4
![Page 5: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/5.jpg)
XPXPXPCreating a Form Using the Form Wizard• The Form Wizard allows you to choose some
or all of the fields in the selected table or query, choose fields from other tables and queries, and display the selected fields in any order on the form
• Click the Create tab in the Ribbon• In the Forms group, click the Form Wizard
button
New Perspectives on Microsoft Access 2010 5
![Page 6: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/6.jpg)
XPXPXPCreating a Form Using the Form Wizard
New Perspectives on Microsoft Access 2010 6
![Page 7: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/7.jpg)
XPXPXPCreating a Form Using the Form Wizard
New Perspectives on Microsoft Access 2010 7
![Page 8: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/8.jpg)
XPXPXPApplying a Theme to a Form• Display the form in Layout view• In the Themes group on the Design tab, click
the Themes button• In the displayed gallery, click the theme you
want to apply to all objects; or, right-click the theme to display the shortcut menu, and then choose to apply the theme to the current object only or to all matching objects
New Perspectives on Microsoft Access 2010 8
![Page 9: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/9.jpg)
XPXPXPAdding a Picture to a Form• A picture is one of many controls you can add
and modify on a form• A control is an item on a form, report, or other
database object that you can manipulate to modify the object’s appearance
• In the Header/Footer group on the Design tab, click the Logo button
• Navigate to the picture you want to insert and then click the OK button
New Perspectives on Microsoft Access 2010 9
![Page 10: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/10.jpg)
XPXPXPAdding a Picture to a Form
New Perspectives on Microsoft Access 2010 10
![Page 11: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/11.jpg)
XPXPXPChanging the Color of the Form Title
• The Font group on the Format tab provides many options you can use to change the appearance of text on a form
New Perspectives on Microsoft Access 2010 11
![Page 12: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/12.jpg)
XPXPXPChanging the Type of Line on a Form
• A line on a form, such as the box around each field value, is another type of control that you can modify in Layout view
New Perspectives on Microsoft Access 2010 12
![Page 13: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/13.jpg)
XPXPXPFinding Data in a Form or Datasheet• Open the form or datasheet, and then select the field you
want to search• In the Find group on the Home tab, click the Find button
to open the Find and Replace dialog box• In the Find What box, type the field value you want to
find• Complete the remaining options, as necessary, to specify
the type of search to conduct• Click the Find Next button to begin the search• Click the Find Next button to continue searching for the
next match• Click the Cancel button to stop the search operation
New Perspectives on Microsoft Access 2010 13
![Page 14: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/14.jpg)
XPXPXPFinding Data in a Form or Datasheet
New Perspectives on Microsoft Access 2010 14
![Page 15: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/15.jpg)
XPXPXPFinding Data in a Form or Datasheet
New Perspectives on Microsoft Access 2010 15
![Page 16: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/16.jpg)
XPXPXPMaintaining Table Data Using a Form
• Maintaining data using a form is often easier than using a datasheet, because you can concentrate on all the changes required to a single record at one time
New Perspectives on Microsoft Access 2010 16
![Page 17: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/17.jpg)
XPXPXPPreviewing and Printing Selected Form Records• Access prints as many form records as can fit
on a printed page
New Perspectives on Microsoft Access 2010 17
![Page 18: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/18.jpg)
XPXPXPReport in Print Preview
New Perspectives on Microsoft Access 2010 18
![Page 19: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/19.jpg)
XPXPXPCreating a Form with a Main Form and a Subform• When you create a form containing data from
two tables that have a one-to-many relationship, you actually create a main form for data from the primary table and a subform for data from the related table
New Perspectives on Microsoft Access 2010 19
![Page 20: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/20.jpg)
XPXPXPCreating a Form with a Main Form and a Subform
New Perspectives on Microsoft Access 2010 20
![Page 21: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/21.jpg)
XPXPXPCreating a Report Using the Report Wizard• The Report Wizard asks you a series of
questions and then creates a report based on your answers
• A report is a formatted printout of the contents of one or more tables or queries in a database
• You can change the report’s design after you create it
New Perspectives on Microsoft Access 2010 21
![Page 22: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/22.jpg)
XPXPXPCreating a Report Using the Report Wizard• Click the Create tab on the Ribbon• In the Reports group on the Create tab, click
the Report Wizard button
New Perspectives on Microsoft Access 2010 22
![Page 23: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/23.jpg)
XPXPXPCreating a Report Using the Report Wizard
New Perspectives on Microsoft Access 2010 23
![Page 24: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/24.jpg)
XPXPXPCreating a Report Using the Report Wizard
New Perspectives on Microsoft Access 2010 24
![Page 25: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/25.jpg)
XPXPXPCreating a Report Using the Report Wizard
New Perspectives on Microsoft Access 2010 25
![Page 26: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/26.jpg)
XPXPXPModifying a Report’s Design in Layout View• Click the Layout View button on the status bar
New Perspectives on Microsoft Access 2010 26
![Page 27: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/27.jpg)
XPXPXPModifying a Report’s Design in Layout View
New Perspectives on Microsoft Access 2010 27
![Page 28: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/28.jpg)
XPXPXPUsing Conditional Formatting in a Report• Conditional formatting in a report (or form) is
special formatting applied to certain field values depending on one or more conditions
• Click the appropriate field value• In the Control Formatting group on the Format
tab, click the Conditional Formatting button• Click the New Rule button
New Perspectives on Microsoft Access 2010 28
![Page 29: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/29.jpg)
XPXPXPUsing Conditional Formatting in a Report
New Perspectives on Microsoft Access 2010 29
![Page 30: New Perspectives: Access.04](https://reader035.vdocuments.us/reader035/viewer/2022062319/5539cc6e550346bb318b4a57/html5/thumbnails/30.jpg)
XPXPXPUsing Conditional Formatting in a Report
New Perspectives on Microsoft Access 2010 30