Close
You are not logged in
Close
This Month Specials
 

Special Promotion

$209 Excel or $199 PowerPoint for Business Blowout! (Normally $299/ea)

PowerPivot Fundamentals $199 (Normally $299)

$199 QuickBooks Level 1 or Level 2 for PC, Mac, or Online Classes (Normally $299/ea)

Now $545-Excel Power Programming with VBA (Normally $659)

Now $649-Photoshop Essentials 2 Day Course (Normally $749)

GIFT CERTIFICATES AVAILABLE

Current Sales Packages

Close
185 Madison Ave, 11th Floor, New York, NY 10016 212.658.1918

Access Queries training in New York

Sign up for group classes

Call 212.658.1918 or email us

Access Queries

Excel 2010 Training Class Logo

The Access class concentrates on the most common topics that we see in NYC businesses using on a daily basis. When you are finished with this Access training class you will be able to design a Simple and Complex Queries, modify a Query, view a Query as SQL and run SQL in VBA. This class is perfect to those who already existing databases and want to take full advantage of their data.

Materials

  • Examples databases for in class and after class
  • Shortcut sheet

Course Outline

Download PDF Outline

Lesson 1: Overview of Database Design
Tables
Queries
Relationship Design

Lesson 2: Designing a Simple Query
Design Concept
Specify Criteria
Date Criteria
Types of Joins
Sorting

Lesson 3: Calculated Fields
Totaling Fields
Math Expressions

Lesson 4: Functions
Format
Date
Time
Lookup

Lesson 5: Conditional Statements
If Statements
And/ Or Conditions

Lesson 6: Complex Queries
Finding Duplicates
Finding Unmatched Sets
Nested Queries
Make Table Query
Update Query
Append Query
Delete Query

Lesson 7: SQL
Viewing a Query as SQL
Basic SQL Expressions

Lesson 8: VBA
Intro to VBA
Running SQL in VBA

Lesson 9: Other Data Sources
Importing Files
Exporting Files

 

© NYIM Training 2018

Client Testimonials