MS Access

Microsoft Access

 

Microsoft Access 2019

Classroom Live Outline

Lesson 1: Getting Started with Access

  • Topic A: What is Microsoft Access?
  • Topic B: Components of a Database
  • Topic C: Create a Simple Database
  • Topic D: Creating a Simple Form

Lesson 2: Working with Table Data

  • Topic A: Work with Table Data
  • Topic B: Work with Records
  • Topic C: Sort and Filter Records
  • Topic D: Create Lookups and Relationships

Lesson 3: Query a Database

  • Topic A: Use a Query to View Data from Multiple Tables
  • Topic B: Sort and Filter Data in a Query
  • Topic C: Perform Calculations in a Query

Lesson 4: Create Advanced Queries

  • Topic A: Create Parameter Queries
  • Topic B: Create Action Queries
  • Topic C: Create Find Duplicate and Find Unmatched Queries
  • Topic D: Summarize Data

Lesson 5: Generate Reports

  • Topic A: Create a Report
  • Topic B: Add Controls to a Report
  • Topic C: Advanced Reporting

Lesson 6: Design a Relational Database

  • Topic A: Relational Database Design
  • Topic B: Working with Tables
  • Topic C: Modify a Table and Fields
  • Topic D: Create Table Relationships

Lesson 7: Joining Tables

  • Topic A: Create Query Joins
  • Topic B: Working with Subdatasheets and Subqueries

Lesson 8: Importing and Exporting Data

  • Topic A: Import Data into Access
  • Topic B: Export Data
  • Topic C: Create a Mail Merge

WHAT YOU’LL LEARN

What You’ll Learn, depends on your current level of expertise.

Upon successful completion of this course, you will be able to create and develop Access Tables, Forms and complete Databases in order to work with, data in related tables and report the data that is critical to the success of your organization.

  • Getting Started with Access
  • Working with Table Data
  • Query a Database
  • Create Advanced Queries
  • Generate Reports
  • Design a Relational Database
  • Joining Tables
  • Importing and Exporting Data