Skills gained
Understand how Access is constructed and how to use the major objects within it
Discover THREE Major Data Problems That Access Completely Resolves
Learn the parts of the Access screen
Learn table, report and query objects
Master PROPERTIES to make thousands of choices manageable
Learn the basics of form objects
Fully understand tables, queries, reports and forms
Use automation in your forms with buttons and Macros
Create a multi page invoice
- Bureautique
- Bureautique Microsoft
Training Course Microsoft Access- English language version
Objectifs
Prérequis
General knowledge of working with Windows
You DO NOT need prior knowledge of Microsoft Access
Public
Anyone who is dissatisfied with how they are handling data now and know there must be a better way
Anyone who has attempted to learn Access before without success
Entrepreneurs, office workers, Anyone wanting to work with databases
Dernière mise à jour
Programme mis à jour le 20 janvier 2025
Bon à savoir
Evaluez votre niveau
Pour vous aider à bien choisir votre formation, nous vous proposons soit un entretien avec le formateur soit un test d’évaluation. Cela vous assurera que vous disposez des connaissances nécessaires pour suivre la formation dans des conditions optimales.
Sessions garanties
La majorité de nos sessions proposées en distanciel sont garanties. Elles peuvent être enregistrées à la demande.
Travaux pratiques
Nos formations comprennent de nombreux travaux pratiques pour un meilleur apprentissage (60 % de pratique). Nous proposons également de travailler sur vos données pour une meilleure expérience.
Les Modules
de formation
Module1
Introduction to Microsoft Access
• Overview of Microsoft Access
• Understanding Databases, Tables, and Relationships
• Exploring the Access Interface
Module2
Creating and Managing Databases
• Creating a New Database
• Opening, Saving, and Closing Databases
• Importing and Exporting Data
• Compacting and Repairing Databases
Module3
Working with Tables
• Designing Tables
• Adding and Editing Fields
• Field Data Types and Properties
• Primary Keys and Indexes
• Using Lookup Fields
Module4
Relationships and Referential Integrity
• Defining Relationships Between Tables
• Enforcing Referential Integrity
• Cascade Update and Delete Options
• Viewing and Modifying Relationships
Module5
Queries
• Introduction to Queries
• Designing Select Queries
• Using Criteria in Queries
• Calculated Fields in Queries
• Action Queries (Append, Update, Delete, and Make-Table)
Module6
Forms
• Creating and Customizing Forms
• Understanding Bound, Unbound, and Calculated Controls
• Using Subforms
• Form Design Best Practices
• Navigating Records Using Forms
Module7
Reports
• Designing and Generating Reports
• Grouping and Sorting Data in Reports
• Calculated Fields in Reports
• Using Subreports
• Printing and Exporting Reports
Module8
Macros and Automation
• Introduction to Macros
• Automating Tasks with Macros
• Conditional Logic in Macros
• Embedded Macros vs Standalone Macros
• Debugging and Troubleshooting Macros
Module9
Database Management and Security
• Splitting a Database for Multi-User Access
• Backing Up and Restoring Databases
• Setting User-Level Security
• Using the Trust Center
• Protecting Databases with Passwords
Les prochaines
sessions de formation
Sur demande
Vous souhaitez organiser cette formation à une date spécifique ?Contactez-nous en remplissant le formulaire ci-dessous
10 juin 2025
04 août 2025
29 septembre 2025
24 novembre 2025
