Access Queries
CTU-ACCESS10QU-C

 Email this information to yourself or a friend

 Remind me of this course at a later date




Official Program Description

click here to jump to schedules and register

Queries are the "workhorses" of Microsoft Access. This course exhausts the query topics, giving the Access developer amazing tools to use when developing user-friendly, functional databases.

Who Should Attend

This course is designed for the Access user who is ready to move to the next level after level two and wants to learn more extensive information about queries only.

Prerequisites

Students must have completed Access Levels 1 and 2 prior to attending this course; otherwise instructor permission is required.

Attend and You Will Learn

Structuring Existing Data

  • Restructuring the data in a table
  • Create a junction table
  • Improve the table structure

Writing Advanced Queries

  • Creating subqueries
  • Creating unmatched and duplicate queries
  • Grouping and summarizing records using criteria
  • Summarizing data using a crosstab query
  • Creating a PivotTable and a PivotChart

Simplifying Tasks with Macros

  • Creating a macro
  • Attaching a macro
  • Restricting records using a condition
  • Validating data using a macro
  • Automating data entry using a macro

Creating Effective Reports

  • Including a chart in a report
  • Printing data in columns
  • Cancelling printing of a blank report
  • Publishing reports as PDF

Maintaining an Access Database

  • Linking tables to external data sources
  • Managing a database
  • Determining object dependency
  • Documenting a database
  • Analyzing the performance of a database



Sections

  Access Queries
CTU-ACCESS10QU-C - 016
   
 
  2016 - TTS - Jul - Aug 2015   Status:  Available
 
In-Class:   Tue 9:00AM - 4:30PM
4 Aug 2015
Class Schedule: 1 Sessions
Contact Hours: 6.0
Course Fee(s):
Registration Fee non-credit    $249.00
Gov't & Non-Profit Registration Fee non-credit    $199.00
Potential Discount(s):
CTU-MultClassDiscount<249
  0.60 CEUs
Location:   On Campus
Instructors: Holly Basso
 
  Access Queries
CTU-ACCESS10QU-C - 018
   
 
  2016 - TTS - Sep - Dec 2015   Status:  Available
 
In-Class:   Tue 9:00AM - 4:30PM
22 Sep 2015
Class Schedule: 1 Sessions
Contact Hours: 6.0
Course Fee(s):
Registration Fee non-credit    $249.00
Gov't & Non-Profit Registration Fee non-credit    $199.00
Potential Discount(s):
CTU-MultClassDiscount<249
  0.60 CEUs
Location:   On Campus
Instructors: Holly Basso
 
  Access Queries
CTU-ACCESS10QU-C - 017
   
 
  2016 - TTS - Sep - Dec 2015   Status:  Available
 
In-Class:   Thu 9:00AM - 4:30PM
19 Nov 2015
Class Schedule: 1 Sessions
Contact Hours: 6.0
Course Fee(s):
Registration Fee non-credit    $249.00
Gov't & Non-Profit Registration Fee non-credit    $199.00
Potential Discount(s):
CTU-MultClassDiscount<249
  0.60 CEUs
Location:   On Campus
Instructors: Holly Basso