ACCESS TRAINING COURSES LEAMINGTON SPA
About Enable Technology Leamington Spa Access Training Courses
We are a company that provides short intensive Access training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. We will issue each Access training participant with learning resources which they can refer to post training. 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. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. We also offer the option of scheduling of Access course at a venue near you in Leamington Spa. The Access syllabus can be modified to accommodate your specific training needs.
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 Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Loughborough University, Keele University, Royal Air Force, Royal & Sun Alliance Group PLC, Barclays Bank PLC, Carillion PLC, Total Telecommunications Limited and Wolverhampton City Council.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Leamington Spa
- 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 the Select Case...End Select Structure
- See Training Course Details...
Creating a Standard Module
Working with the ADODB Recordset Object
Understanding Modules
Using the Do...Loop Structure
Understanding Data Types
Controlling Program Execution
Organizing Code and Procedures
Specifying a Recordset Cursor Location - Optional
Using the Immediate Window to Call Procedures
Setting Break Expressions
Using Message Boxes
Specifying a Recordset Cursor Type
Understanding Error Handling
Using the For Each...Next Structure
Considering Variable Scope and Lifetime Together
Using Debugging Tools
Understanding VBA's Error Trapping Options
Using Visual Basic Help
Microsoft Access
- 2 day course
- Location: Leamington Spa
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Creating and Using Forms
- See Training Course Details...
Creating a Relational Database
Sorting and Filtering
Creating a Lookup Database
Modifying Table Structures
Adding Records to a Table
Data Validation
Setting Table Relationships
Action Queries
Importing and Exporting Records
Creating and Using Reports
Creating and Using Macros
Macros on Forms
Understanding VBA
Using a Navigation Form
Navigation Pane Protection
Formatting Tables
Database Wellness
DIY Forms
Multi Table Queries
Aggregation Queries
Email us about this courses
Other Leamington Spa Enable Technology Training Courses
Power Query - Leamington Spa Excel Training Courses
Excel 365 Advanced - Leamington Spa Excel Training Courses
Power BI Leamington Spa Training Courses
Excel Power Pivot - Leamington Spa Excel Training Courses
JavaScript Leamington Spa Training Courses
Excel 365 Intermediate - Leamington Spa Excel Training Courses