Computer Science Question

Assignment Instructions

Using the provided sample database, use the reporting tools in Access to demonstrate a variety of report functionality.

1. Open the sample database.

For this assignment you will use this sample database:

IT163_ModelCarSampleDatabase.accdb

1. Create a report.

• Create a report of the Model Year, Make and Model for each item from the Products table.Group by model year.Sort by Make and then Model.Use conditional formatting to bold each line item with the make of “Ford.”

Hint: in the Report Layout or Design view, go to the Report Layout Tools Format tab and choose “Conditional Formatting” from the Control Formatting group. Create a “New Rule” to apply conditional formatting to the make field.

Reference: Ulrich, L. A. & Cook, K. (2019). Access 2019 for dummies. Wiley.

Chapter 18: “Fast and Furious Automatic Reporting / Creating a Quick, One-Table Report / Starting the Report Wizard”

Chapter 20: “Groups and Page Breaks, Headers and Footers / A Place for Everything and Everything in its Place”

• You may style the report as you wish otherwise.

• Save the report object as ModelReport.

1. Create labels.

Scenario:

You need to make name tags for each person coming to the model car convention. You should also make sure that every company in your Customers table is represented, but also include the first name from the CustomerContacts table if there are matches.

• First, you must create a query to select the first name from the CustomerContacts table and the company name from the Customers table. Use the appropriate join type to pick up all records from Customers and any matches from CustomerContacts. Save this query as LabelQuery.

Hint: there are two customers in the Customers table who don’t have associated entries in the CustomerContacts table: Hobby Box and Frank’s Fun Factory. If you don’t change the default join type when creating this query, those records won’t be included when you make the labels.

• Next, generate labels (label type of your choice) from the query you just created that show the first name on line one and the company name on line two. Sort by company name.

Hint: Highlight your query in the navigation pane down then left then go to the Reports group on the Create tab and choose Labels.

• Save the report object as CustomerLabels.

Reference: Ulrich, L. A. & Cook, K. (2019). Access 2019 for dummies. Wiley.

Chapter 21: “Mailings to the Masses”

1. Save your Microsoft Access database file for submission.

Assignment Requirements

For this assignment, you will submit your entire Microsoft Access database.