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 2013 Desktop Essentials: Part 2

Course Summary

Part 2 of 2 in the Access 2013 Desktop Essentials series. This course is designed for beginners and casual users of Microsoft Access 2013. You don't have to be an IT Pro or a developer to follow along. This course has anyone in mind who would like to be a

  • +

    Course Syllabus

    ● Working with Built-in Functions
        ◦ Introduction to Built-in Functions
        ◦ The Date() Function
        ◦ The DatePart() Function
        ◦ The Month() Function
        ◦ The DateDiff() Function
        ◦ The Format() Function
        ◦ The IIF() Function
        ◦ Nesting Functions
    ● Understanding Joins
        ◦ Introduction to Joins
        ◦ Self-Joins
    ● Special Query Wizards
        ◦ Find Duplicates Query Wizard
        ◦ Find Unmatched Query Wizard
    ● Creating an Action Query
        ◦ Introduction to Action Queries
        ◦ Creating an Append Query
        ◦ Creating an Update Query
        ◦ Creating a Make Table Query
    ● Introduction to Forms
        ◦ Types of Forms
        ◦ Creating Forms
        ◦ Parts of a Form
    ● Formatting Forms
        ◦ Resizing, Moving, Adding, and Deleting Controls
        ◦ Conditional Formatting
    ● Form Controls and Properties
        ◦ Introduction to Controls
        ◦ Calculated Controls
        ◦ Adjusting the Tab Order
    ● Creating Navigation Forms
        ◦ Ways to Navigate Access
        ◦ Customizing the Navigation Pane
    ● Creating Reports
        ◦ Creating a Report Using the Report Tool
        ◦ Creating a Report Using the Report Wizard
    ● Formatting Reports
        ◦ Report Sections and Grouping
        ◦ Counting in Reports
    ● Introduction to Macros
        ◦ Introduction
        ◦ Creating a Macro
        ◦ Where Conditions
        ◦ Creating a Data Macro


Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Related Posts:

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
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