Courses / Access Automation with Macros
Access Automation with Macros
- Provider
- Desktop Training & Development Ltd
- Summary
- 1 day course aimed at experienced users of Microsoft Access, held in Ipswich.
About the Course
- Target
- Delegates with reasonable experience of Access and who want to gain knowledge of Visual Basic for Applications.
- Entry requirements
- A thorough knowledge of Access is essential: however, no knowledge of Visual Basic for Applications is needed
- Outcome
- Content
- Introduction
- overview of Access VBA
- modules
- objects
- properties
- procedures
- events
Basics- adding a module
- creating a procedure
- running a procedure
- stepping through a procedure
User Defined Functions- overview
- creating
- using
Variables- data types
- local vs public
- manipulating strings
- symbolic constants
Control Structures- if…then
- select case
- for…next
- do…loop
- nesting controls
Dialog Boxes- message boxes
- using forms as custom dialog boxes
Handling Events- mouse events
- keyboard events
- data events
- focus events
- errors and timings
- default events
User Interface- 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
- linking with Word
A comprehensive course manual provides support throughout the course and upon your return to the office. - Cost
- Please contact Desktop Training for course fees.
- Enrolment
- Telephone, fax or write to Destktop.
Availability
- Starts
- Training dates are available on request
- Duration
- 1 day
- Timetable
- 9.30 am - 16.30 pm
- Provider
- Desktop Training & Development Ltd
Venues/Contact
Main (View map)
11 Beta Terrace
Masterlord Office Village
Ransomes Europark
Ipswich, Suffolk
IP3 9FE
UNITED KINGDOM
Telephone 0845 1188150
Email info@desktoptraining.co.uk
Website http://www.desktopcourses.co.uk
Venue Notes 0
Courses
Syndicate
