Access - welcome - lifelong-learning.lu

Who is the training for?

Avez-vous déjà pensé à mettre en place un système d' enregistrement des produits, des clients, de gestion des stocks, entre autres?

Et que diriez-vous de contrôler les données que vous utilisez dans votre travail, comme les contacts clients et les délais de facturation?

Level reached

Beginner

Duration

20,00 hours(s)

20 heures

Language(s) of service

EN PT

Next session

Price

70.00€

Goals

Access is a data management application that combines tools for selecting and organizing data in tables. Once organized, data can easily be viewed in various queries and reports, whether on a computer screen or printed on paper.

With its ease of storing and retrieving data and its ability to automate everyday tasks, Access has become a powerful computing tool.

The main topics of the Access course are:

Access Office

What is Microsoft Access?
Desktop button operation;
How to open a new database;
Ribbon;
Manipulation of database objects;
Navigation panel.

Creating and configuring tables and relationships

Insertion of new fields in tables;
OLE object
Spreadsheet storage;
Documents and images in the database;
Primary key;
Field properties and data types;
Creation of fields to store photos and dates;
Data entry mask;
Combined box;
Query construction grid;
Purpose of a consultation;
SQL statement (language system for query programming);
Referential integrity;
Propagation of updates to relational fields;
Relationship via primary keys.

Queries

Selecting and deleting relationships between tables;
Database Tools tab;
Propagate updates to associated fields;
Extract information from different tables;
Queries to perform calculations, combine data, modify, add or delete data from the table;
Queries to provide data for reports or forms;
Identifying errors in table structure.

Shapes

Control menu;
Modifying tables using forms;
Form creation;
Form styles;
Insert photos and recordings into forms.

Reports

Creation of reports;
Classification, organization and layout of the report;
Search Criteria.

Macro

Macro operation;
Create and insert a macro;
Link macro;
Customization of the control menu;
Creation of buttons for the control menu.

Points covered

Dans le cours Access, vous apprendrez à:

Créer et relier des tableaux;
Produire des requêtes et des rapports;
Ajustez et personnalisez les rapports pour l’impression.
Pendant le cours, nous lancerons notre propre système d'enregistrement des produits et de contrôle des stocks, que vous pourrez reproduire sur votre ordinateur, étape par étape.

Le cours Access 2007 se déroule entièrement en ligne et comporte une série d' exemples, en plus du soutien d'un tuteur qui enseigne tout à travers des cours vidéo interactifs avec narration.