Advanced Microsoft Access 365

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.

After this course participants should be able to:

• Enforce data accuracy and consistency by creating table relationships and applying referential integrity.
• Design advanced queries, including parameter and action queries, to analyze, update, and manage data efficiently.
• Import, link, and export data from external sources such as Excel and other databases.
• Create advanced forms with improved layout, formatting, subforms, and user-friendly navigation.
• Build sophisticated reports using grouping, sorting, controls, and subreports to present data clearly.
• Automate repetitive tasks by creating and running macros to improve productivity.
• Develop complete desktop Access applications with navigation forms, database splitting, and maintenance best practices.

1- Relationships

• Review
• Referential Integrity
• Relationships
• A Few Words about Naming Conventions
• Creating Relationships (Exercise)

2- Advanced Queries

• Query Design View
• Review of Select Queries
• Review of Select Queries with Criteria
• Logical Operators
• Parameter Queries
• Action Queries
• Creating Select and Action Queries (Exercise)
• Creating a Parameter Query (Exercise)

3- Table Functions

• Importing Data
• Linking Tables from External Sources
• Import Tables from other Databases
• Tables from Templates and Application Parts
• Importing Data from Excel (Exercise)
• Exporting Data
• Exporting Data to Excel (Exercise)

4- Advanced Forms

• Design View
• Formatting
• Tab Order and Properties
• Create Forms with Application Parts
• Creating a Subform
• Creating Forms (Exercise)
• Alter a Form

5- Advanced Reports

• Design View
• Report Sections
• Arranging Fields on a Report
• Resizing the Detail Section
• Grouping and Sorting
• Setting Properties on a Report
• Special Report Fields
• Controls
• SubReports
• Application Parts
• Deleting a Report
• Formatting a Report
• Creating Reports (Exercise)

6- Macros

• Macro Basics
• Running a Macro
• Creating Simple Macros (Exercise)

7- Completing the Desktop Application

• The Navigation Form
• Running Macros from a Navigation Form
• Setting the Navigation Form as the Default Form
• Creating a Navigation Form (Exercise)
• Splitting the Database
• Distributing the Front-End Database
• Database Maintenance

Basic Microsoft Access knowledge and prior experience creating and working with databases are recommended.

None

None