Access Power Queries

Access Power Queries

Mobile

Getting the information you need from your database is an important measure of its power - and also a measure of your own mastery of the program.

In this one-day course you will increase the scope and power of your Access queries, using advanced selection criteria, wildcards, queries involving calculations, the Query Wizard, cross tabulations, an introduction to SQL, sub-queries, nested sub-queries and more. This course offers great value to the Access database user.

Course Details
icon iPhone

 

Date: November 12, 2014

Days: 1

Fee: $250.00

Location: 1 Martine Avenue, White Plains, NY

Course Number: 90766

icon

Course Description

Access Power Queries is a one day course designed for individuals who know the fundamentals of Access, but would like to enhance their knowledge of queries. This course concentrates on using the power of the database program to extract information. Students will learn how to design advanced queries using functions and set criteria to isolate data. Action queries, joins, and the find unmatched and find duplicates query designs round out the content.

Click for Detailed Course Description

icon

You Will Learn To

  • Review select Queries and Criteria
  • Use Functions for Criteria
  • Wildcards
  • Calculate fields in Queries
  • Learn enhanced functions
  • Query Wizard including finding duplicate records, unmatched records
  • Cross tabulations using a wizard and without a wizard
  • Update Query, Make-Table Query, Append Query, and Delete Query
  • Use Inner Joins, Outer Joins, Self Joins, Relationships Window, Unlinked table in a Query
  • Switch the data source for a report or a form
  • Use SQL for Criteria
  • Sub-Queries, Nested sub-queries, Union Queries
icon

Who Should Enroll

Access users who have mastered basic queries.

Prerequisite: Introduction to Access or equivalent experience.

icon

Course Format

One Day (9am- 4pm); offered Monday-Friday; Instructor-led.
COST: $250

icon

Questions?

Please contact us at (888) 561-7223 or continuinged@pace.edu

Outline for Access Power Queries

CRITERIA
Select Queries
Yes/No Fields
Null and the NZ() Function
In ()
The Wildcards

CALCULATED FIELDS
The Database, Format and iif Functions
The Count (*) Function

QUERY WIZARDS
The Find Duplicates Query Wizard
The Unmatched Query Wizard
Cross tabulations
Switching Rows into Columns

 

JOINS
Inner Joins
Outer Joins
Self joins
The Relationships Window
Referential Integrity
Using Unlinked Tables in Queries
Switching the Source for a Report

SUB-QUERIES AND SQL
Sub-Queries
Nested Sub-Queries
The Union Query
Top # and Top # Percent

 

 

Other Courses That May Interest You

icon

Access

  icon

Excel

icon

Microsoft Project

  icon

Outlook

 

 

icon

PowerPoint

  icon

Windows 8.1

 

 

Word