Access 2016 Advanced will further build upon the topics covered in the Access 2016 Introduction and Intermediate courses. Students will review how to improve the structure of an Access database, maintain an Access database, create and modify Switchboards, configure security and multi-user environments, automate processes with VBA (Visual Basic for Applications), and use Table Events.
This course is an introduction to Microsoft Access 2016. In this course, students will become familiar with various database components, concepts, and terminology. Students will tour the user interface, create a basic database, create tables, queries, reports and forms, perform calculation with fields, numbers, and dates, navigate and work with tables and the various data types, understand and work with select queries, review and work with various reports and reporting features, and review data entry forms and the various tools that go along with them. This course will give the student the required knowledge to complete the Access 2016 Intermediate course.
This course is designed to teach students intermediate level skills in Microsoft Access 2016. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 2016 Advanced course.