Access - Level 1

Course Description

Access - Level 1 is an introductory, instructor-led Microsoft course designed for individuals who want to organize, track, and understand data for themselves and their organizations. This hands-on course builds foundational Microsoft Access skills that are essential for today’s workplace. Through live instruction and practical exercises, you will learn how to design and create a database, navigate and search for data, enter information, and build basic tables, queries, forms, and reports using relational database principles. This practical course covers:

Getting started with Access
Creating tables and queries
Creating forms
Creating reports

This course is ideal for professionals, office staff, or students who need to build and manage databases for personal or organizational use.

Participant Outcomes

Upon successful completion of this course, you will be able to:

Get comfortable with Microsoft Access: explore the interface, set up a simple database, and adjust settings to fit your workflow.
Keep your data organized by creating and managing tables.
Find and combine the information you need using queries to sort, filter, and join tables.
Make data entry and viewing easier with user-friendly forms.
Turn your data into clear, professional reports you can share.

Course Content

Lesson 1: Getting Started with Access

Launch Access & Open a Database: Learn how to start Access and open existing databases.
Store Data in Tables: Understand how tables keep your data organized.
Use Queries to Explore Data: Find, filter, sort, and combine information from different tables.
Use Forms for Easy Data Entry: Make it simple to view, add, and update information.
Create Reports to Share Data: Present your data clearly with professional-looking reports.
Get Help & Customize Access: Learn how to find support and adjust settings to your needs.

Lesson 2: Creating Tables

Plan Your Database: Think through what your database needs before building it.
Start a New Database: Set up a fresh Access database from scratch.
Create Tables: Build the tables that store your data.
Link Tables with Relationships: Connect your tables so data works together efficiently.

Lesson 3: Creating Queries

Build Basic Queries: Extract the information you need quickly.
Use Calculations in Queries: Add calculations to get deeper insights from your data.
Sort & Filter Data: Make it easy to find exactly what you’re looking for.

Lesson 4: Creating Forms

Build a Form: Set up a user-friendly way to interact with your data.
Enhance Your Form: Customize forms to make them more functional and appealing.

Lesson 5: Creating Reports

Start a Report: Turn your data into a professional report.
Enhance Report Layout: Format and polish reports for clarity and impact.