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