close
You are not logged in
close
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)

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.

    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

    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 2018

    Client Testimonials