Olas Software Training and Development | Microsoft Access Introduction
00 353 1 2790020sales@olas.ie Olas: Professional, Direct, Clever & Helpful

Microsoft Access Introduction

 

Description

The objective of this Microsoft Access training course is to be able to plan, design, create, manipulate and query databases. Once completed you will be capable of using Microsoft Access to generate reports, understand terminology and produce input user forms.

Price €260 per person

Dates

  • Book a place on this course and pay with your credit card.21 April 2017 , 1 Day
  • Book a place on this course and pay with your credit card.10 July 2017 , 1 Day
  • Book a place on this course and pay with your credit card.10 October 2017 , 1 Day

TARGET AUDIENCE

Aimed at users who are new to Microsoft Access and want to set up their own databases or learn to manage an exiting database.

PREREQUISITES

None

GOALS AND OBJECTIVES

Course Outline
Click here to download course oultline

Introduction and Overview
Objectives
Programme Overview
Accessing Access
Explore the User Interface
Explore the Access 2013 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 & 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 & 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.