Access Level 1

Audience:

You will benefit most from this course if you want to gain a basic understanding of Access and be able to design and create simple tables, queries, forms, and reports.

Prerequisites:

The course assumes you know how to use a computer, and that you are familiar with Microsoft Windows. It does not assume that you have used a different version of Access or another database system before.

Description:

This course provides the basic concepts and skills to start using Microsoft Access: How to navigate the Access interface, and how to create and modify tables, queries, forms, and reports.

Outline:

Chapter 1: Database Fundamentals

• Module A: Understanding general database terms
• Module B: Relational databases
• Module C: Access interface and objects

Chapter 2: Tables

• Module A: Creating tables
• Module B: Creating fields
• Module C: Data validation
• Module D: Relationships and keys

Chapter 3: Queries

• Module A: Creating basic queries
• Module B: Modifying queries
• Module C: Using calculated fields

Chapter 4: Forms

• Module A: Creating simple forms
• Module B: Form design
• Module C: Form controls

Chapter 5: Reports

• Module A: Creating reports
• Module B: Report controls