Yawn-proof software training

Managing Data

This opening module will show participants how to view relationships, view object dependencies, enforce referential integrity, and enforce cascade update and delete. Participants also will learn about types of relationships and referential integrity.

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

Advanced Table Tasks

In this module, participants are shown how to insert application parts, use the Table Analyzer Wizard, create validation rules, and configure validation messages.

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

Managing Data Entry in Tables

Here, topics include how to mark fields as required, mark a field for indexing, create lookup fields, create value lists, and create input masks.

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

Creating Subforms

This module covers how to create and use subforms, link subforms with parent forms, and format a subform within a main form.

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

Creating Navigation Forms

Next, participants are shown how to create a navigation form and add tabs to it, create a tab hierarchy in a navigation form, and automatically display a navigation form when the database opens.

  • 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

This module will give participants the answers about using advanced queries. Topics covered include how to create SQL queries, use the Expression Builder, create SQL statements, and use SQL keywords.

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

Creating Modal Dialog Boxes

Modal dialog boxes get a thorough look in this module. Learn how to create, format, and modify a modal dialog box.

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

Splitting the Database

When dealing with databases, it’s a good idea to have tools to manipulate them effectively. This module takes a look at how to back up a database, split a database, configure Access 2013 for a multi-user database, and set record locking options.

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

Using Access with SharePoint Server

SharePoint Server meshes well with Access 2013 and this module takes advantage of that relationship. Participants will learn how to link tables to lists, move a database to SharePoint, save a database to SharePoint, and use Access web apps.

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

Creating Basic Macros

This module shows participants how to create a standalone macro, use the Action Catalog, add comments to macros, use If-Then actions, and handle macro errors.

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

Advanced Macro Tasks

Next, participants will learn how to create event procedures, data macros, and sub macros.

  • Creating Event Procedures
  • Creating Data Macros
  • Creating Sub Macros
  • Grouping Sub Macros

Using Visual Basic for Applications

The final module in this course explores how to use Visual Basic for Applications. Participants will learn how to convert a macro to Visual Basic, use Visual Basic for Applications, use modules, and build Visual Basic procedures.

  • Converting a Macro to Visual Basic
  • Using Visual Basic for Applications
  • Understanding Modules
  • Building Visual Basic Procedures

Download Full Course Details as a PDF

Share this printable PDF with others in the office.

Download Now

Corporate Training

Who says improving employee software skills can’t be fun? We’ll take the time to understand staff challenges and engage them in learning. We'd love to hear from you:

Public Courses

There are no upcoming events.