You are not logged in
This Month Specials

Special Promotion

$199 Excel or 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)


Current Sales Packages

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

Access Queries


    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.

    Call 212.658.1918 or Email us

    Class Perks

    • Practical and hands-on training classes
    • Proprietary curriculum refined by industry experts
    • Interactive courses taught by engaging instructors
    • Revolutionary video suite with premium content
    • Personalized attention in small class sizes


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

    Course Outline

    Lesson 1: Overview of Database Design
    Relationship Design

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

    Lesson 3: Calculated Fields
    Totaling Fields
    Math Expressions

    Lesson 4: Functions

    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