Manage Information with Microsoft Access 2016

By on September 27, 2017
Manage Information with Microsoft Access 2016

Learn the foundations to plan and design a database system. Learn to create, manage, and maintain tables and table relationships. Get the skills you need to enhance your database designs. And create reports and learn how to query the database to find data.

Register by calling 314-984-7777 or online at https://classes.stlcc.edu/CE_Registration/.

More information on the Corporate College is available on the STLCC website.

Microsoft Access 2016 for Business: Part I

Learn the foundations to plan and design a database system. Learn to create, manage, and maintain tables and table relationships. Discover sorting and filtering records within tables. Prerequisite: Windows Introduction class or equivalent experience. Bring a flash drive to class.
COMP:725 | $129
C01 | F 9 a.m.-4 p.m. | Cris Heffernan
Oct. 20 | Corporate College 208

Microsoft Access 2016 for Business: Part II

Get the skill you need to enhance your database designs. Work with Data Normalization, Table Relationships and Join techniques, including Inner and Outer joins. Learn to query multiple tables for customized reports. Create more complex queries using parameters, and action queries. Learn to use more advanced Reporting techniques. Prerequisite: Windows Introduction class or equivalent experience and Introduction to Access or equivalent experience. Bring a flash drive to class.
COMP:725 | $129
C02 | F 9 a.m.-4 p.m. | Cris Heffernan
Oct. 27 | Corporate College 208

Microsoft Access 2016 for Business: Part III

Round out development of your Access skills by learning advanced Forms design techniques, including the addition of controls, improved navigation, and effective use of Conditional Formatting. You will link tables, import and export data, and use your database in a Word Mail Merge. Learn to build Macros to validate and automate data, and be introduced to VBA to enhance your database even further. Topics also include documenting and securing your DB, and creating and managing a Switchboard to control user interaction with your DB. Prerequisite: Microsoft Access 2016 for Business: Part 1 and Part 2. Bring a flash drive to class.
COMP:726 | $129
C01 | F 9 a.m.-4 p.m. | Cris Heffernan
Nov. 3 | Corporate College 208

About Richard Schumacher

Richard Schumacher is the technology manager for the Workforce Solutions Group of St. Louis Community College. He connects, designs, and applies technology to meet business user needs with eLearning, training, web content, instructional design, IT system, and performance improvement solutions. Richard is a Microsoft Certified Trainer (MCT) and has held Microsoft Certifications since 1993. Learn more about Richard by following him: LinkedInTwitterGoogle+ArticlesEmail

Leave a Reply

Your email address will not be published. Required fields are marked *