CIS Access

Access Project

Independent Challenge 3  You have built an Access database to organize the deposits at a salvage and recycling center. Various clubs regularly  deposit recyclable material, which is measured in pounds when the deposits are made.

 a. Open the Salvage-3.accdb database from the location where you store your Data Files. Enable content if  prompted.

 b. Using the Form Wizard, create a form based on all of the fields in the CenterDeposits query. View the data by  Deposits, use the Columnar layout, and title the form Deposit Listing.  

c. Switch to Layout View, then make each label bold.  

d. Modify the labels so that CenterName is Center Name, DepositDate is Deposit Date, and ClubName is  Club Name.

 e. Switch to Form Design View and resize the CenterName and ClubName text boxes so they are the same height  and width as the Weight text box, as shown in FIGURE 3-20.

 f. Switch to Form View, find and change any entry of A1 Salvage Center to your last name, then print one record  with your name if requested by your instructor.  

g. Using Form View of the Deposit Listing form, filter for all records with your last name in the CenterName field.  

h. Using Form View of the Deposit Listing form, sort the filtered records in descending order on the  DepositDate field.

 i. In Form Design View, narrow the form by dragging the right edge as far left as possible.  

j. Preview the first record, as shown in FIGURE 3-20. If requested by your instructor, print the first record.  

k. Save and close the Deposit Listing form, close the Salvage-3.accdb database, then exit Access.