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 2010: Queries and Functions

Course Summary

Part 2 of 3 in the Access 2010 series. If you are using a database that someone has already built and wish to modify or build your own queries, reports, PivotTables, PivotCharts, and calculated expressions, this course is a good starting point. This cours


  • +

    Course Syllabus

    ● Introduction to Queries
        ◦ Introduction
        ◦ Kinds Of Queries
        ◦ Creating a Select Query Using the Simple Query Wizard
        ◦ Creating a Select Query from Design View
        ◦ Working with Fields
        ◦ Sorting and Filtering Records
        ◦ What We Covered
    ● Finding Specific Data Using Criteria, Operators, and Wildcards
        ◦ Introduction
        ◦ Introduction to Criteria
        ◦ Introduction to Operators
        ◦ Adding Criteria to a Query
        ◦ Combining Criteria
        ◦ Adding Alternate Criteria
        ◦ Locating Blank Values (Nulls)
        ◦ Introduction to Wildcards
        ◦ What We Covered
    ● Creating Parameter Queries
        ◦ Introduction
        ◦ Introduction to Parameter Queries
        ◦ Creating a Parameter Query
        ◦ Changing the Parameter Prompt Order
        ◦ Using Wildcards and Functions with Parameter Queries
        ◦ What We Covered
    ● Understanding Joins
        ◦ Introduction
        ◦ Introduction to Joins
        ◦ Types of Joins
        ◦ Creating an Inner Join
        ◦ Creating an Outer Join
        ◦ Creating a Self-Join
        ◦ What We Covered
    ● Creating Calculated Expressions
        ◦ Introduction
        ◦ Introduction to Expressions
        ◦ Creating a Calculated Detail Field
        ◦ Building Expressions Using the Expression Builder
        ◦ Building Expressions in Forms and Reports
        ◦ What We Covered
    ● Summarizing Data
        ◦ Introduction
        ◦ Introduction to Aggregate Queries
        ◦ Calculating a Group of Query Records
        ◦ Calculating a Group of Query Records From Design View
        ◦ Grouping with Criteria and Calculated Fields
        ◦ Pitfalls of Summarizing Data
        ◦ What We Covered
    ● Introduction to Built-in Functions
        ◦ Introduction
        ◦ Introduction to Functions
        ◦ Basic Date/Time Functions
        ◦ The Month and Year Function
        ◦ Text Functions
        ◦ The LCase and UCase Functions
        ◦ The Left and Right Functions
        ◦ The Trim Function
        ◦ The Format Function
        ◦ Conversion & Math Functions
        ◦ The FormatCurrency Function
        ◦ The CCur Function
        ◦ The Round Function
        ◦ What We Covered
    ● Advanced Functions
        ◦ Introduction
        ◦ Advanced Date/Time Functions
        ◦ The DateAdd Function
        ◦ The DateDiff Function
        ◦ The Sum Function
        ◦ The Max & Min Functions
        ◦ The DMax & DMin Functions
        ◦ The DLookup Function
        ◦ Handling Null Values & Program Flow
        ◦ The IIf Function
        ◦ The Switch Function
        ◦ Using Functions in Macros
        ◦ Nesting Functions
        ◦ What We Covered

     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

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