Advanced Microsoft Access 365 Training

Advanced Microsoft Access 365 Training Courseware (ACC365.2)

MicrosoftMicrosoft Access

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.

Publisher: Webucator

Benefits

  • 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.

Outline

  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

Required Prerequisites

None

License

Length: 2 days | $40.00 per copy

LicenseRequest More InformationDownload Sample CopyRequest Trainer Evaluation Copy
What is Included?
  • Student Manual
  • Student Class Files