Griffin | Computer Apps II
 
Resume Table of Contents  

Computer Apps II
Access - Project 4

Project 4
Reports, Forms, and Combo Boxes

 
1. Access Project 4 Assignment
Duration: 2 Periods
  Read the Case Perspective, Objectives, Intro, and Project Preview. p. 193 -247
 

Chapter 4 Power Point

Objectives:

  • Create a report using the Report Wizard
  • Use sorting and grouping in a report
  • Move controls
  • Change properties
  • Add totals and subtotals to a report
  • Align and format controls
  • Remove controls
  • Change labels and column headings
  • Use multiple tables in a report
  • Remove unwanted controls
  • Understand report design considerations
  • Use the Form Wizard to create a form
  • Add a calculated field, combo boxes, and a title to a form
  • Understand form design considerations
2.

Complete Project 4. Type your name and date in the Report Header. Also Add Ashton James to the header. Print the Client Account Summary and Trainer/Client Report as shown and hand into the instructor.

Project 4 Client Account Summary
Project 4 Trainer/Client Report

Grading:
1. Project 4 Client Account Summary  ___ 5 points
2. Project 4 Trainer/Client Report  ___ 5 points
Total  
 ___ 10 points
p. 193 -247
3. Excel AYK 1 Assignment
Duration: 1 Period
p. 249
 

Complete the Apply Your Knowledge 1 Assignment. Type your name and date in the Report Header. Print the linked report and form and hand it into the instructor.

Apply 4-1 Begon Technician/Customer Report
Apply 4-1 Begon Customer Update Form

Grading:
1. Apply 4-1 Begon Technician/Customer Report  ___ 5 points
2. Apply 4-1 Begon
Customer Update Form
 ___ 5 points
Total  
 ___ 10 points
 
4.

Excel ITL 1 Assignment
Duration: 1 Period

p. 250 - 251
 

Complete the In The Lab 1 Assignment. Type your name and date in the report Header. Print all three documents and hand into the instructor.

Lab 4-1 Birds2U On Hand Value Report
Lab 4-1 Birds2U Supplier/Item Report
Lab 4-1 Birds2U Item Update Form

Grading:
1. Lab 4-1 Birds2U On Hand Value Report  ___ 5 points
2. Lab 4-1 Birds2U Supplier/Item Report  ___ 3 points
3. Lab 4-1 Birds2U Item Update Form  ___ 2 points
Total  
 ___ 10 points
5.

Excel ITL 2 Assignment
Duration: 1 Period

p.
 

Complete the In The Lab 2 Assignment. Type your name and date in the left header. Print and hand into the instructor.

Lab 4-2 Babbage Client Income Report

Grading:
1. Lab 4-2 Babbage Client Income Report  ___ 10 points
Total  
 ___ 10 points
6.

Excel ITL 3 Assignment
Duration: 1 Period

p.
 

Complete the In The Lab 3 Assignment. Type your name and file name in the lower left footer. Print and hand into the instructor.

Lab

Grading:
1. Lab  ___ 10 points
2.    ___ 10 points
Total  
 ___ 10 points
7.

Excel Cases and Places Assignment
Duration: 2 Periods

 
 

 

Grading:
1.    ___ 10 points
Total  
 ___ 20 points
 
8. CH4 Quiz Optional – Complete the Online Practice Test  

top