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 1

Course Summary

Part 1 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

    ● Getting Started with Access 2013 Desktop Essentials
        ◦ Getting Started
    ● Types of Access 2013 Applications
        ◦ Introducing Access 2013
        ◦ Access 2013 New Features
        ◦ Trust Center and Access Trusted Locations
    ● Introduction to Relational Databases
        ◦ Databases 101
        ◦ Introduction to Normalization
        ◦ Denormalization
    ● Microsoft Access Objects
        ◦ Objects Overview
        ◦ Other Objects
    ● Creating an Access 2013 Desktop Database
        ◦ Access Database Templates
        ◦ Access Blank Databases
    ● Introduction to Creating Tables
        ◦ Data Types
        ◦ Ways to Create Tables
        ◦ Table Design View
        ◦ Importing Existing Data
    ● Controlling Data Entry with Tables
        ◦ The Need for Data Control
        ◦ Input Masks
        ◦ Lookup Fields
        ◦ Data Validation
    ● Introduction to Indexing
        ◦ What is an Index?
        ◦ Creating an Index
    ● Introduction to Relating Data
        ◦ The Need for Relationships
        ◦ Enforcing Referential Integrity
        ◦ Cascade Update and Cascade Delete
    ● Creating Advanced Relationships
        ◦ The Need for Other Relationships
        ◦ Creating a Many-to-Many Relationship
    ● Introduction to Queries
        ◦ Introduction
        ◦ Kinds of Queries
        ◦ Other Kinds of Queries
        ◦ Creating a Basic Select Query
        ◦ Sorting and Filtering Records
    ● Finding Specific Data
        ◦ Introduction to Criteria
        ◦ Adding Query Criteria
        ◦ Lookup Fields
        ◦ Combining Criteria
        ◦ Adding Alternate Criteria
        ◦ Wildcards
        ◦ Locating Blank Values (Nulls)
    ● Creating Parameter Queries
        ◦ Introduction to Parameter Queries
        ◦ Creating a Parameter Query
        ◦ Changing the Parameter Prompt Order
        ◦ Using Wildcards with Parameter Queries
    ● Creating Calculated Expressions
        ◦ Introduction to Expressions
        ◦ Creating a Calculated Field
        ◦ The Expression Builder
    ● Grouping and Summarizing Data
        ◦ Introduction
        ◦ Calculating a Group of Records
        ◦ PivotTables and PivotCharts


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