Access 2019/365 - Level 1

Inter-company training

Who is the training for?

All public

Duration

3,00 day(s)

Language(s) of service

EN FR

Prerequisites

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

Goals

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.

Contents

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

Mode of organisation

Classroom Courses

These courses might interest you

EN
Day
Computer science - Green IT - Systeme information - Architecture systeme information - Cloud Computing