INTRODUCTION TO ACCESS - Stage 1 Course

Overview

This introduction course is suitable for complete beginners to Microsoft Access.

Prior Knowledge Requirements

Basic computer skills such as using a mouse, navigating through windows and surfing the Internet.

The course covers the following areas:

Database Concepts

• Database concepts and terminology
• Exploring the Access environment
• Planning and designing databases
• Getting help
• Closing a database and Access

Access Basics

• Exploring Tables
• Exploring Queries
• Exploring Reports

Creating Databases

• Creating a database
• Using the Table Wizard
• Working in Design View

Working with Fields and Records

• Changing the design of a Table
• Adding and deleting records
• Finding and editing records
• Sorting and filtering records
• Field Properties
• Indexing
• Primary Indexes

What's next?

At the end of this course the student will feel confident using Access, and be able to create and design simple databases. The understanding and use of tables, fields and records, and the rules for entering data, is the foundation from which simple Quries, Forms and Reports can be created.

After completing this course the student will be ready to attend an Access Intermediate training course. 

    

Querying Tables

• Creating basic Queries
• Running Queries
• Modifying Query results and Queries
• Using calculations in Queries
• Saving Queries
• Printing Query results

Creating and using Forms

• Creating Forms by using AutoForm
• Using the Form Wizard
• Using Design View to create Forms
• Finding, sorting and filtering records
• Formatting Forms

Creating and using Reports

• Using the Report Wizard
• Creating Reports
• Modifying Reports using Design View
• Sorting and Grouping data within Reports
• Print options