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 + 3% VAT

Location

Classroom Course

Schedule

Guaranteed to run

Sessions in English
Contact us for more infoBook
Sessions in Dutch
10 - 12/1/2024Book
07 - 09/2/2024Book
06 - 08/3/2024Book
12 - 14/4/2024Book
15 - 17/5/2024Book
05 - 07/6/2024Book
03 - 05/7/2024Book
31 Jul & 01 - 02 AugBook
04 - 06/9/2024Book
02 - 04/10/2024Book
06 - 08/11/2024Book
11 - 13/12/2024Book
Sessions in French
17 - 19/1/2024Book
21 - 23/2/2024Book
13 - 15/3/2024Book
17 - 19/4/2024Book
13 - 15/5/2024Book
12 - 14/6/2024Book
10 - 12/7/2024Book
12 - 14/8/2024Book
11 - 13/9/2024Book
16 - 18/10/2024Book
12 - 14/11/2024Book
04 - 06/12/2024Book

Share this course on

Book your training

Enter your information to confirm your booking.

    Prerequisite test

    Looking for a tailor made solution?