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

Microsoft Access Intermediate

 

Description

The objective of this Microsoft Access training course is to acquire a more in-depth knowledge of Access, including relational databases, complex queries, macros, switchboards and integration with other MS Office applications.

Price €280 per person

Dates

  • Book a place on this course and pay with your credit card.17 August 2017 , 1 Day
  • Book a place on this course and pay with your credit card.24 August 2017 , 1 Day
  • Book a place on this course and pay with your credit card.24 August 2017 , 1 Day
  • Book a place on this course and pay with your credit card.05 December 2017 , 1 Day

TARGET AUDIENCE

Aimed at users who have a good working knowledge of Microsoft Access.

PREREQUISITES

None

GOALS AND OBJECTIVES

Course Outline
Click here to download course oultline

Introduction and Review
Objectives
Programme Overview
Database Concepts
Flat vs Relational Databases
Planning and Design
Explore the Ribbon

Advanced Table Design
Field Data Types
Field Properties
Creating Input Masks
Validating and Restricting Data
Setting the Primary Key

Relational Databases
Creating a Relational Model
Different Types of Links
Key Fields and Indexes
Creating One-To-Many Relationships
Referential Integrity

Access Queries
Review Creating Basic Queries
Applying a Query to a Database

Complex Queries
Queries with Multiple Criteria
Sorting the Query Dynaset
Hiding Fields in a Query
Calculated Query
Total Query

Action Queries
Append Query
Make Table Query
Update Query
Delete Query

Other Queries
Creating Queries on Multiple Tables
Parameter Query
Parameter Query with Wildcards
Duplicate/Unmatched Queries

Access Forms
Review Creating Basic Forms
Layout View and Design View
Field Display Types
List Boxes & Combo Boxes
Option Groups
Calculated Controls
Using Expression Builder
Adding a Command Button
Creating Custom Help
Main/Sub Forms
Tabbed Forms

Access Reports
Review Creating Basic Reports
Modifying Controls in a Report
Grouping and Sorting Records in a Report
Calculations in Reports
Reports on Multiple Tables and Queries
Creating a Main/Sub Report

Access Templates
Asset tracking
Contacts
Event management
Students
Task Management

Integration with Office Applications
Importing & Exporting Data
Hyperlink Fields
Publish & Merge in Word
Analyse in Excel

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.