CA$620.96 – CA$827.96

Access 2013 Expert 1 Day Training in Montreal

Actions and Detail Panel

From CA$620.96

Event Information

Share this event

Date and Time

Location

Location

Regus - Quebec, Montreal - Cathcart & McGill

2001 Boulevard Robert-Bourassa #1700

Montréal, QC H3A 2A6

Canada

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description
Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction.

About this Event

Course Overview:

This workshop is designed to teach you a deeper understanding of Access 2013 in a practical way. This workshop is designed for the advanced users of Access 2013. This workshop incorporates a hands-on approach to learning. They will get a chance to practice some of the advanced features right on a computer.

This workshop is meant to provide a safe learning environment where they can practice and learn Access 2013 Expert functions without worrying about making mistakes. Access 2013 features a new framework that is designed for one purpose―enable users to create data-centric web applications. Taking the time to develop a deep understanding of Access 2013 will increase their knowledge on how databases work and make creating and managing an Access 2013 database easier for everyone.

Target Audience:

Anybody who is interested in learning Access 2013 Expert Skills

Learning Objectives:

After completing this course, Individuals will be able to demonstrate their understanding of:

  • Customizing Apps
  • Working with Validation Rules and Messages
  • Working with Macros
  • Advanced Query Tasks
  • Designing Forms
  • Advanced Reporting Tasks
  • Advanced Database Tools
  • Working with the Access Environment

Prerequisites:

None

Course Materials:

Students will receive a course manual with presentation slides and reference materials.

Technical Requirements:

For eBooks:

Internet for downloading the eBook

Laptop, tablet, Smartphone, eReader (No Kindle)

Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader)

eBook download and activation instructions

Course Agenda:

Module 01: Customizing Apps (I)

  • Creating a Custom App from Scratch
  • Adding a Template Table Adding a Blank Table
  • Importing Access 2010 Tables
  • Module One: Review Questions

Module 02: Customizing Apps (II)

  • About Custom Actions
  • Adding a Custom Action
  • Editing a Custom Action
  • Deleting a Custom Action
  • Module Two: Review Questions

Module 03: Customizing Apps (III)

  • About User Interface Macros
  • Creating an Embedded Macro
  • Creating a Standalone macro
  • Saving Your App as a Package
  • Module Three: Review Questions

Module 04: Working with 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
  • Module Four: Review Questions

Module 05: 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
  • Module Five: Review Questions

Module 06: 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
  • Module Six: Review Questions

Module 07: Designing Forms

  • Common Formatting Tasks
  • Using Themes
  • Working with Controls
  • Adding Header and Footer Elements
  • Arranging Form Elements
  • Formatting Forms
  • Module Seven: Review Questions

Module 08: Advanced Reporting Tasks

  • Using Report Sections
  • Using Conditional Formatting
  • Grouping and Sorting Data
  • Adding Calculated Controls
  • Creating Labels
  • Module Eight: Review questions

Module 09: Advanced Database Tools

  • Using the Database Documenter
  • Analyzing Table Performance
  • Analyzing Database Performance
  • Repairing a Database
  • Compacting a Database
  • Module Nine: Review Questions

Module 10: Working with the Access Environment

  • Working with Database Properties
  • Encrypting a Database with a Password
  • Using Save Object As
  • Setting Access Options
  • Module Ten: Review Questions

Module 11: Wrapping Up

  • Words from the Wise
  • Review of Parking Lot
Share with friends

Date and Time

Location

Regus - Quebec, Montreal - Cathcart & McGill

2001 Boulevard Robert-Bourassa #1700

Montréal, QC H3A 2A6

Canada

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved