ACCESS TRAINING COURSES DUDLEY
About Enable Technology Dudley Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Courses are instructor led and groups sizes small. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Another option is we can organise a local training site in Dudley. We are happy to modify the Access syllabus to match your teams training requirements.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Carillion PLC, Unipart Group, Birmingham Heartlands Hospital, Loughborough University, Vodafone Group Services, Aston University, GKN PLC and Norwich Union PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Dudley
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Using Intrinsic Functions
- See Training Course Details...
Using the With Statement
Working with Events
Trapping Errors with the On Error Statement
Guidelines for use of Branching Structures
Writing an Error-Handling Routine
Specifying a Recordset Cursor Location - Optional
Understanding Control-of-Flow Structures
Creating a Function Procedure
Working with Variable Scope
Using the For Each...Next Structure
Working with the ADODB Recordset Object
Using Debugging Tools
Controlling Program Execution
Stepping through Code
Setting Break Expressions
Using Intrinsic Constants
Creating a Standard Module
Navigating the Access Object Hierarchy
Using Visual Basic Help
Microsoft Access
- 2 day course
- Location: Dudley
- 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 ... Database Security
- See Training Course Details...
Working With Records
Adding Records to a Table
Using a Navigation Form
Creating a Relational Database
An Introduction to VBA
Creating a Lookup Database
Macros on Forms
Designing a Lookup Database
Creating and Using Macros
Multi Table Queries
DIY Forms
Understanding VBA
Modifying Forms
Creating and Using Reports
Creating and Using Forms
Navigation Pane Protection
Sorting and Filtering
Macro Techniques
Action Queries
Formatting Tables
Email us about this courses
Other Dudley Enable Technology Training Courses
SQL Dudley Training Courses
JQuery - Dudley JavaScript Training Courses
JavaScript - Dudley JavaScript Training Courses
Excel 365 Advanced - Dudley Excel Training Courses
DAX - Dudley Excel Training Courses
Excel 365 Basic - Dudley Excel Training Courses