Manchester Office Tel:  0161 408 0435

London OfficeTel: 0203 693 3945 

 

Microsoft Access Advanced Training Course

Microsoft Access Training Courses

In this advanced Microsoft Access 2013 training course, will learn how to manage data by managing relationships and dependencies, enforce referential integrity. You will learn to insert application parts, use the Table Analyzer Wizard, create validation rules, and configure validation messages.

In this advanced Microsoft Access 2013 training course, will learn how to manage data by managing relationships and dependencies, enforce referential integrity. You will learn to insert application parts, use the Table Analyzer Wizard, create validation rules, and configure validation messages

 

 

This course package includes free Training Needs Analysis (TNA) for Microsoft Access  using Gmetrix testing software to assess training  requirements. For more details, see our TNA page or call us 0161 408 0435.

 

Versions: 2007, 2010, 2013

 

Course Type: In- House, Instructor led.

 

Duration: 1 day

 

Certificate: Certificate of completion

 

You will learn to Managing Data Entry in Tables setting field properties and indexing, as well as creating lookup fields, value lists, and input masks. The course will also demonstrate more complex forms. The use of sub-forms and their relationship with parent forms, creating a tab hierarchy in a navigation form as well as advanced queries including SQL queries. This course will also show how Microsoft Access 2013 integrates into SharePoint.

 

 

Course Outline

 

1: Managing Data

Types of Relationships

Viewing Relationships

Viewing Object Dependencies

What is Referential Integrity?

Enforcing Referential Integrity

Using Cascade Delete and Cascade Update

 

2: Advanced Table Tasks

Inserting Application Parts

Using the Table Analyzer Wizard

Creating Validation Rules

Configuring Validation Messages

 

3: Managing Data Entry in Tables

Marking Fields as Required

Marking a Field for Indexing

Creating Lookup Fields

Creating Value Lists

Creating Input Masks

 

4: Creating Subforms

Creating Subforms

Using Subforms

Linking Subforms with Parent Forms

Formatting a Subform within a Main Form

 

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

 

6: Advanced Query Tasks

Understanding SQL Statements

Basic SQL Keywords

Creating SQL Queries

Using the Expression Builder

 

7: Creating Modal Dialog Boxes

Creating a Modal Dialog Box

Adding Controls

Setting Properties

Formatting a Modal Dialog Box

 

8: Splitting the Database

Backing Up the Database

Splitting the Database

Configuring Access 2013 for a Multi-User Database

Setting Record Locking Options

 

9: Using Access with SharePoint Server

Linking Tables and Lists

Moving a Database to SharePoint

Saving a Database to SharePoint

About Access Web Apps

 

10: Creating Basic Macros

Creating a Standalone Macro

Using the Action Catalog

Adding Comments to Macros

Using If-Then Actions

Handling Macro Errors

 

11: Advanced Macro Tasks

Creating Event Procedures

Creating Data Macros

Creating Submacros

Grouping Submacros

 

12: Using Visual Basic for Applications

Converting a Macro to Visual Basic

Using Visual Basic for Applications

Understanding Modules

Building Visual Basic Procedures

 

Related Courses

In House Training Courses

Microsoft Access Intermediate Training Course

This Microsoft Access 2013 Intermediate training courses is intended to assist those who are familiar with the basics of Access to do more with their database. The course will also help more...

Microsoft Access Introduction Training Course

On this Microsoft Access training course you will learn basic functions and features of Microsoft Access . You will learn to create databases, work with tables, fields, and records, sort and filter...