ACCESS TRAINING COURSES TEWKESBURY
About Enable Technology Tewkesbury Access Training Courses
Enable Technology provides practical Access skills based technology training. The course will always be taught by a Microsoft Certified Professional (MCP). All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. 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. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. We also offer the option of scheduling of Access course at a socially distanced venue near you in Tewkesbury. We are happy to modify the Access syllabus to match your teams training requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to 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. Our clients include: National Power PLC, Halfords Group PLC, South Staffordshire Water PLC, Total Telecommunications Limited, TalkTalk Direct Limited, Carillion PLC, Unipart Group and Countrywide Homes Limited.
Microsoft Access
- 2 day course
- Location: Tewkesbury
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... An Introduction to VBA
- See Training Course Details...
Database Wellness
Adding Records to a Table
Creating and Using Forms
Database Security
Navigation Pane Protection
Creating a Relational Database
Working With Records
Aggregation Queries
Importing and Exporting Records
Calculations in Queries
Modifying Forms
Macro Techniques
Creating and Using Macros
Designing a Lookup Database
Action Queries
Data Validation
Relational Database Design
Creating Queries
Parameter Queries
Querying Techniques
Microsoft Access Programming Using VBA
- 3 day course
- Location: Tewkesbury
- 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 ... Writing an Error-Handling Routine
- See Training Course Details...
Navigating the Access Object Hierarchy
Working with Methods
Understanding Collections
Naming Procedures
Declaring Variables
Working with the ADODB Recordset Object
Using the With Statement
Understanding the DoCmd Object
Working with Boolean Expressions
Understanding the Development Environment
Understanding Procedures
Working with Procedures and Functions
Creating a Sub Procedure
Understanding Recordset Cursor Properties - Optional
Handling Errors
Using the Select Case...End Select Structure
Understanding the Order of Events
Declaring and Creating Object Variables
Email us about this courses
Other Tewkesbury Enable Technology Training Courses
Power BI - Tewkesbury Microsoft Power BI Training Courses
SSIS Tewkesbury Training Courses
SSRS Tewkesbury Training Courses
Excel 365 Intermediate Tewkesbury Training Courses
PL/SQL - Tewkesbury SQL Training Courses
Data Warehouse Tewkesbury Training Courses