Presentation of VBA
Interest of the VBA language
Design of a program
Principle of operation of a macro

Create a first macro (Sub)
Use the macro recorder
View the code of a recorded macro
Language syntax

Workshop: Practice with the macro recorder

What is an object?
The interest of objects in Office
Use the Object Explorer and Office Help

Access the cells (Range)
Access the sheets (Worksheet)
Access the workbooks (Workbook)
Access the software (Application)

Workshop: Perform operations on a workbook using Excel objects

Understand and use variables
Assign data types to variables (text, number, date, etc.)
Operators (arithmetic, comparison, logic, etc.)
Save a list of information with arrays
Create and use constants

Insert buttons in a sheet
Add shortcuts in the Office ribbon
Use event macros
Nest macros in others (Private / Public)

Presentation and interest of conditions
Conditions If
Tests Select Case
Nesting conditional tests

Workshop: Complete a table differently depending on several scenarios

Presentation and interest of loops
Perform a loop following a counter (For Next)
Adapt a loop to a condition (Do While)
Retrieve all the elements of a group (For Each)

Workshop: Creating a summary at the start of an Excel workbook

Presentation of forms
Add controls (text fields, drop-down lists, check boxes, etc.)
Customize the graphical interface of a form
Define the actions to be performed

Workshop: Create a form to automatically fill in a table

Definition and syntax of a function
Predefined functions
Create a function
Use a function as a formula in Excel

Workshop: Create a conversion function

Integration of a personalized error management
Define your error message
Resume the execution of the macro once the errors have been handled

The object system in Word
The Document
object
The Paragraph object The Selection object

Workshop: Exporting data from Excel to Word

The object system in Outlook
The mailItem
object The contactItem object

Workshop: Retrieve data from an Excel workbook and send it automatically by email

The DoCmd
object The Form object

The ADO data access model
Getting started with SQL queries
Retrieving Access records in Excel (SELECT)
Editing information in Access using Excel (INSERT, UPDATE, DELETE)

Revisions on the VBA
Questions / Answers
Passing the TOSA certification