Microsoft Access 2010 Chapter 4 Lab 1 Presenting Data in the ECO Clothesline Database

Availability: In stock

Regular Price: $20.00

Special Price: $15.00

OR

Microsoft Access 2010 Chapter 4 Lab 1 Customer Balance Report

Double click on above image to view full picture

Zoom Out
Zoom In

More Views

Quick Overview

Microsoft Access 2010 Chapter 4 Lab 1 Presenting Data in the ECO Clothesline Database


Problem: The management of ECO Clothesline already has realized the benefits from the database of customers and sales reps that you created. The management now would like to prepare reports and forms for the database.


Instructions: If you are using the Microsoft Access 2010 Complete or the Microsoft Access 2010 Comprehensive text, open the ECO Clothesline database that you used in Chapter 3. Otherwise, see your instructor for information on accessing the files required in this book.


Perform the following tasks:
1. Open in Layout view the Customer Balance Report you created in Chapter 1 and revised in Chapter 3. Modify the report to create the report shown in Figure 4–81. Group the report by Customer Type and sort by Customer Number within Customer Type. Add the Amount Paid field to the report and include totals for the Balance and Amount Paid fields.


2. Create the Customers by Sales Rep report shown in Figure 4–82. Include a total for the Balance field. Change the orientation to landscape. Make sure the total control displays completely. (Hint: Use Layout view to make this adjustment.)


3. Create the Customer Financial Form shown in Figure 4–83. The form includes the date.


4. Create mailing labels for the Customer table. Use Avery labels C2163 and format the labels with customer name on the first line, street on the second line, and city, state, and postal code on the third line. Include a comma and a space after city and a space between state and postal code. Sort the labels by postal code.


5. Submit the revised database in the format specified by your instructor.

Regular Price: $20.00

Special Price: $15.00

Details

Microsoft Access 2010 Chapter 4 Lab 1 Presenting Data in the ECO Clothesline Database

Problem: The management of ECO Clothesline already has realized the benefits from the database of customers and sales reps that you created. The management now would like to prepare reports and forms for the database.

Instructions: If you are using the Microsoft Access 2010 Complete or the Microsoft Access 2010 Comprehensive text, open the ECO Clothesline database that you used in Chapter 3. Otherwise, see your instructor for information on accessing the files required in this book.

Perform the following tasks:
1. Open in Layout view the Customer Balance Report you created in Chapter 1 and revised in Chapter 3. Modify the report to create the report shown in Figure 4–81. Group the report by Customer Type and sort by Customer Number within Customer Type. Add the Amount Paid field to the report and include totals for the Balance and Amount Paid fields.

2. Create the Customers by Sales Rep report shown in Figure 4–82. Include a total for the Balance field. Change the orientation to landscape. Make sure the total control displays completely. (Hint: Use Layout view to make this adjustment.)

3. Create the Customer Financial Form shown in Figure 4–83. The form includes the date.

4. Create mailing labels for the Customer table. Use Avery labels C2163 and format the labels with customer name on the first line, street on the second line, and city, state, and postal code on the third line. Include a comma and a space after city and a space between state and postal code. Sort the labels by postal code.

5. Submit the revised database in the format specified by your instructor.

Product Tags

Use spaces to separate tags. Use single quotes (') for phrases.