Access Level 1 - Cairns

Course Overview

Learn the basics of this database program. The course provides you with all the basic tools you need as an Access user.

Prerequisites

Basic Windows knowledge required

Delivery Method

Group instruction and exercises. Hands on computer use. Individual computer for each participant. Manual provided.

Duration

6 hours (One daytime session or two evening sessions of 3 hours)

Price

 $141 ex GST

Course details including dates, times and prices are subject to change without notice

Topics

Concepts and Access

• What is Data?
• What is a Database?
• Basic Concepts The Telephone
• Directory - An Example of a Database
• Tables and Relationships
• Types of Relationships
• Why Use an Electronic Database?
• Why Use Access?

An Introduction to Access

• Introducing Access Tools
• Starting Microsoft Access
• The Access Application Window
• Concepts, Terminology and Usage
• Opening a Database
• The Access Database Window
• Closing a Database
• Opening a Table
• The Table Window
• Exploring the Table
• Table Design View
• Introducing Queries
• Introducing Forms
• Types of Form
• Opening an Existing Form
• Form Design View
• Introducing Reports

Design a Database

• Questions To Ask Yourself
• Define Your Needs
• Basic Design Rules
• Determine Relationships
• Creating a Database
• Using the Table Wizard
• Adding Fields Using the Table Wizard
• Creating a Table Without a Wizard
• Adding Fields to a New Table
• Field Properties
• The Input Mask Property
• Setting a Primary Key
• Saving a Table
• Adding Records to a Table Datasheet

Formatting an Access Table

• Editing Records
• Selecting Records With The Mouse
• Selection Using The Keyboard
• Selecting Fields With The Mouse
• Selecting Columns Using the Mouse
• Deleting Records and Fields
• Viewing Datasheet Default Values
• Re-ordering Columns Within a Table
• Re-Ordering Fields in the Table
• Changing Column Width & Row Height
• Hiding and Un-hiding Columns
• Freezing Columns
• Formatting Datasheet Cells
• Changing Datasheet Fonts
• Copying and Moving Fields & Records
• Another Look at the Database Window
• Printing

Locating and Replacing Information

• A Simple Search
• Wildcards
• Finding Specific Values
• Find and Replace
• Sorting Records
• What is a Filter?
• Filtering Records By Selection
• Filtering Records By Form

Creating Simple Queries

• What are Queries?
• Opening an Existing Query
• Creating Queries,
• Using the Simple Query Wizard
• Queries & the Wizard
• The Query Grid

Introducing Forms

• Introduction to Forms
• Basic Form
• Layout Types
• Creating a Form
• Using AutoForm
• Creating a Form
• Using the Form Wizard
• Different Waysof Viewing Form

Reports

• Introduction to Reports
• Opening and Viewing Reports
• Printing Reports
• Creating a Report
• Using AutoReports
• Creating Reports
• Using the Report Wizard