Skip to Main Content

Microsoft Access 2013 Advanced Essentials  (MO13AC201)

Time: 9am - 4pm
Duration: 1 day

Compatible with 2013

Description:

In this course you will learn how to: manage data; work with advanced table tasks; manage data entry in tables; creating subforms; creating navigation forms; work with advanced query tasks (including an overview of SQL statements); create modal dialog boxes; split the database; use Access with SharePoint server; creating basic macros; work with advanced macro tasks; use Visual Basic for Applications in Access 2013.

Prerequisites:

MO13AC101—Microsoft Access 2013 Core Essentials or equivalent is mandatory.

Public Class Schedule

Location Language Date Price Register
Ottawa English April 20 $ 275.00
Web-based(Opens in new window) English April 20 $ 275.00

We're Here to Help

Don't see the dates you need? Call us at 888.484.2933 or Tell Us What You Need.

Course Outline

  • Module 1: Managing Data
    • Types of Relationships
    • Viewing Relationships
    • Viewing Object Dependencies
    • What is Referential Integrity?
    • Enforcing Referential Integrity
    • Using Cascade Delete and Cascade Update
  • Module 2: Advanced Table Tasks
    • Inserting Application Parts
    • Using the Table Analyzer Wizard
    • Creating Validation Rules
    • Configuring Validation Messages
  • Module 3: Managing Data Entry in Tables
    • Marking Fields as Required
    • Marking a Field for Indexing
    • Creating Lookup Fields
    • Creating Value Lists
    • Creating Input Masks
  • Module 4: Creating Subforms
    • Creating Subforms
    • Using Subforms
    • Linking Subforms with Parent Forms
    • Formatting a Subform within a Main Form
  • Module 5: Creating Navigation Forms
    • Creating a Navigation Form
    • Adding Tabs to a Navigation Form
    • Creating a Tab Hierarchy
    • Displaying the Navigation Form when the Database Opens
  • Module 6: Advanced Query Tasks
    • Understanding SQL Statements
    • Basic SQL Keywords
    • Creating SQL Queries
    • Using the Expression Builder
  • Module 7: Creating Modal Dialog Boxes
    • Creating a Modal Dialog Box
    • Adding Controls
    • Setting Properties
    • Formatting a Modal Dialog Box
  • Module 8: Splitting the Database
    • Backing Up the Database
    • Splitting the Database
    • Configuring Access 2013 for a Multi-User Database
    • Setting Record Locking Options
  • Module 9: Using Access with SharePoint Server
    • Linking Tables and Lists
    • Moving a Database to SharePoint
    • Saving a Database to SharePoint
    • About Access Web Apps
  • Module 10: Creating Basic Macros
    • Creating a Standalone Macro
    • Using the Action Catalog
    • Adding Comments to Macros
    • Using If-Then Actions
    • Handling Macro Errors
  • Module 11: Advanced Macro Tasks
    • Creating Event Procedures
    • Creating Data Macros
    • Creating Submacros
    • Grouping Submacros
  • Module 12: Using Visual Basic for Applications
    • Converting a Macro to Visual Basic
    • Using Visual Basic for Applications
    • Understanding Modules
    • Building Visual Basic Procedures

Private training is available for this course.

Call us at 1-888-484-2933 to learn more about our flexible scheduling options or complete our Information Request Form.

© 2017 Eliquo, Inc. All rights reserved.

Back to Top