Course length:  1/2-day

Course Description

Microsoft’s Office Access is Microsoft’s popular database program.  Microsoft Access is an information management tool that allows you to store, report, and analyze information within a relational database. If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access will be helpful to you. Access makes it easy to keep track, organize, and sort your data.

This course helps access users understand and make the most out of Access queries.

In this advanced Microsoft Access course, students will review the basics of querying in Access and learn to use advanced querying techniques to get the results they need from their data.

Prerequisites

Before attending this course, students must have completed Access Foundation (Level 1) or have equivalent knowledge.

Access Part 1 or equivalent Knowledge

Course Outline

Query Basics

Specialized Queries

Data Management queries (Action Queries)

SQL Queries