Database Basics - Creating Reports

 

 Go to Lynda.com and watch the Access 2007 Essential Training  with David Rivers - watch the following videos:
Chapter 8 Working with Reports
* Using the Report Wizard - you will create the Customer Phone List report
* Adding custom calculated fields - Order Totals report
* Summarizing Report information - Orders By State report
* Creating a mailing label report - Labels Customers

And answer the following questions as you go through the lessons. As you follow along be sure you are saving the reports you create so you can show them to your instructor for teacher check.

  1. Write a summary of what reports are all about.
  2. A report can be bound or connected to what two DB objects?
  3. What are the three ways of creating a report and which one is the easiest?

Open Access and then open the CreatingRelationshipsDB database that you used in the previous exercises. There are three ways to create a report in Access, using AutoReport, Report Wizard or Design View

1. Use the Report Wizard to create a report that displays each workers last name, first name, salary and Department name. Group workers by their departments and sort the data by salary. Save your report as DeptSalaries.

2. Run your report and print out only the first page of the report. Be sure your name is on the report page.

3. Create a report of your own that is sorted and grouped. Explain the purpose of your report?

4. What are some of the things that reports allow you to do?

5. Print up the first page of your report and include your answers with the reports you turn in. Be sure your name is on the report page.

6. Create a mailing list for all people listed in the table you imported earlier (Contacts) in the Importing/Exporting exercise. Use Avery 5160 labels. Show this report to your instructor for teacher check.