Microsoft Private On-Demand

Introduction to Microsoft Access 365 Training (ACC365.1)

2 days
Microsoft AccessMicrosoftMicrosoft Office

Learn Microsoft Access 365 fundamentals, including database design, tables, queries, forms, reports, relationships, normalization, and data management.

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 solid foundation in database management with Microsoft Access 365. Designed for beginners, this course is well suited to business professionals, administrative staff, analysts, and anyone moving from spreadsheets to a relational database.

Learn to plan and create databases, design tables, define relationships, build queries, develop data-entry forms, and produce professional reports. The course also introduces normalization and other essential design principles for organizing data accurately and efficiently.

Course Benefits

  • Understand when to use a database versus a spreadsheet and how Microsoft Access functions as a relational database.
  • Confidently navigate the Access 365 interface and create databases using built-in tools and wizards.
  • Plan and design well-structured databases using sound design principles, normalization, and relationships.
  • Create and manage tables with appropriate data types, including importing and linking existing data.
  • Build effective queries to filter, analyze, group, and summarize data.
  • Design user-friendly forms to simplify data entry and navigation.
  • Create professional reports to present and share 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. Databases and Access Terms
    1. Database Defined
    2. Databases vs. Spreadsheets
    3. Access vs. Excel
    4. Spreadsheet or Database (Exercise)
    5. Relational Database Defined
    6. Understanding Relational Databases (Exercise)
    7. Relational Database Management System (RDBMS) Defined
    8. Access is an RDBMS
    9. Creating a Relationship
    10. Benefits and Limitations of Access
  2. Quick Overview Access Interface
    1. Access Ribbon
    2. Quick Access Toolbar
    3. Object Navigation Pane
    4. Access Work Surface
    5. Object Overview
    6. Process Overview
    7. Getting Around the Access Environment (Exercise)
    8. Create a Database Using a Wizard
  3. Fundamentals
    1. Questions to Ask Before You Start
    2. Asking Questions (Exercise)
    3. Approaches to Database Design
    4. Gather Information
    5. A Few Words about Naming Conventions
    6. Gathering Information (Exercise)
    7. Normalization
    8. Table Relationships
    9. Normalizing Data (Exercise)
  4. Tables and Their Views
    1. Definition and Purpose
    2. Datasheet View
    3. Working with Tables in Datasheet View (Exercise)
    4. Import a Table of Data
    5. Design View
  5. Tables
    1. Creating an Access Database
    2. Creating a New Database (Exercise)
    3. Data Types
    4. Determining Data Types (Exercise)
    5. Create a Table in Design View
    6. Creating a Table in Design View (Exercise)
    7. Link a Table of Data
  6. Queries
    1. Queries
    2. Select Queries
    3. Select Queries with Criteria
    4. Logical Operators
    5. Group and Total with Queries
    6. Creating Select Queries (Exercise)
  7. Forms
    1. Forms
    2. Alter a Form
    3. Adding Data Records in Form View (Exercise)
    4. Form Record Navigation
    5. Layout View and Design View
    6. One-Click Forms
    7. Form Wizard
    8. Creating a Form with the Form Wizard (Exercise)
  8. Reports
    1. Reports
    2. Report Wizard
    3. Creating a Report with the Report Wizard (Exercise)

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 prior 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