ACCESS TRAINING COURSES NORTH WEST
About Enable Technology North West Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All course participants are issued Access training manuals they can refer to after the course. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
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. If you prefer we can offer an offsite training location in the North West. Every Access course can be modified to meet your bespoke 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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Keele University, Barclays Bank PLC, National Power PLC, Nationwide Building Society Limited, Norfolk Police Constabulary, University of Birmingham, Boots UK Limited and Carillion PLC.
Microsoft Access
- 2 day course
- Location: North West
- 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 ... Creating Queries
- See Training Course Details...
Creating and Using Reports
Understanding VBA
Creating and Using Macros
Working With Records
Multi Table Queries
Formatting Tables
Creating and Using Forms
Adding Records to a Table
Creating a Relational Database
Setting Table Relationships
Querying Techniques
Navigation Pane Protection
Modifying Table Structures
Parameter Queries
Action Queries
Using a Navigation Form
Calculations in Queries
Macros on Forms
An Introduction to VBA
Database Wellness
Microsoft Access Programming Using VBA
- 3 day course
- Location: North West
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Using Debugging Tools
- See Training Course Details...
Locking Records for Updating
Writing an Error-Handling Routine
Working with Methods
Working with the ADODB Recordset Object
Understanding Constants
Controlling Program Execution
Organizing Code and Procedures
Using Break Mode during Run Mode
Using the CacheSize Property - Optional
Specifying a Recordset Cursor Location - Optional
Using Intrinsic Constants
Using the Do...Loop Structure
Trapping Errors with the On Error Statement
Using Intrinsic Functions
Using the For Each...Next Structure
Understanding Expressions and Statements
Working with Variable Scope
Understanding the Form Object
Creating a Sub Procedure
Email us about this courses
Other North West Enable Technology Training Courses
JavaScript North West Training Courses
Oracle SQL - North West SQL Training Courses
Power Query North West Training Courses
JQuery Mobile - North West JavaScript Training Courses
JQuery - North West JavaScript Training Courses
Excel Power Pivot - North West Excel Training Courses