CIS 110 Access 4 Assignment

 

Reports, Forms, and Combo Boxes

 Key Concepts
  • 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 box, and title to a form
  • Understand form design considerations

 

Videos
  • No videos posted.

What to do

1.      Create a copy of the database used on the previous project.

Create copies of the databases as follows:

Ashton James College 3.mdb  -->  Ashton James College 4.mdb

City Guide 3.mdb  -->  City Guide 4 .mdb

2.       

 Videos

o                                Copy a database using Windows Explorer - (1:48 - 378KB)

o                                Copy a database using Access Backup feature - (1:11 - 320KB)

 

3.      Complete SAM training and exam for Access 4

4.      Pages AC - Ashton James College; this assignment is not graded or submitted

5.      Instructions Part 1.

A.      Create two reports for the chamber of commerce.

B.      Name the first report Advertiser Account Summary.

C.      Group the report by Advertiser Type, sort the records within the Advertiser Type by Name.

D.      The report also should include the address, amount paid, and balance fields.

E.      Provide subtotals and a grand total for the Balance and Amount Paid fields.

F.       Be sure to align controls appropriately.

G.      See the example solution shown here.  

H.      Name the second report Ad Rep/Advertiser Report

I.        The report should Include the Ad Rep Number, First Name, Last Name, Advertiser Number, Name, Amount Paid and Balance.

J.        Group the report by Ad Rep Number sort the records within the Ad Rep Number by Advertiser Number

K.      Provide subtotals and a grand total for the Balance and Amount Paid fields.

L.       Be sure to align controls appropriately.

M.     See the example solution shown here

 

6.      Instructions Part 2.

A.      Create a form for the chamber of commerce.

B.      Name the form Advertiser Update Form

C.      Your form should include the following fields using the indicated type of control

Advertiser Update Form design

Field

Control

Advertiser Number

text box

Name

text box

Address

text box

Zip Code

text box

Telephone Number

text box

Balance

text box

Amount Paid

text box

Total Amount (calculated field, sum Balance + Amount Paid)

text box

Advertiser Type

combo box

Ad Rep Number

combo box


 

D.      Check alignment and spacing of all controls

E.      Change the default view for the form to Continuous Forms

F.       Change the caption for the form to City Guide Advertiser Update Form.

G.      Sort the data by Name

H.      See the example solution shown here.

I.        Print the form

J.        Exit Access

K.      Upload the completed database as City Guide 4 .mdb

 Solution Images

Advertiser Account Summary

Ad Rep Advertiser Report

City Guide Advertiser Update Form

 

 Grading Rubric

Points

 Requirements

5

Advertiser Account Summary Report

5

Ad Rep/Advertiser Report

5

City Guide Advertiser Update Form

5

Reports & Forms have correct grouping

20

Total possible for uploading City Guide 4.mdb

Drop Box - Upload Your Assignments to the Digital Drop Box

Downloads