Course Details

This course discusses the new Access interface and explores various database components, including tables, queries, forms, and reports. You will learn to create and modify new databases and their various objects. You will learn how to improve queries, forms, and reports.

Prerequisites

Basic Microsoft Office Excel

Target Audience

This course is intended for information workers who want to learn beginning-level Access skills 

Course Outline

Lesson 1: Getting Started with Microsoft Access

• What is a database?
• What is Microsoft Access?
• Planning the database
• Launching Microsoft Access

Lesson 2: The Access Workspace

• The Access Application Window   
• The Database Window
• The Access Database Objects

Lesson 3: Managing Files

• Creating a New File
• Opening an Existing File
• Renaming a Database
• Closing a Database and Quitting MS Access

Lesson 4: Working with Tables

• Terms used in Tables
• Understanding Table Properties
• Guidelines for Naming Fields
• Ways to Create Tables
• Working with Datasheet
• Working with data in a table
• Sorting and Filtering

Lesson 5: Introduction to Queries

• Types of Queries
• Creating Simple Queries
• Creating a query in Design View
• Finding Duplicates Query

Lesson 6: Introduction to Forms

• Ways to Create Simple Forms
• Creating forms

Lesson 7: Introduction To Reports

• Ways to Create a Report
• Creating Reports
• Printing Reports