Description
The objective of our Microsoft Access Introduction training course is to teach participants how to plan, design, create, manipulate and query databases. It will also teach them how to use Access to generate reports and produce input user forms.
Full Day Course Price: €350 per person
Click here to view the upcoming Virtual Live Training 1.5 hour session schedule.
To book onto a Virtual Live Training 1.5 hour session, or series of sessions, please click here.
Dates
- Dates available on request, please call for details – 1 Day
TARGET AUDIENCE
This Microsoft Access Introduction course is aimed at users who are new Access and want to set up their own databases.
PREREQUISITES
Participants need have no prior knowledge of Microsoft Access but should be comfortable using Microsoft Windows and should be able to start a Microsoft Office application, use the Help feature, and open, close and save files.
GOALS AND OBJECTIVES
Having completed this Access Introduction course, participants will be able to:
- Plan, design, create, manipulate and query databases
- Use Access to generate reports
- Understand database terminology
- Produce user input forms
Introduction and Overview
Objectives
Programme Overview
Accessing Access
Explore the User Interface
Explore the Access 2019 Ribbon
Introduction to Databases
Database Concepts
Features and Terminology
Planning and Designing a Database
Introduction to Access
Access Environment
Access Components: Tables, Queries, Forms, 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
Modify 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
The Query Design Grid
Naming a Query for Future Use and Modifying a Query
Complex Queries
Creating a Complex Query
Using Arithmetic Operators
Using Logical Operators
Queries with Multiple Criteria
Sorting the Query Dynaset
Hiding Fields in a Query
Other Queries
Parameter Query
Calculated Query
Totals Query
Access Forms
Automatic Forms
Form Wizard
Form Design
Modifying Forms
Adding Controls to Forms
Formatting Forms
Using Forms
Displaying Records through a Form
Adding Records through a Form
Finding Records through a Form
Access Reports
Automatic Reports
Report Wizard
Report Design
Grouping and Sorting Records on a Report
Calculations on a Report
Modifying Report Design
Formatting Reports
Printing Labels
Using the ‘Tell me what to do…’ Function
Course Summary and Review
Recap of Topics Covered
Question Time