Advanced Microsoft Access 2016 (ACC2016.2)

This course offers an in-depth exploration of Microsoft Access 2016, focusing on advanced functionalities essential for enhancing your database management skills. You will learn to efficiently manage data, build robust queries, and create comprehensive reports.

We start with an examination of Relationships. You'll gain insight into referential integrity and the formalization of relationships between tables, essential knowledge for maintaining data consistency. This segment also touches upon naming conventions and includes practical exercises to create relationships effectively.

Next up: Queries. Here, you'll navigate through the query design view, review select queries, and learn about logical operators. This lesson covers parameter and action queries, including make table, append, update, and delete queries. Hands-on exercises will provide ample practice in creating both select and action queries, as well as parameter queries.

The course then transitions into Table Functions. This segment covers importing and linking tables from external sources, including other databases. You'll also learn to use templates and application parts to streamline your workflow. Exercises will provide practice in importing data from Excel and exporting data back to Excel.

Our exploration continues with Forms. You'll learn to design and format forms, add headers and footers, include logos and titles, and arrange fields. This lesson also covers setting the tab order and creating forms with application parts. Practical exercises will help you create and alter forms, including the addition of subforms.

In the Reports section, you'll gain insights into report design, adding and arranging fields, and handling report sections such as headers, footers, and details. This lesson includes guidance on grouping, sorting, and setting report properties. You're also introduced to special report fields like dates and page numbering. Exercises are designed to provide practical experience in creating and formatting reports.

The course then covers Macros and their basics. You'll learn to open tables, forms, and reports, run queries, and print reports. Exercises included in this section will help you create and run simple macros.

Finally, the course concludes with Completing the Desktop Application. Here, you'll learn to create navigation forms, run macros from these forms, and set them as default. This segment also covers database splitting, encryption, and distribution. Essential database maintenance tasks like compacting, repairing, and backing up your database are also covered, ensuring your data remains secure and accessible.

By the end of this course, you will have mastered advanced Microsoft Access 2016 skills, enabling you to build sophisticated databases, handle complex queries, and generate detailed reports. These skills will make you proficient in managing and manipulating data, beneficial for any organization looking to optimize their database management efforts.