In this introductory course, you will discover the capabilities of Microsoft® Access®, a relational database application that can help you and your organization manage your complex data.

In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users. This course covers Microsoft Office Specialist Program exam objectives to help you prepare for the Access Expert (Office 365 and Office 2019): Exam MO-500 certification.

This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access. Microsoft® Office Access® 2019 - Part 1 (this course): Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports. Microsoft® Office Access® 2019 - Part 2 : Focuses on optimization of an Access database, including optimizing performance and normalizing data, data validation, usability, and advanced queries, forms, and reports.

In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users. This course is the second part of a three-course series that covers the skills needed to perform database design and development in Access 2019. Microsoft® Office Access® 2019 - Part 1 : Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports. Microsoft® Office Access® 2019 - Part 2 (this course): Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.

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

In this course, students add to their Access education in order to provide themselves with marketable job skills. This course builds on the foundational skills obtained by attending the Access 2016 - Part 1 course.

Students learn the Visual Basic for Applications language as well as the Access classes and objects needed to create VBA scripts to automate Access. Participants create procedures and functions using the VBA language and Access objects.

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

In this course, students will expand their knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports.

In this course, students will learn how to use Access 2010 to manage data, including creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.

Students will 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.

In this course, students will work with procedures and functions, understand objects, use expressions, variables and instrinsic functions, controlling program execution, work with recordsets, debug code and handle errors.