Griffin | Computer Apps II
 
Resume Table of Contents  

Computer Apps II
Access - Project 4

Project 5
Enhancing Forms with OLE Fields, Hyperlinks, and Subforms

 
1. Access Project 5 Assignment
Duration: 2 Periods
  Read the Case Perspective, Objectives, Intro, and Project Preview. p. 258 -302
 

Chapter 5 Power Point

Objectives:

  • Use date, memo, OLE, and hyperlink fields
  • Use the Input Mask wizard
  • Update fields and enter data
  • Change row and column size
  • Create a form with a subform using the Form wizard
  • Modify a subform design
  • Modify a form design
  • Move and resize fields and labels
  • Change label alignment and size
  • Change the size mode of a picture
  • Change special effects and colors of labels
  • Add a form title and fine-tune the form
  • Change tab stops and tab order
  • Use the form to view data and Web pages
  • Use Date and Memo fields in a query
  • View object dependencies
2.

Complete Project 5. Type your name and date in the Form Header. Also add Ashton James in the head as shown. Print the Trainer Master Form as shown and hand into the instructor.

Project 5 Trainer Master Form

Grading:
1. Project 5 Trainer Master Form  ___ 10 points
Total  
 ___ 10 points
p. 258 -302
3. Excel AYK 1 Assignment
Duration: 1 Period
p. 304 - 305
 

Complete the Apply Your Knowledge 1 Assignment. Print screen the Table. Print the Query, and make sure to Add Begon Pest Control to the Form. (See examples below.)

Note: In order to Print Sceen: When you have the table expanded on your screen, hit the "Print Screen" key on the top-right of your keyboard above the Insert key. Switch to a Word document and Choose "Edit/Paste". After the image is pasted into Word you can double click on the image and choose Layout/Square to resize and move the image.)

Apply 5-1 Begon Technician Table
Apply 5-1 Begon Technician Query
Apply 5-1 Begon Technician Form

Grading:
1. Apply 5-1 Begon Technician Table  ___ 3 points
2. Apply 5-1 Begon Technician Query  ___ 2 points
3. Apply 5-1 Begon Technician Form  ___ 5 points
Total  
 ___ 10 points
 
4.

Excel ITL 1 Assignment
Duration: 1 Period

p. 306 - 307
 

Complete the In The Lab 1 Assignment. Print screen the Table. Make sure to Add Birds2U to the Form and print the Query. (See examples below.)

Lab 5-1 Birds2U Supplier Table
Lab 5-1 Birds2U Supplier Master Form
Lab 5-1 Birds2U Supplier Query

Grading:
1. Lab 5-1 Birds2U Supplier Table  ___ 5 points
2. Lab 5-1 Birds2U Supplier Master Form  ___ 3 points
3. Lab 5-1 Birds2U Supplier Query  ___ 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. CH5 Quiz Optional – Complete the Online Practice Test  

top