00 353 1 2790020sales@olas.ie Olas: Professional, Direct, Clever & Helpful

Microsoft Access Introduction

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.

Price: €325 per person

Dates

  • Book a place on this course and pay with your credit card.11 September 2019 , 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
Course Outline
Click here to download course oultline

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

Contact Us

Drop us a line, include your contact details and we will get back to you as soon as possible.