Access Chapter 4 – Create, Edit and Perform Calculations in Reports:
Creating Professional and Useful Reports

Table of Contents

Lesson Plan...... 2

Solution for Ch 4 Homework (Hands-On Exercises in Chapter).... 4

Capstone Exercise for Ch 4 (End of Chapter Capstone Exercise).. 7

Solution for Capstone Exercise...... 8

1

Access Chapter 4 – Create, Edit and Perform Calculations in Reports: Creating Professional and Useful Reports

Materials Needed

Description of Document / Name of Document / Location of Files
Solution to Homework Hands-on Exercises for Access Chapter 4 / Chap4_ho1-3_coffee_solution.accdb
Chap4_ho1_coffee_solution.accdb
Chap4_ho2_coffee_solution.accdb
chap4_ho3_coffee_solution.accdb / Exploring Access2007
Chapter 4 Folder on
Instructor Resource Disk
or

Capstone Exercisefor Access Chapter 4 / ExplOffice2007_AccessCh4CE.docx
Solution for
Capstone Exercise for Access Chapter 4 / AccessCh4Capstone_solution.accdb
AccessCh4Capstone_solution.docx
Answer Key for MyITLab Access Chap 4 / AnswerKey_MyITLab_Access_Chap_4

Class Run-Down

  1. Have students turn in Homework assignments.
  2. Talk about chapter using discussion questions listed below.
  3. Demonstrate Access 2007.
  4. Direct students to the MyITLab site to complete the following:
  5. Access Chapter 4Pre-Test
  6. Study Plan
  7. Access Chapter 4Post-Test
  8. Have students complete Capstone Exercise for Access Chapter 4.
  9. Give students Homework Handout for next class period.

Learning Objectives

At the end of this lesson students should be able to:

▪Plan a report.

▪Use different report views.

▪Create and edit a report.

▪Identify report elements, sections, and controls.

▪Add grouping levels in Layout View.

▪Add fields to a report.

▪Use the Report Wizard.

Discussion Questions

▪What is a report? Why is it important to plan the layout of a report?

▪What are the steps in planning a report?

▪How many different report views are there in Access? Name them.

▪Why should you always print preview your report before printing?

Additional Web Resources

From Microsoft Office Online for Access 2007:

  • Create a report
  • Modify, edit, or change a report
  • Summing in reports
  • Create a grouped or summary report

Demonstrate how to:

▪Use different report views.

▪Create and edit a report.

▪Identify report elements, sections, and controls.

▪Add grouping levels in Layout View.

▪Add fields to a report.

▪Use the Report Wizard.

1

Access Chapter 4 – Create, Edit and Perform Calculations in Reports: Creating Professional and Useful Reports

Chap4_ho1_coffee_solution.accdb

No printouts required for this exercise

1

Access Chapter 4 – Create, Edit and Perform Calculations in Reports: Creating Professional and Useful Reports

Chap4_ho2_coffee_solution.accdb

No printouts required for this exercise

Chap4_ho1-3_coffee_solution.accdb

1

Exploring Office 2007 Access Chapter 4 Capstone Exercise

Student Name: ______Section: ______
Due Date: ______00 Points PossiblePoints Earned:______

Objectives

  • Given a database create queries that can be used to analyze data and help make decisions in different scenarios.

Preparation Helpful Information

Read Chapter 4 – “Create, Edit and Perform Calculations in Reports: Creating Professional and Useful Reports” located in the Microsoft Office 2007 Professional book.

Check each step before continuing; it is easy to skip one when you hurry.

If you are not familiar with Access, allow yourself extra time for the exercises.

Read this assignment sheet first before you complete any assignments. Many times there will be additional instructions not included in your book.

Instructions

Designate one disk for your Access assignments, as these files take up a lot of space.

TASK 1: Read Access Chapter 4, pages 000-000.

TASK 2: Complete Capstone Exercise: National Conference on page 00.

TASK 3: Print the results from Step F underAdditional Field

TASK 4: Save your file to a disk.

When you complete your assignment, do the following:

Turn in your printout and disk to your instructor.

1

Access Chapter 4 – Create, Edit and Perform Calculations in Reports: Creating Professional and Useful Reports

AccessCh4Capstone_solution.docx

1