Access Level 1

Course Length: 1-day

Course Overview

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

Getting Started with Access

• What is Microsoft Access?
• Components of a Database
• Create a Simple Database
• Creating a Simple Form

Working with Table Data

• Work with Table Data
• Work with Records
• Sort and Filter Records
• Create Lookups and Relationships

Query a Database

• Use a Query to View Data from Multiple Tables
• Sort and Filter Data in a Query
• Perform Calculations in a Query

Create Advanced Queries

• Create Parameter Queries
• Create Action Queries
• Create Find Duplicate and Find Unmatched Queries
• Summarize Data

Generate Reports

• Create a Report
• Add Controls to a Report
• Advanced Reporting

Design a Relational Database

• Relational Database Design
• Working with Tables
• Modify a Table and Fields
• Create Table Relationships

Joining Tables

• Create Query Joins
• Working with Subdatasheets and Subqueries

Importing and Exporting Data

• Import Data into Access
• Export Data
• Create a Mail Merge