Microsoft Access 2013 or 2016 - Level 3 - Advanced

Office Applications/Productivity
Schedules
  12/28/17 - 9-5pm PST Glendale - CA
Delivery Type (Must Select One)
  Instructor-Led
  Online Live Instructor-Led
Version (Must Select One)
  2013
  2016
Optional
  Certiport Test with Proctor Fee ($126.00)
  Certiport Test with 1 Retake / Proctor Fee ($145.00)
  LearnITAnytime Online Subscription (1 Year Subscription - $195.00)
  IT Online Library (1 Year Subscription - $1595.00)
  Private Mentoring 3 Hours ($125)
Quantity
If quantity is more than 1, Please add all Attendees' Names /Voucher #/ Learning Credit below separated with a comma. If not specified, we will contact you prior to the class start date. Special Instructions
This hands-on advanced course is suitable for Access 2010/201/2016 users.
Live face-to-face instructor-led training. No minimum class size - all classes guaranteed to run.
You will learn topics such as data validation, macros, advanced queries, form design and reporting, and advanced database tools.

Validation Rules and Messages
  • Creating a Field Validation Rule
  • Creating a Field Validation Message
  • Creating a Validation Rule
  • Creating a Validation Message
  • Testing Validation Rules

Working with Macros
  • Creating a Before Change Event
  • Working with the Macro Tools Design Tab
  • Working with the Action Catalog
  • Creating an After Event
  • Creating a Named Macro
  • Renaming or Deleting Macros

Advanced Query Tasks
  • Using Query Design View
  • Creating Ad Hoc Relationships
  • Creating an Update Query
  • Creating a Parameter Query
  • Comparing Two Tables by Using a Join

Designing Forms
  • Common Formatting Tasks
  • Using Themes
  • Working with Controls
  • Adding Header and Footer Elements
  • Arranging Form Elements
  • Formatting Forms

Advanced Reporting Tasks
  • Using Report Sections
  • Using Conditional Formatting
  • Grouping and Sorting Data
  • Adding Calculated Controls
  • Creating Labels

Advanced Database Tools
  • Using the Database Documenter
  • Analyzing Table Performance
  • Analyzing Database Performance
  • Repairing a Database
  • Compacting a Database

Working with the Access Environment
  • Working with Database Properties
  • Encrypting a Database with a Password
  • Using Save Object As
  • Setting Access Options


  • Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.


Certificate of Course Completion


This hands-on advanced course is suitable for Access 2010/201/2016 users.


Students should have completed our Intermediate class or have the equivalent knowledge prior to attending.


You may cancel this class 10 or more business days prior to the start date of the class for a full refund. No shows or cancellations made within 10 days will forfeit all fees paid.