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.