1 day

Course Description

Access is Microsoft’s flagship database application that allows you to create and manage databases for all sorts of different purposes. This version of Access incorporates a few new features to better visualize data, support for new datatypes, as well as interface and workflow improvements.  This course is intended to help all novice computer users get up to speed quickly and, will also help more experienced users who have little to no experience with Microsoft Access and databases in general.

By the end of this course, users should be comfortable with navigating the Microsoft Access interface, creating a new database from scratch, querying a database, generating reports, sharing data, and much more.

 

Prerequisites

Before attending this course, students must have:

Basic computer knowledge

Basic file management skills

Basic Excel knowledge is helpful

 

Course 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

You may also be interested in:

Access Level 2

 

Certification

Before testing you will need:

  • Access Level 1 Foundation
  • Access Level 2 Intermediate

Wondering if you should start with Level 1?

Take our class placement self-assessment to help you decide.