Access Training (Microsoft)

Access training program (advanced)

Woospeak, language and office training center since 2006 , offers you its expertise for your Microsoft Access office training . Our experienced trainers will help you improve and master Microsoft Access software.

Goal: Consolidate your skills on Microsoft Access software.
Develop ready-to-use applications using macro commands:
- Automate data entry and printing
- Practice SQL language
- Manage security and exchange data
Method: Face to face, telephone, videoconference, e-learning
Prerequisites: I often use Microsoft Access and I know the advanced features.
Public: Anyone with knowledge of Microsoft Access software and wishing to develop applications with macro commands.
Duration: 2, 4, 6, 8, 10 hours ... adjustable duration as needed
Possible certifications: TOSA, B2i, PCIE, ENI

The objectives of your Microsoft Access training

Our Microsoft Access training is one of our training courses in our office catalog. It will help you to master all the features of Microsoft software Access. This training will allow you among other things: to consolidate your skills on Microsoft Access software, to develop ready-to-use applications using macro-commands: to automate data entry and printing, to practice SQL language and to manage security and exchange data.
Whatever your basic level, our tailor-made training programs are fully adapted to help you progress.

Your Microsoft Access training program (Advanced)

The content of the Microsoft Access training program is organized into 6 major areas, and will be adapted according to your objectives and your needs:


Module 1: Automation and personalization of the environment

  • Macros and macro groups
  • Database interface
  • Start-up form
  • Custom menus and toolbars
  • Macros in forms
  • Usual macros: search for a recording, creation and deletion
  • Input verification: duplicates, empty fields
  • Drop-down list boxes
  • Filters: selection and sorting
  • Option groups and check boxes.

Module 2: Data exchange with OLE

  • Import in different formats (excel, txt)
  • Export data
  • Direct mail with Word
  • Attach Access tables, Excel workbooks.

Module 3: The SQL Language

  • Programming environment
  • Notions of variables
  • Essential commands: Select, Insert, Update ...
  • Multi-table interrogation.
  • Communication structures (MsgBox, IntputBox)
  • Decision structures (If Then Else, Select Case)
  • Loop structures (For Next and For Each)

Module 4: Fundamentals of VBA Access Language

  • Variables, tests, loops, tables, procedures, functions, passing parameters, organization of modules.
  • Display of messages.
  • Development of a program.
  • Call of macros by the Docmd instruction.
  • Creation of SQL queries. Archiving of record modifications.
  • Creation of selection filters on a form.

Module 5: Using Properties

  • Creation of a secure data entry form: modification, creation, deletion of records
  • Viewing a photo in a form
  • Modify the properties of objects in reports

Module 6: Manipulating datasets

  • Data access modes (DAO, ADO)
  • Information on a database (tables, fields ...)
  • Create / Modify / Delete objects from a database
  • Manipulate record sets
  • Adding, deleting, modifying records
  • Primary index
  • Sorting, filtering, selection criteria, SQL queries
  • Optimizing action and selection requests

Practical work & learning control

If you wish, we can also offer you an office certification such as TOSA. This Microsoft Access training is eligible for the CPF (Personal Training Account) .


advanced Microsoft Access training program

Microsoft Access in video training, by phone or face to face

As a specialized training organization, Woospeak offers you different training methods:

This Microsoft Access training can take place at home or within your company.

DISCOVER ALL OURTRAINING METHODS

We organize training sessions wherever you are and everywhere in France

Want to know more ? Please do not hesitate to contact us with any questions.
You can also ask us for a quote on your Microsoft Access training .