Assignment 4

Access 2007

The Basic Goal of BCIS is to SOLVE PROBLEMS using a computer!

Name: _________________

Please place this page on the top of your work, as a cover page. All work is due on the day of the Access hands-on test. The tutorial assignments(1-3) MUST be checked off in class. STEP NUMBER ON EACH PRINTOUT!

1. ____/ 10 Work through Tutorial 1 (AC 1-35).Have the tutorial checked off in class.

2. ____/10 Work through Tutorial 2 (AC45-87). Have the tutorial checked off in class.

3. ____/20 Work through Tutorial 3 pages AC 99-143. Have the tutorial checked off in class. Queries that will be graded include:
AC110 – “Customer e-mail” Query
AC130 – “Key Lansing Customers” Query
AC137 – “Unpaid Invoices with late fees” Query
AC141 – “Contract Amount Statistics by City” Query

4. ____/50 Access Capstone Project 1 Appendix B Pages CAP14-16 –stop after step 18
Print the Class, Pledge, Donor &Fund tables,
Print Queries Large Pledges(after step 13), Small or Immigration Pledges, Small and Immigration Pledges, Pledges After Cost, Pledge Statistics By Fund(after step 18)

5. ____/10 Log into eLearning. Take the Access Pretest. Print your results and attach to this assignment

_____/100 Points

_____ -10 Assignments not in order

_____ -10 No assignment sheet

_____ -10 per class day late

_____ Final points