Goals
- Communication Excel / Access
- Introduce yourself to SQL languages and the ADO model
Program
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
Passing of the certification (if foreseen in the financing).
Duration
2 days
Price
£ 2495
Audience
All
Prerequisites
Have taken the VBA Initiation course or have equivalent knowledge
Reference
BUR403-F
Sessions
Contact us for more informations about session date