Loading...

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

Loading...
Enroll Now - Select a section to enroll in
Section Title
Advanced Applications of Access
Type
Discussion
Days
W, Th
Time
8:30AM to 4:00PM
Dates
Jun 05, 2024 to Jun 06, 2024
Schedule and Location
Contact Hours
13.0
Delivery Options
Course Fee(s)
Fee non-credit $399.00
Drop Request Deadline
Jun 03, 2024
Transfer Request Deadline
Jun 03, 2024
Section Title
Advanced Applications of Access
Type
Discussion
Days
W, Th
Time
8:30AM to 4:00PM
Dates
Jun 05, 2024 to Jun 06, 2024
Schedule and Location
Contact Hours
13.0
Location
Delivery Options
Course Fee(s)
Fee non-credit $399.00
Drop Request Deadline
Jun 03, 2024
Transfer Request Deadline
Jun 03, 2024
Required fields are indicated by .