Access 365 Advanced

Learn to structure tables by subject, and use the table analyzer to split an excel-like dataset into relational tables: companies, orders, products, and order details with lookups and a query.

Learn to normalize unnormalized tables by restructuring into properly structured tables with primary keys, removing duplicates via append queries, and enabling relationships between projects and assignments.

Learn how to fix many-to-many data issues by creating a junction table that links employees and projects, enforcing referential integrity and enabling joins, queries, and counts.

Learn to back up a Microsoft Access database to prevent data loss, using file save as or the backup database option that labels backups with the date.

Learn how to use Access's compact and repair database tool to reduce file size, fix fragmentation, and ensure accurate size reporting, including the compact on close option.

Discover how to use the object dependencies tool to identify objects that depend on a table or query and the objects that a given item uses, guiding safe changes.

Document your access database with the database documenter to create a comprehensive report of all tables, fields, relationships, and permissions, saveable as a PDF.

Explore how to use the analyze performance tool to evaluate your database, receive ideas and recommendations, and implement optimizations such as adding indexes to improve efficiency.

Create a secure database navigation using a navigation form in Access 365 Advanced, placing forms and reports in left or top layouts for easy access.

Rename left navigation buttons to user-friendly labels, such as view/edit customers, orders, products, and vendors, in layout view. Format with format tab and design view to adjust captions and colors.

Configure startup options to transform a database into an app-like portal by setting a custom title, hiding the navigation pane, using tab documents, and leveraging access keys.

Split your database into a back end with tables and a front end with queries, forms, and reports, using the Access database splitter or SharePoint as the back end.

Protect your VBA modules in Access databases with password protection and project locking, then digitally sign code to run even when not in a trusted location by configuring trusted locations.

Learn to password protect a database by encrypting with a password, using exclusive open, and managing the password in file info for the 2007 file format or later.

Convert your database to an accde file to reduce size, boost performance, and let users run reports, update data, and queries while disabling design changes and VBA code.

Explore Visual Basic for Applications (VBA) basics, compare it with Excel macros, and learn to leverage VBA for looping, debugging, and custom functions in Access.

Explore the VBA environment, create a module, and use variables with dim and if-then-else alongside message boxes to build dynamic code.

Export a table or query to Excel using VBA, demonstrating variable setup, SQL statements, a query list drop-down, and DoCmd.TransferSpreadsheet with user prompts.

Convert macros to VBA, add error handling and comments, and tailor the generated Visual Basic code in modules.

Establish trusted locations via the trust center and configure macro settings to block unsigned macros and run only digitally signed ones.

Explore how table events automate actions inside Access 365 Advanced tables using before and after events, data macros, and table properties, lookups and data validations.

Use a before change data macro to auto-calculate the discount from quantity thresholds. Set 15% for 50+, 10% for 40+, 5% for 30+, otherwise 0%.

In Access 365 Advanced, apply an after update event on the price field to log product price changes in the system log, using the updated command and log event description.

Structure your database and its tables before adding data to simplify maintenance and future restructuring. Use conditional formatting for forms and leverage macros and table events to automate workflows.