After completing this chapter, you will be able to: SLO 6.1 | Understand action queries; create and use Update, Append, Delete, and Make Table queries. | SLO 6.2 | Use the Query Wizard to create a crosstab query, a find duplicate records query, and a find unmatched records query. | SLO 6.3 | Use the top values property, explore and use date functions, and create a query with a subquery. | SLO 6.4 | Understand report sections, build a report and add and delete fields in Design view, understand the data source of a report, and create a parameter report. | SLO 6.5 | Use Design view to add a control to a report; modify the size, location, font characteristics, and formatting properties of a control; and change properties of multiple controls. | SLO 6.6 | Use calculations in a control on a report, create a running total in a control, and concatenate text data in a report. | SLO 6.7 | Understand when to use a subreport, create a main report and a subreport, add a subreport onto a main report, and customize a subreport. | SLO 6.8 | Understand SQL ( Structured Query Language) and create and execute simple SQL statements using the Select, From, Where, and Order By clauses. |
|