Microsoft Access 2013 Advanced Essentials

This course has been superseded

We suggest the following instead:
Access 365 - Part 2

Course Description

This course builds upon basic Microsoft Access skills to help students become power users. In this advanced Microsoft Access 2013 course, students will delve deeper into the program by studying a dozen different topics. Modules in this course cover how to manage data and data entry; create forms, macros, and dialog boxes; create and use SQL queries; split databases; and much more.
1 day
Contact us for pricing
 

Prerequisites

To ensure the successful completion of this Advanced course, the completion of relevant Core or Intermediate courses - or equivalent knowledge - is recommended.

Managing Data

Types of Relationships
Viewing Relationships
Viewing Object Dependencies
What is Referential Integrity?
Enforcing Referential Integrity
Using Cascade Delete and Cascade Update

Advanced Table Tasks

Inserting Application Parts
Using the Table Analyzer Wizard
Creating Validation Rules
Configuring Validation Messages

Managing Data Entry in Tables

Marking Fields as Required
Marking a Field for Indexing
Creating Lookup Fields
Creating Value Lists
Creating Input Masks

Creating Subforms

Creating Subforms
Using Subforms
Linking Subforms with Parent Forms
Formatting a Subform within a Main Form

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

Advanced Query Tasks

Understanding SQL Statements
Basic SQL Keywords
Creating SQL Queries
Using the Expression Builder

Creating Modal Dialog Boxes

Creating a Modal Dialog Box
Adding Controls
Setting Properties
Formatting a Modal Dialog Box

Splitting the Database

Backing Up the Database
Splitting the Database
Configuring Access 2013 for a Multi-User Database
Setting Record Locking Options

Using Access with SharePoint Server

Linking Tables and Lists
Moving a Database to SharePoint
Saving a Database to SharePoint
About Access Web Apps

Creating Basic Macros

Creating a Standalone Macro
Using the Action Catalog
Adding Comments to Macros
Using If-Then Actions
Handling Macro Errors

Advanced Macro Tasks

Creating Event Procedures
Creating Data Macros
Creating Submacros
Grouping Submacros

Using Visual Basic for Applications

Converting a Macro to Visual Basic
Using Visual Basic for Applications
Understanding Modules
Building Visual Basic Procedures
AccessAccess 2013Microsoft AccessMicrosoft Access 2013