Creating Advanced Queries and Reports, and Using SQL
Creating Advanced Queries and Reports, and Using SQL
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.
"Check For Understanding" quizzes available in the drop-down menu.
To learn more about the book this website supports, please visit its Information Center.