Loading...

Course Description

This ILT Series course builds on the skills and concepts taught in Access 2016 (365) Level II. Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; password-protect and encrypt databases; and set Access options and properties.

Prerequisites

Access 2016 (365) Level II or equivalent.

Course Outline

Implementing Advanced Form Design

  • Add Controls to Forms
  • Enhance Navigation and Organization of Forms
  • Apply Conditional Formatting

Sharing Data Across Applications

  • Import Data into Access
  • Export Access Data
  • Link Tables to External Data Sources
  • Create a Mail Merge

Using Macros to Improve User Interface Design

  • Create a Macro
  • Restrict Records Using a Condition
  • Validate Data Using a Macro
  • Automate Data Entry Using a Macro

Using VBA

  • Getting Started with VBA
  • Enhance Access Using VBA

Using Advanced Database Management

  • Manage a Database
  • Determine Object Dependency
  • Document a Database

Distributing and Securing a Database

  • Splitting a Database for Multiple User Access
  • Implement Security
  • Convert an Access Database to an ACCDE File
  • Package a Database with a Digital Signature

Managing Switchboards

  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Set Startup Options

Notes

For more Computer Applications courses click here.

Loading...

Enroll Now - Select a section to enroll in

Section Title
Microsoft Access 2016 (365) Level III
Type
Lab
Days
M, T
Time
8:30AM to 2:30PM
Dates
Nov 16, 2020 to Nov 17, 2020
Schedule and Location
Contact Hours
10.0
Location
Delivery Options
Classroom  
Course Fee(s)
Fee + 15% HST non-credit $399.00
Section Notes
For the Discount, In-House Customized Training and Cancellation Policy related to this course click here.
Section Title
Microsoft Access 2016 (365) Level III
Type
Lab
Days
Th, F
Time
8:30AM to 2:30PM
Dates
Mar 11, 2021 to Mar 12, 2021
Schedule and Location
Contact Hours
10.0
Location
Delivery Options
Classroom  
Course Fee(s)
Fee + 15% HST non-credit $399.00
Section Notes
For the Discount, In-House Customized Training and Cancellation Policy related to this course click here.
Section Title
Microsoft Access 2016 (365) Level III
Type
Lab
Days
M, T
Time
8:30AM to 2:30PM
Dates
Jun 14, 2021 to Jun 15, 2021
Schedule and Location
Contact Hours
10.0
Location
Delivery Options
Classroom  
Course Fee(s)
Fee + 15% HST non-credit $399.00
Section Notes
For the Discount, In-House Customized Training and Cancellation Policy related to this course click here.
Required fields are indicated by .