IT Training

Access 2019/365 – Level 1

Most companies have a lot of data, from customer and employee records to product specification data and billing and scheduling systems. By learning the fundamentals of Microsoft Access, you can learn how to effectively store that data in a way that makes it easy to update, query and report on for a range of outputs. This is an intensive Access course that introduces participants to the concepts of creating relational databases using MS Access. Microsoft Access is a very powerful database application, designed to save you time and make creating relational databases easier.

Who should attend this course?

This course is aimed at people who are likely to use a database on a regular basis: representatives, sales staff, sales managers, advertisers, marketing, public relations, freelancers, personnel managers etc…

Prerequisites

Ability to manage files (save, save as, search…). Knowledge of Excel is a plus.

The course is structured around two days of theory and one day of practice during which you will learn the fundamentals of Microsoft’s relational database manager.

  • Introduction
  • Tables
  • Selection Queries
  • Relationships
  • Forms
  • Reports

Introduction

  • Understand what a relational database managing system is (differences between Excel & Access)
  • Understand the Access environment (goal, specific vocabulary…)
  • Know the purpose of the various objects (tables, queries, forms, reports)

Tables

  • Using data view
    • Viewing, adding, deleting and updating records
    • Searching, sorting and filtering
    • Table formatting
  • Creating tables
    • Understand design view
    • Know the various data types (basic and secondary types)
    • Master field properties

Selection queries

  • Understand the basic query concept
  • Master the query creation interface (selecting, moving fields, adding, removing a table)
    • Sorting query results
    • Hiding a field in a query result
    • Saving a query
    • Selecting record (filtering)
    • Using logical criteria AND / OR
    • Using operators such as « like », « ? », « * »
    • Using parameters « [] »
    • Other operators : « Null » « Not »
    • Creating calculated fields
    • Using the expression builder
    • Creating a calculated field using a formula
    • Learning how to use Access functions
    • Formatting a calculated field (format and caption)
    • Inserting a parameter in a calculation
    • Grouping
    • Using statistical functions (sum, average, min, max, count)
    • Other criteria : « Where »

Relationships

  • Understanding the necessity of relationships
  • Knowing the 3 types of relationships (1 to 1, 1 to many, many to many)
  • Understanding the concept of primary key and foreign key
  • Mastering referential integrity
  • Implementing a 1 to many relationship in Access
  • Creating selection queries that use several tables

Forms

  • Creating forms using the wizard
  • Using basic controls
  • Using conditional formatting

Reports

  • Creating reports using the wizard
  • Using basic controls
  • Using label creation wizard

Practical information

Duration

3 Days

Languages

FR / NL

Price

€1200,00 + 21% VAT

Location

Classroom Courses

Schedule

Guaranteed to run

Sessions in Dutch
11/1 - 13/1Book
01/2 - 03/2Book
08/3 - 10/3Book
19/4 - 21/4Book
03/5 - 05/5Book
31/5 - 02/6Book
05/7 - 07/7Book
02/8 - 04/8Book
06/9 - 08/9Book
04/10 - 06/10Book
08/11 - 10/11Book
29/11 - 01/12Book
Sessions in French
18/1 - 20/1Book
22/2 - 24/2Book
15/3 - 17/3Book
19/4 - 21/4Book
15/5 - 17/5Book
14/6 - 16/6Book
12/7 - 14/7Book
16/8 - 18/8Book
13/9 - 15/9Book
18/10 - 20/10Book
15/11 - 17/11Book
06/12 - 08/12Book

Share this course on

Book your training

Enter your information to confirm your booking.

    Prerequisite test

    Looking for a tailor made solution?