Dal Alert!

Receive alerts from Dalhousie by text message.

X

Microsoft Access 2016 (365) Level III

Upcoming Course

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