Since 1988, Blue Novation has designed and delivered exceptionally high standard training solutions to businesses in both the private and public sector. The quality of training we deliver is of paramount importance to us.
Our approach ensures that delegates enjoy their training whilst gaining the additional skills and knowledge to become more productive in the workplace.
Access VBA Introduction
This customised workshop is designed to give advanced users of Microsoft Access a solid grounding in the use of Microsoft Visual Basic to automate and enhance their Access applications.
modules • objects • properties • procedures • events
adding a module • creating/running a procedure • stepping through a procedure
User Defined Functions
creating functions • using functions
data types • local vs public • manipulating strings • symbolic constants
if…then • select case • for…next • do…loop • nesting controls
message boxes • using forms as custom dialog boxes
mouse events • keyboard events • data events • focus events • errors and timings • default events
creating a main form • creating navigation forms • customising menus • customising toolbars
Testing & Debugging
the immediate window • setting break points • running selected portions of code • using the calls dialog box
Communicating with Other Applications
linking with Excel and Word
Customised Workshop (1 or 2 days)
A thorough knowledge of Access is essential: however, no knowledge of Visual Basic for Applications is needed.
Private course · tailored · 1 to 1 (instructor led)
Not found the course you are looking for?