Advanced Microsoft Access

Advanced Microsoft Access Courseware (ACC201)

The Advanced Access course builds upon the foundational skills acquired in the Introduction to Access course, diving deeper into topics such as relationships, queries, table functions, advanced forms, reports, macros, and completing a desktop application. This course equips students with the skills and knowledge to handle more complex Access tasks, further enhancing their data management capabilities and proficiency with the software.

Access Version: This course primarily targets Access 2019; however, it can be used to teach Access 365 as well as earlier versions of Access. We draw attention to features that are not supported in earlier versions of Access, and point out alternative options, when available.

This is the updated version of 55280AC from the retired Microsoft Courseware Marketplace.

Publisher: Webucator

Benefits

  1. Advanced Skill Development: This course delves deeper into Access, covering more complex topics and techniques that will enable students to handle advanced tasks and projects.
  2. Hands-on Learning: With practical exercises, students will gain valuable hands-on experience, allowing them to apply their new skills and knowledge to real-world scenarios.
  3. Improved Data Management: By mastering advanced Access features, students will be better equipped to manage and organize data effectively in a wide range of applications.
  4. Experienced Authors: The course material is developed by experienced authors who have in-depth knowledge and expertise in Microsoft Access, ensuring that students receive accurate and valuable information.
  5. Preparation for Further Learning: The advanced skills and knowledge gained in this course will prepare students for further learning in related topics, such as database administration or programming.

Outline

  1. Relationships
    1. Review
    2. Referential Integrity
    3. Relationships
    4. A Few Words about Naming Conventions
    5. Creating Relationships (Exercise)
  2. 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. 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

  • Introductory-level knowledge and skills working with Microsoft Access.