MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Access 2007 Part 3: Queries

Course Summary

Part 3 of 5 in the Access 2007 series. If you are tasked with building a new database, fixing your company's Access database, or just wish to ditch the bulky Excel spreadsheet, this is the course for you. This course will teach you to track and report dat


  • +

    Course Syllabus

    ● Query Basics
        ◦ Overview of Queries
        ◦ Types of Queries
        ◦ Uses for Queries
        ◦ Creating a Select Query
        ◦ Creating Queries Exercises
        ◦ What We Covered
    ● Finding Specific Data Using Queries
        ◦ Introduction to Criteria and Operators
        ◦ Mathematical Operators
        ◦ Relational/Comparison Operators
        ◦ Practice Using Criteria - Part 1
        ◦ Logical Operators
        ◦ Other Operators
        ◦ Practice Using Criteria - Part 2
        ◦ Wildcards
        ◦ What We Covered
    ● Creating Flexible Queries
        ◦ Benefits of Using a Flexible Query
        ◦ Creating a Flexible Query
        ◦ Using Operators and Wildcards inside Flexible Queries
        ◦ What We Covered
    ● Creating Calculations Inside Queries
        ◦ Introduction to Calculations
        ◦ Creating a Calculated Detail Field
        ◦ Calculating a Group of Records
        ◦ Aggregate Options
        ◦ The DateDiff Function
        ◦ Format Functions
        ◦ IIf Function
        ◦ Fun with Concatenation
        ◦ What We Covered
    ● Introduction to Query Joins
        ◦ Introduction to Query Joins
        ◦ Creating an Inner Join
        ◦ Creating an Outer Join
        ◦ Creating a Self Join
        ◦ What We Covered
    ● Intro to Action Queries
        ◦ Review of Select Queries
        ◦ Creating an Append Query
        ◦ Creating a Delete Query
        ◦ Creating a Make-Table Query
        ◦ Creating an Update Query
        ◦ What We Covered
    ● Using Special Query Wizards
        ◦ Introduction
        ◦ The Crosstab Query Wizard
        ◦ The Find Duplicates Query Wizard
        ◦ The Find Unmatched Query Wizard
        ◦ What We Covered

     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top