Follow us:

Courses

Microsoft Access: Intermediate

person writing notes on a pad of paper by a laptop
  • https://blackatlastraining.com/wp-content/uploads/2025/10/course-logo-access-2025-150x150.jpg

  • Microsoft Access: Intermediate

    Microsoft Office

  • $495.00

Course Overview

Your training and experience using Microsoft Access has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access will result in a robust, functional database for your users.

Prerequisites

You should have basic knowledge of Windows including opening applications and opening files from File Explorer. You should have a working knowledge of all topics covered in Access Novice.

What You Will Learn

  • 01
    Designing a Relational Database
  • Relational Database Design
  • Create a Table
  • Create Table Relationships
  • 02
    Joining Tables
  • Create Query Joins
  • Relate Data Within a Table
  • Work with Subdatasheets
  • 03
    Using Data Validation
  • Use Field Validation
  • Use Form and Record Validation
  • 04
    Creating Advanced Queries
  • Create Parameter Queries
  • Summarize Data
  • Create Subqueries
  • Create Action Queries
  • Create Unmatched and Duplicate Queries
  • 05
    Organizing a Database for Efficiency
  • Data Normalization
  • Create a Junction Table
  • Improve Table Structure
  • 06
    Using Advanced Reporting Techniques
  • Include Control Formatting in a Report
  • Add a Calculated Field to a Report
  • Add a Subreport to an Existing Report

Included With The Course

  • Professional textbook (physical and digital)
  • Unused copy of any files referenced throughout the textbook.
  • Certificate of completion signed by the instructor.

Associated Certifications

Not applicable.

Frequently Asked Questions

We understand that you may have questions, and we’re here to help! Some of the most commonly asked questions about this course are covered below but if they don’t cover what you are looking for feel free to reach out to us through our contact page, and we’ll respond promptly to ensure you get the assistance you require. Your satisfaction is our priority, and we’re committed to making sure you have all the information necessary for a seamless experience.

There are a few different versions of OneNote out there. There is the online version that comes with Microsoft 365, the version that comes installed with Windows, and the Microsoft 365 desktop application. This course covers the Microsoft 365 desktop application but a lot of the features can be found in the others as well.

You can find additional information on the different versions of OneNote by clicking here.