Microsoft On-Demand

Advanced Microsoft Access 365 Training On-Demand (ACC365.2)

6 hours
Microsoft AccessMicrosoftMicrosoft Office

Develop advanced Microsoft Access 365 skills in queries, relationships, data integration, forms, reports, macros, navigation, and database maintenance.

Talk to a Learning Consultant

Enroll in On-Demand Training

Price per student
$49.00
  • On-demand access, 24/7
  • Readings, videos, and exercises
  • Quizzes to check your knowledge
  • Lifetime access

Interested in a private class? Click Here

Course Overview

Build on your Microsoft Access experience to create powerful, efficient, and maintainable desktop databases. Designed for power users, analysts, developers, and teams, this advanced course covers relationships, complex queries, external data exchange, and the creation of polished forms and reports.

You will also learn to automate tasks with macros, create navigation forms, split databases for distribution, and apply maintenance practices that support user-friendly Access applications.

Course Benefits

  • Create table relationships and apply referential integrity to improve data accuracy and consistency.
  • Build parameter, select, and action queries for analyzing and managing data.
  • Import, link, and export data using Excel, other databases, and external sources.
  • Design and refine forms with effective layouts, formatting, properties, and subforms.
  • Create professional reports with grouping, sorting, controls, special fields, and subreports.
  • Use macros to automate repetitive database tasks.
  • Build navigation forms and configure them as application interfaces.
  • Split, distribute, and maintain desktop Access databases.

Course Outline

  1. Relationships
    1. Review
    2. Referential integrity
    3. Relationships
    4. Naming conventions
    5. Creating relationships exercise
  2. Advanced Queries
    1. Query Design view
    2. Review of select queries
    3. 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. Importing 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. Creating forms with Application Parts
    5. Creating a subform
    6. Creating forms exercise
    7. Modifying 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 report properties
    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. Navigation forms
    2. Running macros from a navigation form
    3. Setting a 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

Course Prerequisites

Required experience

Participants should have prior experience with Microsoft Access and be comfortable creating and working with basic tables, queries, forms, and reports.

Prerequisite Courses

Have questions about this course?

We can help with curriculum details, delivery options, pricing, or anything else. Reach out and we’ll point you in the right direction.

Talk to a Learning Consultant