sql square

Goals


- Discover programming via VBA

- Use Access VBA objects

- Integrate SQL into macros

Program

Analyze the performance of the database or of a table
Split the database
Compact and repair the database
Encrypt its database with a password

The interest of macros
Principle of operation of a macro
Concept of event
Macros on command button
Start a macro when opening the database

Condition Notions
Error Handling
User Interface
Macros Data Macros

Objectives of the VBA language
Presentation of the VBA
Use of the VBA
Principle of operation of a macro

See and modify the code of a macro
Language syntax
Variables
Constants
Operators
Integrating a VBA function in an Access macro

The DoCmd
object The Form object

Operating principles
Condition structures (If, Select Case)
Multiple conditions (And / Or)
Presentation of loops
Looping according to a counter (For Next)
Looping according to a condition (Do Loop)

Discover the basics of SQL language
Retrieve the SQL code of an existing query

Integrate VBA objects from Excel
Use the ADO method
Transfer data to Excel
Retrieve data from Excel

Revisions on Access
Questions / Answers
Passing the PCIE certification

Passing of the certification (if foreseen in the financing)

Duration

2 days

Price

£ 980

Audience

Everyone

Prerequisites

Have followed the course "Access Training : Initiation" or have equivalent knowledge

Reference

BAS1142-F

Sessions

Contact us for more informations about session date