ACCESS TRAINING COURSES TROWBRIDGE
About Enable Technology Trowbridge Access Training Courses
We are a company that provides short intensive Access training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. We will issue each Access training participant with learning resources which they can refer to post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Another option is we can organise a local training site in Trowbridge. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Wolverhampton City Council, Countrywide Homes Limited, Birmingham City Council, Dollond & Aitchison Limited, Unipart Group, Yell Group PLC, Homeserve PLC and Total Telecommunications Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Trowbridge
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Introduction to Programming in Access
- See Training Course Details...
Setting Breakpoints
Using Debugging Tools
Understanding Expressions and Statements
Using Visual Basic Help
Trapping Errors with the On Error Statement
Controlling Program Execution
Using Break Mode during Run Mode
Understanding Data Types
Working with the Code Editor
Guidelines for use of Branching Structures
Working with Properties
Using the For...Next Structure
Using the Immediate Window to Call Procedures
Using the With Statement
Specifying a Recordset Cursor Location - Optional
Using the Object Browser
Considering Variable Scope and Lifetime Together
Understanding the DoCmd Object
Microsoft Access
- 2 day course
- Location: Trowbridge
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Using a Navigation Form
- See Training Course Details...
Sorting and Filtering
DIY Forms
Aggregation Queries
Creating a Relational Database
Formatting Tables
Importing and Exporting Records
Macro Techniques
Getting to Know Access
Creating a Lookup Database
Adding Transactional Records
Macros on Forms
Database Wellness
Working With Records
Database Security
Setting Table Relationships
Parameter Queries
Navigation Pane Protection
Understanding VBA
Creating Queries
An Introduction to VBA
Email us about this courses
Other Trowbridge Enable Technology Training Courses
Power BI Trowbridge Training Courses
Excel Power Pivot Trowbridge Training Courses
Excel 365 Basic Trowbridge Training Courses
VBA Trowbridge Training Courses
JavaScript Trowbridge Training Courses
PL/SQL Trowbridge Training Courses