Access 2016 Advanced

Learn to diagnose normalization issues between employees and projects, set primary keys, and enforce referential integrity. Build a junction table and append queries to create properly related, normalized tables.

Explore the object dependencies tool in a relational database to see what queries, forms, and reports depend on a table and which tables a query or form relies on.

Use the database documenter to generate a text backup of your database design, including tables, fields, and properties, enabling easy rebuilds or reference later.

Explore how to create and use a switchboard in Access, a multi-user solution built with interactive forms and command buttons to open forms, run reports, and restrict access.

Learn to create and manage Access 2016 switchboards with the Switchboard Manager, including a main and sub switchboards, and buttons to open forms, reports, and exit the application.

Split the database to enhance security by moving tables to a back-end and linking them to a front-end with forms, queries, and reports, potentially password-protecting the back-end.

Open the backend database in exclusive mode, encrypt with a password to protect it, and require the correct password to access the database.

Save your database as an accde file to create an executable only format that prevents design changes in forms, reports, and VBA, while keeping code functional.

Explore how VBA automates database tasks in Access, contrast macros with VBA, and navigate modules, procedures, and event procedures for forms and reports.

Discover how table events in Access 2016 work by embedding event procedures directly in the table, covering before and after events like before change and after insert.

Explore how a before change event automatically updates a discount field (15%, 10%, 5%, or 0%) based on quantity thresholds using if/else logic before saving.