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.