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

Workshops > Microsoft Office 2016

MS Access 2016 Part 1  

A relational database application such as Microsoft Access 2016 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization.

In this course, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

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
Getting Started with Access
     Orientation to Microsoft Access
     Create a Simple Access Database
     Get Help and Configure Options in Microsoft Access

Working with Table Data
     Modify Table Data
     Sort and Filter Records

Querying a Database
     Create Basic Queries
     Sort and Filter Data in a Query
     Perform Calculations in a Query

Using Forms
     Create Basic Access Forms
     Work with Data on Access Forms

Generating Reports
     Create a Report
     Add Controls to a Report
     Enhance the Appearance of a Report
     Prepare a Report for Print
     Organize Report Information
     Format Reports

Download Class Files


MS Access 2016 Part 1
Item: ITOFF6012h4
8:30 AM - 12:00 PM Location: Hickory Hall, Hickory 128
Sessions: 2 Th F 5407 N. University Peoria, IL 61635
1/3/2019 - 1/4/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.