Advanced programming techniques in Microsoft Access
249ر.س
Product description
If you want to transition from using databases to mastering Microsoft Access programming, this advanced course provides you with a strong foundation in macros and VBA within Microsoft Access. The program focuses on advanced programming techniques, including creating AutoExec and AutoKeys macros, understanding VBA considerations, attaching functions to events, and managing databases professionally and securely. It also covers handling dates, designing keyboard shortcuts, and dynamically filtering records. This course is suitable for those who want to develop professional Access applications based on automation and programming.
Objectives of the Microsoft Access Programming Course
By the end of the program, the trainee will be able to:
Understand the concept of programming within Access
Differentiate between using macros and VBA instructions
Create and run AutoExec macros automatically
Attach VBA functions to event properties
Properly handle dates within Access
Create AutoKeys macros and build keyboard shortcuts
Identify and manage trusted locations for databases
Course Topics
Unit One: Creating AutoExec Macro in Desktop Database
What is programming?
Difference between macro and VBA
Considerations for using macros
Creating AutoExec macro
Creating a macro on application startup in Access
Unit Two: VBA Considerations
VBA macro definitions
Macro features in Access
VBA considerations and best practices
Using the "Command Button Wizard" to perform common programming tasks
Unit Three: VBA Code
Basics of writing VBA code
Understanding macro modules and conversions
Converting general macro modules
Attaching VBA functions to event properties
Creating a macro that runs when opening the database
Creating AutoExec macro
Unit Four: Programming with VBA
Writing codes inside Access
Proper handling of dates
Dynamically filtering records during writing
Improving form performance using programming
Unit Five: Creating AutoKeys Macro using Sub-Macro
Creating AutoKeys macro
Building syntax for keyboard shortcuts
Factors that determine trust in the database
Moving the database to a trusted location
Managing trusted locations within Access
Course Features
Advanced practical training in Access programming
Real-world VBA applications
Professional explanation of macros, AutoExec, and AutoKeys
Developing professional database applications
Practical qualification for the job market in database development
Training Package Contents
PowerPoint (123 slides)
Trainer’s guide (100 pages)
Trainee’s guide (89 pages)
Training activities (10)
Educational videos (10)
Illustrative images (10)
Mind maps
Introductory brochure
Pre- and post-assessment tests
Evaluation forms
Scientific references
Package code: COMSO67525024
Course Duration
5 training days
25 training hours
Target Audience
Those wishing to master Microsoft Access programming
Beginner database developers
Information systems managers
Anyone with basic knowledge of Access who wants to advance to an expert level
Training Package Sample
Please click here to view the training package sample
Questions you might have

