Training: Access – Fundamentals

Ref. MOA-01
Duration:
1
 day
Exam:
Not certifying
Level:
Fundamental

Description

This training is designed to introduce participants to the features of the latest version of Microsoft Access, a powerful program that enables users to store, track, and analyze large amounts of data for various applications.

Participant profiles

  • Anyone wanting to discover Microsoft Access

Objectives

  • How to use database knowledge to track and analyze information
  • How to create meaningful reports and share valuable information
  • How to export information as a web page

Prerequisites

  • Basic knowledge of Windows and Excel tables

Course content

Module 1: Office Workspace Basics

  • Basic Window Elements
  • Exploring Office Backstage
  • Working with the Ribbon
  • Customizing the Quick Access Toolbar
  • Working with KeyTips
  • Using the Status Bar
  • Getting Help

Module 2: Introduction to Access

  • What is an Access Database?
  • Opening a Database File
  • Exploring Database Objects
  • Creating a Database
  • Changing Views
  • Printing Database Objects
  • Saving and Closing a Database File

Module 3: Working with Tables

  • What is a Table
  • Working with Datasheets
  • Moving Among Records
  • Updating Records
  • Adding Records to a Table
  • Selecting Rows and Columns
  • Finding Records
  • Sorting Records
  • Filtering Records

Module 4: Designing Tables

  • Adding a Table to a Database
  • Adding Fields to a Table
  • Adding a Lookup Field
  • Setting a Primary Key
  • Using the Input Mask Wizard
  • Saving Design Changes
  • Importing Data
  • Exporting Data
  • Performing Database Maintenance

Module 5: Creating and Running Queries

  • What is a Query?
  • Creating a Query
  • Working with Queries
  • Saving and Running a Query
  • Creating Calculated Fields
  • Using Aggregate Functions
  • Understanding Query Properties
  • Creating Multi-Table Select Queries
  • Joining Tables
  • Enforcing Referential Integrity

Module 6: Using Forms

  • What is a Form?
  • Using the Form Tool
  • Creating a Form with the Form Wizard
  • Working in Design View
  • Changing the Form Layout
  • Using Calculated Controls
  • Working with Records on a Form

Module 7: Generating Reports

  • What is a Report?
  • What is a Report Tool?
  • Previewing and Printing a Report
  • Saving a Report
  • Designing a Report
  • Changing a Report Layout
  • Understanding Controls
  • Using a Calculated Control
  • Analyzing Dependencies
  • Creating Mailing Label

Documentation

  • Digital course material included

Lab / Exercises

  • Practice exercises will be given at the end of each module

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.

Additional information

Prix de l'inscription
CHF 700.-
Inclus dans ce cours
  • Training provided by an expert trainer
  • Documentation in digital format
  • Achievement Badge

ven22Mar09:00ven17:00VirtuelVirtual Etiquettes de sessionMOA-01

ven22Mar09:00ven17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOA-01

ven26Avr09:00ven17:00VirtuelVirtual Etiquettes de sessionMOA-01

ven26Avr09:00ven17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOA-01

ven31Mai09:00ven17:00VirtuelVirtual Etiquettes de sessionMOA-01

ven31Mai09:00ven17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOA-01

ven05juil09:00ven17:00VirtuelVirtual Etiquettes de sessionMOA-01

ven05juil09:00ven17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOA-01

ven09Aoû09:00ven17:00VirtuelVirtual Etiquettes de sessionMOA-01

ven09Aoû09:00ven17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOA-01

ven13Sep09:00ven17:00VirtuelVirtual Etiquettes de sessionMOA-01

ven13Sep09:00ven17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOA-01

ven18Oct09:00ven17:00VirtuelVirtual Etiquettes de sessionMOA-01

ven18Oct09:00ven17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOA-01

ven22Nov09:00ven17:00VirtuelVirtual Etiquettes de sessionMOA-01

ven22Nov09:00ven17:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOA-01

ven27Déc09:00ven17:00VirtuelVirtual Etiquettes de sessionMOA-01

ven27Déc09:00ven17:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOA-01

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.

Contactez-nous

Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request

X
X
X
X