Microsoft Access Introduction
Course Duration: One Day
Target Audience:
Aimed at users who are new Microsoft Access and want to set up their own databases.
Course Objectives:
To plan, design, create, manipulate, and query databases. Use Access to generate reports, understand terminology and produce input user forms
Course Outline:
Introduction and Overview
-
Course Objectives
-
Course Programme Overview
-
Accessing Access
-
Exploring the User Interface and Ribbon
Introduction to Databases
-
Database Concepts
-
Features and Terminology
-
Planning and Designing a Database
Introduction to Access
-
Access Environment
-
Access Components - Tables, Queries, Forms, and Reports
Creating a Database
-
Creating a New Database
-
Setting up a Table
-
Table Terminology
-
Table Design
-
Field Data Types
-
Field Properties
-
Setting the Primary Key
-
Modifying a Table Design
Working with a Table
-
Adding Records to a Table
-
Moving through Records
-
Finding Records
-
Editing Records
-
Deleting Records
-
Sorting Records
-
Filtering Records
Creating a Query
-
Creating a Simple Query
-
Using the Query Design Grid
-
Naming a Query for Future Use
-
Modifying an Existing Query
Creating Complex Queries
-
Creating a Complex Query
-
Using Arithmetic Operators
-
Using Logical Operators
-
Creating Queries with Multiple Criteria
-
Sorting the Query Dynaset
-
Hiding Fields in a Query
Other Query Types
-
Creating a Parameter Query
-
Creating a Calculated Query
-
Creating a Totals Query
Access Forms
-
Using Automatic Forms
-
Using the Form Wizard
-
Using the Form Design Feature
-
Modifying Forms
-
Adding Controls to a Form
-
Formatting Forms
Using Forms
-
Displaying Records through a Form
-
Adding Records through a Form
-
Finding Records through a Form
Access Reports
-
Creating Automatic Reports
-
Using the Report Wizard
-
Using the Report Design Feature
-
Grouping and Sorting Records on a Report
-
Adding Calculations to a Report
-
Modifying a Report Design
-
Formatting a Report
-
Creating Labels in Access
-
Printing Reports