Access: Level 1
Overview: In this course, you will learn the basics skills necessary
to begin using Access . You will design and create databases, tables,
queries, forms, and reports.
Table of Contents
LESSON 1: Overview of Access
· Introduction to Database Concepts and Terminology
· An Introduction to Access
· Database Planning and Design
LESSON 2: Creating Tables
· Examining a Table
· Creating a Table by Using the Table Wizard
· Creating a Table in Design View
LESSON 3: Working with Tables
· Modifying the Table Design
· Finding and Editing Records
· Filtering and Sorting Records
LESSON 4: Using Select Queries
· Selecting Fields and Sorting Records
· Refining the Results of a Query
· Joining Tables in a Query
LESSON 5: Creating and Using Forms
· Creating a Form
· Modifying the Form Design
LESSON 6: Creating and Using Reports
· Creating a Report