Independent Project $6-5$

The New York Department of Motor Vehicles wants to extend the functionality of its database. Create a crosstab query to count the number of tickets by primary factor in each city. Use the top values property in a query. Edit a main report to add a concatenation formula to a text box. Add a subreport to a mainF report. Customize the subreport in Design view and add a running total to number the rows in the report. Finally, you create and customize a stacked bar chart in a new report.

$[$Student Learning Outcomes $6\mathrm{.}2,6\mathrm{.}3,6\mathrm{.}4,6\mathrm{.}5,6\mathrm{.}6,6\mathrm{.}7,6\mathrm{.}8]$

File Needed: NewYorkDMV$-06.$accdb $($Available from the Start File link.$)$

Completed Project File Name: $[$your name$]-$NewYorkDMV$-06.$accdb

Skills Covered in This Project

Create a crosstab query.

Find top values in a query.

Edit multiple controls on a report simultaneously.

Add a control to a report.

Edit formatting properties of a control.

Use a concatenation formula in a text box.

Add a subreport to a main report.

Use an aggregate function on a subreport.

Edit Report Header and Report Footer sections.

Create and customize a chart in a report.