Access Level 1

Course Description
Students will learn the basic skills necessary to begin using Access. They will design and create databases, tables, queries, forms, and reports.

Prerequisites
Computers for Beginners or equivalent knowledge.

Study Method:
Flexible Learning:  Group Training

What Next?
Access Level 2

Course Content

Lesson 1: Overview of Access

Introduction to Database Concepts and Terminology 

Introduction to Access 

Database Planning and Design

Lesson 2: Creating Tables

Examining a Table 

Creating a Table With the Table Wizard 

Creating a Table in Design View

Types of Primary Keys

Lesson 3: Working with Tables

Modifying a Table Using Design View

Finding and Editing Records

Filtering and Sorting Records

Lesson 4: Creating and Using Select Queries

Creating a Select Query to View Specific Fields

Specifying Criteria in a Query to View Specific Records

Using Queries to Perform Calculations

Joining Tables in a Query

Lesson 5: Creating and Using Forms

Creating a Form With the Form Wizard

Modifying the Form Design

Using a Form to Locate and Organize Information

Multiple-Table Forms

Lesson 6: Creating and Using Reports

Creating a Report With the Report Wizard

Creating a Report That Contains Totals

Lesson 7: Creating and Maintaining a Database

Creating a Database

Managing a Database and Its Objects

Database Maintenance

[ Home ] [ Computer Skills ] [ Office Skills ] [ Professional IT courses ] [ Business Courses ] [ Contact ] [ Group Training ] [ Flexible Learning ] [ Distance Learning ] [ Certification | Training West Midlands/Microsoft West Midlands/Sage West Midlands/Bookkeeping West Midlands ]