Advanced Microsoft Access 365 Training (ACC365.2)

Advanced Microsoft Access Training is intended for professionals and teams who already have experience with Microsoft Access and want to build more powerful, efficient, and maintainable databases. It’s ideal for power users, analysts, and developers responsible for managing complex data or creating multi-table Access applications. This course helps organizations improve data accuracy, streamline workflows, and expand the capabilities of their existing Access solutions.

Participants will learn advanced techniques for working with relationships, queries, forms, and reports, as well as how to import, link, and export data from external sources. The course also introduces macros and navigation forms to help automate tasks and create complete desktop database applications. By the end of the course, learners will be able to optimize databases, improve usability, and deliver more polished, professional Access applications.

1. Relationships
   1. Review
   2. Referential Integrity
   3. Relationships
   4. A Few Words about Naming Conventions
   5. Creating Relationships (Exercise)
2. Advanced Queries
   1. Query Design View
   2. Review of Select Queries
   3. Review of Select Queries with Criteria
   4. Logical Operators
   5. Parameter Queries
   6. Action Queries
   7. Creating Select and Action Queries (Exercise)
   8. Creating a Parameter Query (Exercise)
3. Table Functions
   1. Importing Data
   2. Linking Tables from External Sources
   3. Import Tables from other Databases
   4. Tables from Templates and Application Parts
   5. Importing Data from Excel (Exercise)
   6. Exporting Data
   7. Exporting Data to Excel (Exercise)
4. Advanced Forms
   1. Design View
   2. Formatting
   3. Tab Order and Properties
   4. Create Forms with Application Parts
   5. Creating a Subform
   6. Creating Forms (Exercise)
   7. Alter a Form
5. Advanced Reports
   1. Design View
   2. Report Sections
   3. Arranging Fields on a Report
   4. Resizing the Detail Section
   5. Grouping and Sorting
   6. Setting Properties on a Report
   7. Special Report Fields
   8. Controls
   9. SubReports
   10. Application Parts
   11. Deleting a Report
   12. Formatting a Report
   13. Creating Reports (Exercise)
6. Macros
   1. Macro Basics
   2. Running a Macro
   3. Creating Simple Macros (Exercise)
7. Completing the Desktop Application
   1. The Navigation Form
   2. Running Macros from a Navigation Form
   3. Setting the Navigation Form as the Default Form
   4. Creating a Navigation Form (Exercise)
   5. Splitting the Database
   6. Distributing the Front-End Database
   7. Database Maintenance

Each student receives a comprehensive set of materials, including course notes and all class examples.