Print Course information
E-mail to a friend
Return to Course Catalog

Workshops > Microsoft Office 2016

MS Access 2016 Part 3  

You've covered many of the basic functions of Microsoft Access 2016, and now you're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access, and more.

This workshop is a blended training experience that includes instructor-led classroom time plus these online components available to you on any mobile device.

  • E-Book – an electronic version of your printed book, readable on any computer or mobile device
  • Files – the practice files used in the instructor-led class
  • Assessments – Detailed evaluations based on course content
  • Learn To – Short video tutorials reinforcing and expanding key concepts of the course
  • Checklist – Quick reference material and step-by-step instructions for tasks covered in the class in an easy-to-find format

Topics Include
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

Download Class Files


MS Access 2016 Part 3
Item: ITOFF6014h4
8:30 AM - 12:00 PM Location: Hickory Hall, Hickory 128
Sessions: 2 Tu W 5407 N. University Peoria, IL 61635
1/15/2019 - 1/16/2019 Fee: $140.00

The Professional Development Institute
Illinois Central College Peoria Campus
5407 N. University St. Peoria, IL. 61635

© Illinois Central College. All Rights Reserved.