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
The ‘Tell me what to do...’ Function
Discussion and Question Time
Please contact us today if you have any questions about our Microsoft Courses. We offer both classroom and virtual training options. Contact us at +353 1 279 0020 or Email us at sales@olas.ie