ECDL, ECDL Advanced & ECDL CAD

Getting started with Access

• Access Overview/Database Design Theory
• What is a Relational Database
• Screen Elements and Help Tools

Tables

• Using the Table Wizards
• Manual Creation of Tables
• Fields, Data Types and Properties
• Input Masks
• Data Validation
• Importing Data
• Primary Keys and Relationships

Inputting Data

Finding Records

• Using the Find feature to find Records
• Using the Replace feature to replace text

Filters

Queries

• Designing Queries
• Query Wizard Overview
• Sorting and Searching Queries
• Multi-Table Relationship Queries
• Update, Append & Delete Action Queries

Forms

• Introduction to Form Design
• Form Wizards
• Toolbox Controls
• Combo Boxes & Command Buttons
• Main/Sub Form Creation
• Creating a Menu Form

Reports

• Report Wizard
• Creating Reports

About SquareOne

Any SquareOne course can be tailored to meet the particular requirements of your organisation.  We will be happy to use any of your examples for delegates to ensure that the course is as interesting and relevant as possible.

Course Objectives

This course is suitable for all new users of Access who wish to set up and design databases for input.  This course will help you understand the many uses of Databases.

Course Details

Duration:    2 Day

Course Contents

The subjects listed on the left are an outline. If there are any additional subjects you wish to cover, please feel free to call us prior to the course.