MS ACCESS Programming
MS ACCESS End User
MS End User
Training Manuals
Back
 
There are 2 levels: MS Access for software developers and MS Access Programming for Power Users.

MS Access Programming for Software Developers

This course is intended for software developers who want to learn to develop in MS Access. They should already have working experience with another development environment, ex. VB, Delphi, C, Modula 2, ... Only a basic knowledge of MS Access is required.

Contents of the course: MS Access Programming for software developers

Pricing
Per day. For every participant a 'MicroSoft press' manual is included plus a copy of the slides of the trainer. For prices call 02/478.48.88.

Course planning
This course takes 2 or 3 days, in our trainingroom or at your location. Maximum 5 students can participate in a session.

Contents
- Short resume of macros
- Short resume of basic functions, conditions and loops
- Recordsets, detailed overview
- Detailed explanation of the use of SQL strings in MS Access
- Detailed overview of code behind forms and code behind reports
- 'Large' exercises and exercises on request
- Detailed overview of DAO
- MS Access Object Model
- ActiveX controls in MS Access
- ODBC and linking with MS SQL server
- Exchange of data with MS Excel
- Multi-user issues in MS Access
- Security in MS Access, if asked by the participants and if there is enough time
- Use of PowerBasic together with MS Access
- Subjects proposed by the participants

MS Access Programming for Power Users
This course is intended for people who have a good working experience with MS Access, and who to learn to automate MS Access. Good working experience in MS Access, but no programming experience is required.

Contents of the course: MS Access Programming for Power Users

Pricing
Per day. For every participant a 'Wrox Press' manual is included plus a copy of the slides of the trainer. For prices call 02/478.48.88.

Course planning
This course takes 2 or 3 days, in our trainingroom or at your location. Maximum 5 students can participate in a session.

Contents
- Resume of macros
- Overview of the module window
- Basic functions in VBA: Debug.Print, MsgBox, InputBox, ...
- Variables: Integer, String, ...
- Conditions and loops: If Then, Loop
- Recordsets
- Use of SQL strings
- Code behind forms and reports
- Automatic import of data from MS Excel
- Overview of DAO
- Idea of PowerBasic and MS Access
- Subjects proposed by the participant

Top