Microsoft Private On-Demand

Introduction to Microsoft Access 365 Training (ACC365.1)

2 days
Microsoft AccessMicrosoftMicrosoft Office

Learn Microsoft Access 365 essentials: database design, tables, relationships, queries, forms, reports, normalization, and efficient data management skills.

Talk to a Learning ConsultantRequest a Private Class

Register or Request Training

  • Private class for your team
  • Live expert instructor
  • Online or on‑location
  • Customizable agenda
  • Proposal responses same day as request
Request Proposal
Price per student
$99.90 or 2 vouchers
  • On-Demand 24/7
  • Readings, Video Presentations, Exercises
  • Quizzes to knowledge check
  • Life-Time Access

Course Overview

Build a practical foundation in database management with Microsoft Access 365. This beginner-friendly course is designed for business professionals, administrative staff, analysts, and others ready to move beyond spreadsheets.

Learn how to plan and create relational databases, structure tables, define relationships, build queries, design data-entry forms, and produce reports. You will also explore normalization and essential database design practices for keeping information accurate and organized.

Course Benefits

  • Determine when a relational database is more appropriate than a spreadsheet.
  • Navigate the Microsoft Access 365 interface and create a database with built-in tools and wizards.
  • Plan well-structured databases using naming conventions, normalization, and table relationships.
  • Create and manage tables with suitable data types.
  • Import and link existing data.
  • Build queries that filter, group, analyze, and summarize information.
  • Create user-friendly forms for data entry and record navigation.
  • Produce reports that present database information clearly.

Delivery Methods

Private Class
Delivered for your team at your site or online.
On-Demand
Learn at your own pace with 24/7 access.

Microsoft Certified Partner

Webucator is a Microsoft Certified Partner. We design and deliver training that aligns directly with Microsoft's official technologies, standards, and learning objectives.

Microsoft Certified Partner

Course Outline

  1. Database and Microsoft Access Concepts
    1. Defining a Database
    2. Databases and Spreadsheets
    3. Microsoft Access and Excel
    4. Choosing a Spreadsheet or Database
    5. Relational Databases
    6. Understanding Relational Databases
    7. Relational Database Management Systems
    8. Access as an RDBMS
    9. Creating a Relationship
    10. Benefits and Limitations of Access
  2. The Access Interface
    1. The Ribbon
    2. The Quick Access Toolbar
    3. The Object Navigation Pane
    4. The Access Work Surface
    5. Access Objects
    6. The Access Workflow
    7. Navigating the Access Environment
    8. Creating a Database with a Wizard
  3. Database Design Fundamentals
    1. Questions to Ask Before Starting
    2. Identifying Database Requirements
    3. Approaches to Database Design
    4. Gathering Information
    5. Naming Conventions
    6. Practicing Information Gathering
    7. Normalization
    8. Table Relationships
    9. Normalizing Data
  4. Tables and Table Views
    1. Table Purpose and Structure
    2. Datasheet View
    3. Working with Tables in Datasheet View
    4. Importing a Table of Data
    5. Design View
  5. Creating and Managing Tables
    1. Creating an Access Database
    2. Creating a New Database
    3. Data Types
    4. Selecting Data Types
    5. Creating a Table in Design View
    6. Practicing Table Creation in Design View
    7. Linking a Table of Data
  6. Queries
    1. Query Fundamentals
    2. Select Queries
    3. Select Queries with Criteria
    4. Logical Operators
    5. Grouping and Totals
    6. Creating Select Queries
  7. Forms
    1. Form Fundamentals
    2. Modifying a Form
    3. Adding Records in Form View
    4. Form Record Navigation
    5. Layout View and Design View
    6. One-Click Forms
    7. The Form Wizard
    8. Creating a Form with the Form Wizard
  8. Reports
    1. Report Fundamentals
    2. The Report Wizard
    3. Creating a Report with the Report Wizard

Class Materials

Each student receives a comprehensive set of materials, including course notes and all class examples.

Class Prerequisites

Experience in the following is required for this Microsoft Access class:

No previous database experience is required.

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