close
You are not logged in
close
This Month Specials
 

Special Promotion

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

PowerPivot Fundamentals Level 5a $199 (Normally $299)

15% off all Web Design Classes

$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)

(book before 12/31/16)

GIFT CERTIFICATES AVAILABLE

Current Sales Packages

close
1 Union Square West, Suite 805, NY, NY 212.658.1918

Access Queries

$249

Show more

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.

This class is available as private session 3 hours - $269

 

Call 212.658.1918 or Email us

 

Class Perks

 

* The most practical and hands-on training to boost productivity and skill

* State-of-the-art curriculums refined by industry experts over nearly two decades

* Interactive, personable, and engaging instructors with several years of in-field and training experience

* Free Retakes for Life!®

* Small classroom sizes for personalized attention

* Custom in-depth manuals and mousepads with key shortcuts

* Convenient location and comfortable learning environment

Materials

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

Course 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 2017

Client Testimonials