ACCESS TRAINING COURSES NATIONAL
About Enable Technology National Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All Enable Technology tutors are Microsoft certified experts. Each course participant will be issued with training Access resources which they can continue to use after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can bring the equipment necessary to deliver Access courses at your site. Another way we could deliver the Access course is at a local training site. All Access courses can be customised to meet your particular 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.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Unipart Group, Loughborough University, Halfords Group PLC, Nuclear Engineering Services, Wolverhampton City Council, Boots UK Limited, Yell Group PLC and Carillion PLC.
Microsoft Access
- 2 day course
- Location: National
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Sorting and Filtering
- See Training Course Details...
Parameter Queries
Using a Navigation Form
Navigation Pane Protection
Importing and Exporting Records
Setting Table Relationships
Formatting Tables
Macros on Forms
Creating and Using Macros
Data Validation
Calculations in Queries
Adding Records to a Table
Creating and Using Reports
Creating and Using Forms
Macro Techniques
Database Wellness
Adding Transactional Records
Action Queries
Aggregation Queries
Database Security
An Introduction to VBA
Microsoft Access Programming Using VBA
- 3 day course
- Location: National
- 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 Debugging Tools
- See Training Course Details...
Trapping Errors with the On Error Statement
Using the If...End If Decision Structures
Controlling Program Execution
Working with Variable Scope
Understanding the Development Environment
Using Message Boxes
Writing an Error-Handling Routine
Understanding Collections
Declaring and Creating Object Variables
Calling Procedures
Guidelines for use of Branching Structures
Understanding Control-of-Flow Structures
Understanding Error Handling
Understanding Classes and Objects
Debugging Code
Understanding the Form Object
Using Intrinsic Constants
Using the For Each...Next Structure
Working with Inline Error Handling
Email us about this courses
Other National Enable Technology Training Courses
TSQL - National SQL Training Courses
VBA National Training Courses
Oracle SQL National Training Courses
Excel Power Pivot - National Excel Training Courses
SQL - National SQL Training Courses
SSAS Tabular National Training Courses