DB903 - Advanced Applications of Access
Course Description
This course covers a variety of advanced tips and techniques for designing and using Access databases. Learn to write special purpose queries, including crosstab and union queries, and design reports that include running sums and conditional formatting. Practice using text, date, and conditional functions to manipulate data. Create complex parameter queries and custom forms to supply parameter values. Additional topics include inserting subreports and using PivotTables and PivotCharts to summarize your data.
By the end of this course, you will be able to:
-
Design several types of special-purpose queries, including top value queries, unique value queries, and SQL-specific queries.
-
Create queries based on other queries and understand when to use this technique.
-
Use a variety of functions to manipulate strings and dates in queries and reports.
-
Write complex expressions that use the If function to evaluate data conditionally.
-
Calculate and display running sums in reports.
-
Apply conditional formatting in your reports.
-
Create advanced parameter queries and custom forms to supply parameter values.
-
Design crosstab queries and reports to group and summarize data in two dimensions.
-
Connect data with Excel to create PivotTables and PivotCharts.
-
Display multiple, related or unrelated subreports within a single report.
-
Create custom categories and groups in the Navigation Pane to provide quick access to
-
frequently used database objects.
Prerequisites
Intermediate Applications of Access or equivalent experience.Applies Towards the Following Certificates
- Business Applications Certificate : Database
- Database Technology Certificate : Database Concepts