Microsoft Access - Introduction
Course Description
This is a Microsoft Access Introduction course. The teaching approach contains a mix of lectures, practical and one-to-one work and varies according to the people attending. For the most part, candidates are able to work at a pace which best suits them, and emphasis is placed upon quality of learning, rather than quantity.
Course Duration
1 day
Course Objectives
On completion of this course delegates should be familiar with the basic features of Microsoft Access.
Course Content
EXPLORING ACCESS
Databases Overview
Opening an Existing Database
Converting Existing Databases
The Access Window
Using Database Objects
Using the Object Window
Dialog Boxes and Task Panes
Working with Navigation Pane
Exiting Access
Security Warnings
CREATING DATABASE TABLES
Planning Database Tables
Methods for Creating Tables
Creating Tables in Design View
Data Types
Editing Table Structure in Design View
Setting a Primary Key
WORKING WITH DATA IN TABLES
Navigating Fields in Tables
Adding Records
Selecting Entire Records
Editing Records
Saving Records
Deleting Records
SETTING FIELD PROPERTIES
Limiting Field Size
Setting Number Formats
Setting Date/Time Formats
Setting Yes/No Formats
Setting Default Values
Validation Rules
Create a Lookup List Using the Lookup Wizard
Modifying Lookup Properties
USING SIMPLE QUERIES
The Query Wizard
Creating a Query in Design View
Opening a Query
Running a Query
Adding a Table to a Query
Join Types in a Query
MODIFYING QUERY RESULTS
Sorting a Query
Adding Simple Criteria to a Query
Hiding a Field in a Query
Adding New Records and Editing Data in a Query
CREATING BASIC FORMS
Using Form Tools to Create a Form
Using the Form Wizard
Navigating Records in a Form
Printing Records in a Form
Working With Data in a Form
EDITING FORMS AND REPORTS IN LAYOUTS
Moving & Sizing Controls
Adding & Deleting Controls
CREATING BASIC REPORTS
Create a Report
Viewing Reports
Printing a Report
Grouping Report Data
CREATING RELATIONSHIPS
Creating a Relationship between Tables
Setting Referential Integrity
Viewing Subdatasheets
Deleting a Relationship
Databases Overview
Opening an Existing Database
Converting Existing Databases
The Access Window
Using Database Objects
Using the Object Window
Dialog Boxes and Task Panes
Working with Navigation Pane
Exiting Access
Security Warnings
CREATING DATABASE TABLES
Planning Database Tables
Methods for Creating Tables
Creating Tables in Design View
Data Types
Editing Table Structure in Design View
Setting a Primary Key
WORKING WITH DATA IN TABLES
Navigating Fields in Tables
Adding Records
Selecting Entire Records
Editing Records
Saving Records
Deleting Records
SETTING FIELD PROPERTIES
Limiting Field Size
Setting Number Formats
Setting Date/Time Formats
Setting Yes/No Formats
Setting Default Values
Validation Rules
Create a Lookup List Using the Lookup Wizard
Modifying Lookup Properties
USING SIMPLE QUERIES
The Query Wizard
Creating a Query in Design View
Opening a Query
Running a Query
Adding a Table to a Query
Join Types in a Query
MODIFYING QUERY RESULTS
Sorting a Query
Adding Simple Criteria to a Query
Hiding a Field in a Query
Adding New Records and Editing Data in a Query
CREATING BASIC FORMS
Using Form Tools to Create a Form
Using the Form Wizard
Navigating Records in a Form
Printing Records in a Form
Working With Data in a Form
EDITING FORMS AND REPORTS IN LAYOUTS
Moving & Sizing Controls
Adding & Deleting Controls
CREATING BASIC REPORTS
Create a Report
Viewing Reports
Printing a Report
Grouping Report Data
CREATING RELATIONSHIPS
Creating a Relationship between Tables
Setting Referential Integrity
Viewing Subdatasheets
Deleting a Relationship
Who should attend?
This is a course with a high level of practical content, aimed at those who have not used Microsoft Access perviously. It is designed for candidates with widely differing experience and skill levels.
Pre-requisites
No previous experience of Microsoft Access is necessary, but candidates should have a good understanding of computer basics and be familiar with the Windows operating system.