Access 2013 Advanced

Analyze database issues with the table analyzer wizard. It splits a single table into subject tables: tblCustomers, tblOrders, tblProducts, tblSuppliers, and creates a unifying query.

Learn to create a manual backup of a Microsoft Access database as part of a disaster recovery plan by using the backup feature with automatic date stamping.

Learn to use the compact and repair tool in Access 2013 to reclaim unused space, reduce database size from 3.75 MB to 2.24 MB, and boost performance.

Document your Access 2013 advanced database by generating a comprehensive all-objects report with the database documenter tool, including tables, queries, forms, reports, and relationships.

Use the Performance Analyzer tool from the Database Tools tab to analyze tables, queries, or all object types. It provides recommendations, including indexing fields to speed up access.

Learn to simplify Microsoft Access for end users with switchboards that present only the essential tasks—data entry, orders, customers, and reports—through linked sub-switchboards.

Plan your switchboard by defining main switchboard pages, linking to other switchboards, and adding commands for forms, reports, and data entry, using the switchboard manager via the quick access toolbar.

Explore configuring and branding an Access 2013 switchboard by editing the switchboard items table and the switchboard form, applying colors, fonts, background color, and logos.

Learn to support multiple concurrent users by splitting the database with the Database Splitter, linking front end to back end tables, and managing drive letters and network locations.

Configure trusted locations in Access to stop the enable content prompt and ensure databases in specified folders and sub-folders open safely by enabling trusted locations in the trust center.

Open the database exclusive and encrypt with a password in Access 2013 advanced; for split databases protect the front end, use strong passwords, test reopening, and note no official recovery.

Convert your access database to an accde file to reduce size and improve performance while restricting end users from designing forms or VBA code, yet enabling queries and data entry.

Automate Access tasks with VBA, compare macros and VBA, and loop through a record set while creating custom functions and debugging step by step.

Learn to export a table or query from Access to Excel using a modular VBA procedure. Create a reusable export routine, configure transfer spreadsheet, and test with an example.

Create a custom switchboard in Access 2013 advanced using VBA to open forms, queries, reports, and tables from drop-downs; open forms in add mode and reports in print preview.

Convert a macro to visual basic for applications to unlock the vba object model and extend functionality. Use fully qualified form references and the forms collection to make code reusable.

Discover table events in Access, introduced in 2010, and define before and after change, delete, and update actions on the table that propagate to all forms.

Use the before change event to set the discount from the quantity field with nested else/if conditions: 100+ yields .15, 50+ yields .10, 25+ yields .05, else zero, on save.

Learn to use the after update event to log pay rate changes in Access 2013 advanced, comparing old and current payrates and recording in a hidden log table for audit.

Master access 2013 advanced topics, including improving relational database structure, manual append queries, switchboards, security for multi-user front-end back-end, compact and repair, VBA automation with table events and macros.