ACCESS TRAINING COURSES COVENTRY
About Enable Technology Coventry Access Training Courses
Enable Technology provides practical Access skills based technology training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every course participant will receives course practice files and Access course resources that can be referenced post training. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can deliver at your premises. We can provide the equipment. If delivery onsite is an issue we will organise a socially distanced venue near you in Coventry. We are happy to discuss customising the course content should you have particular Access training requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are DHL Express, Nuclear Engineering Services, Nationwide Building Society Limited, Norfolk Police Constabulary, Birmingham City Council, Queen's Medical Centre Nottingham, University of Birmingham and Keele University.
Microsoft Access
- 2 day course
- Location: Coventry
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Aggregation Queries
- See Training Course Details...
Macros on Forms
Creating and Using Macros
Modifying Forms
Modifying Table Structures
Adding Records to a Table
Macro Techniques
Parameter Queries
Database Security
Setting Table Relationships
Action Queries
Creating a Lookup Database
Creating and Using Reports
Database Wellness
Understanding VBA
Querying Techniques
Adding Transactional Records
DIY Forms
Formatting Tables
Sorting and Filtering
Using a Navigation Form
Microsoft Access Programming Using VBA
- 3 day course
- Location: Coventry
- 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 With Statement
- See Training Course Details...
Determining the Value of Expressions
Working with Recordsets
Creating a Sub Procedure
Specifying a Recordset Cursor Location - Optional
Considering Variable Scope and Lifetime Together
Understanding Recordset Cursor Properties - Optional
Understanding Modules
Writing an Error-Handling Routine
Understanding the Order of Events
Using Visual Basic Help
Understanding Constants
Working with the ADODB Recordset Object
Naming Procedures
Using the For Each...Next Structure
Guidelines for use of Branching Structures
Understanding VBA's Error Trapping Options
Working with Inline Error Handling
Specifying a Recordset Cursor Type
Using Expressions, Variables, and Intrinsic Functions
Email us about this courses
Other Coventry Enable Technology Training Courses
Report Builder Coventry Training Courses
SSAS Tabular Coventry Training Courses
Data Warehouse - Coventry SQL Training Courses
SQL - Coventry SQL Training Courses
SSAS - Coventry SQL Server Analysis Services Training Courses
JQuery Coventry Training Courses