Individual Assignment 3: Database Reflection - 10%
COURSE Advanced Computer Application (COMP4008)
DUE DATE/TIME Monday, 15-June-2024 @11:59 pm
GETTING STARTED
• Open the file Assignment_3_start_file.accdb
• Save the file as Firstname_LastName_ Assignment_3.accdb by including your Firstname and LastName
e.g. Tarun_Sethi_ Assignment_3.accdb
PROJECT STEPS
1. Open the Basic Billboards List report in Layout View. Group the report by the State field, and
then sort the report by the BillboardID field in ascending order. Do not add any additional
grouping or sorting options to the report. Close the Group, Sort & Total pane. (Hint: Click the
Group & Sort button.) Save and close the Basic Billboards List report. [1.0 pt]
2. Modify the Advertiser Financial Report to match Figure 1 on the following page by performing
the following tasks: 2 pts[1.0 pt]
a. Open the Advertiser Financial Report in Layout View.
b. Sum the values in the Amount Paid column and the Current Due column for each state’s
advertisers and for all advertisers.
c. Switch to Print Preview to view the report and to check that the values in the subtotal
control and the total control are displayed completely.
d. Return to Layout View and, if necessary, expand the size of the subtotal control and the
total control so that they are displayed completely.
Save the report without closing it.
3. With the Advertiser Financial Report still open in Layout View, apply conditional formatting to
the Current Due column. If the amount currently due is greater than $6,000, display the value in
bold, Green font (7th column, 1st row of the Standard Colors palette).
Save the report again, and then close it. 1 pts[1.0 pt]
4. Open the Advertiser by AdRep Report in Layout View, and then create a summary report. (Hint:
To create a summary report, hide the detail lines.) Save and close the report. [0.5 pt]
5. Open the AdRep Phone List report in Layout View. Apply the Office theme to this object only.
Save and close the report. .5 pt[1.0 pt]
Shelly Cashman Access 2016 | Module 4: SAM Project 1a
Figure 1: Advertiser Financial Report
6. Use the Report Wizard to create the report shown in Figure 2 on the next page. The report is
based on the Advertiser and Rentals tables and should include the following options: [1.0 pt]
a. Include the AdvertiserID and AdvertiserName fields from the Advertiser table.
b. Include the RentalID and BillboardID fields from the Rentals table.
c. The data will automatically be grouped by the AdvertiserID field, but do not add any
additional grouping levels.
d. Sort the report by the RentalID field in ascending order.
e. Use the Stepped layout and Landscape orientation.
f. Save the report as Advertisers and Rentals Report. (Hint: Do not include the (.) period
following Report.)
Preview the report, and then close it.
7. Open the AdRep Contact Form in Layout View, and then modify the form by performing the
following tasks: [1.0 pt]
a. Select all the labels and controls in the Detail section of the form. (Hint: Do not select
the form title label in the Form Header section.)
b. Place the selected controls in the Stacked control layout.
c. Add the DateHired control after the PhoneNumber control as shown in Figure 5 on the
next page.
Shelly Cashman Access 2016 | Module 4: SAM Project 1a
d. Move the LastName control after the FirstName control as shown in Figure 3. (Hint: Be
sure to select both the label and the control for the LastName field.)
Save and close the form.
Figure 2: Advertisers and Rentals Report
8. Open the Rentals Update Form in Layout View, and then bold the BeginDate control. Save and
close the form. [0.5 pt]
9. Open the States Entry Form in Layout View, and then add the current date to the form. Use the
option button for the second date format. Do not include the time on the form. Save and close
the form. [1.0 pt]
10. Open the Advertiser Address Form in Form View, and then use the Advanced Filter/Sort option
to create a filter with the following properties: [1.0 pt]
a. The records in the form should be sorted in ascending order by the AdvertiserName
field.
b. The form should only return records where the State field contains “OR”.
c. Toggle the filter to confirm it is working. (Hint: There should only be nine records
included in the form.)
Save and close the form.
Shelly Cashman Access 2016 | Module 4: SAM Project 1a
Figure 3: AdRep Contact Form
11. Use the Form Wizard to create a form based on the Billboard table with the following
options:[1.0 pt]
a. Include the BillboardID, Location, City, State, Type, and DEC fields (in that order) on the
form.
b. Select the Columnar layout for the form
c. Save the form as Basic Billboard Form. (Hint: Do not include the (.) period following
Form.)
Close the form.
Save and close any open database objects.
Submit your work on Brightspace by Monday, 19th June 2023 @ 11: 59 pm
