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.
Additional Information
| Special Price | $15.00 |
|---|
Check items to add to the cart or select all
-
Microsoft Access 2010 Chapter 3 Lab 1 Maintaining the ECO Clothesline Database
Add to WishlistRegular Price:
Special Price
You have no items in your shopping cart.
