Developing Professional MS Access Solutions with VBA Three days programming course Language: English, Nederlands Get your information from an independent source

DESCRIPTION Access databases can be transformed into powerful, user friendly and safe applications. This training teaches you not just the syntax of VBA for Access, but how to implement the language to get results. We emphasize the development of solutions can be easily modified to fit any database. The real object even more ambitious: how to program Access applications in a minimum of time

WHAT YOU WILL LEARN You will be able to structure the development process and to save development time by using practical development models and templates. You will switch from a form-by-form development to choosing from form templates and typical constructions. You will be able to code forms and reports with solid solutions You will be able to apply a set of final modifications that turn your database into a true application You will know best resources on the internet for free code, samples, articles and tools. You can get expert advise on your Access development questions

WHO SHOULD ATTEND Any intensive Access user that wants to develop applications. Anyone with Access development experience in search for templates and models that can be easily applied to various database applications. Anyone that wants to reduce development time in Access programming.

ASSUMED KNOWLEDGE You must have a good knowledge of the Access user interface.

OUTLINES

Session 1: General VBA

· Overview of the elements that make up VBA
· All about functions & procedures
· All about variables, arrays and constants
· All about looping and decision structures
· Operators
· Built-in functions
· Error handling

Session 2: The Access object model

· Overview of the Access object model (accross versions)
· Database programming: the DAO & ADO object models
· Referencing other libraries
· Code conventions

Session 3: Designing an Access application

· Steps in the creation of an Access application
· A model for structuring an Access application
· Time budgeting of application components
· Building a function and a code library

Session 4: Standard solutions for forms

· Typical form code
· Multi-user issues: Dealing with record locking
· A powerful solution for keyboard driven action
· What list boxes and combo boxes can do for you
· Conditional formatting
· Things you didn't know about form layout

Session 5: Useful code for reports

· Making a report modal
· Dynamically filtering reports
· Preventing the opening of empty reports
· Using code to modify your reports
· Applying line numbers

Session 6: The thousand uses of the DoCmd object

· Hands-on exploration of the capabilities provided by the DoCmd object: from saving records and sending mail to automating data import and export.

Session 7: The final touches

· Menu's & menu bars
· Protection of the database content
· Security

Session 8: Advanced topics

· A model for developing multi-language databases
· Form resizing to fit screen resolution
· Automation of other Office applications

Session 9: Internet resources for Access Development

· The best resources on the internet for free code, samples, articles and tools
· Getting answers to your questions on the internet

---

---

FDDI Institute
De Regenboog 11 - 2800 Mechelen - Europe
Tel 32 15 24 50 58 - Fax 32 15 25 10 50