ACCESS TRAINING COURSES NORTH EAST
About Enable Technology North East Access Training Courses
We are a company that provides short intensive Access training courses. The tutor delivering the course will be a Microsoft certified expert. Every person attending a Access course will be provided with training materials and practice files to retain after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. 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. Another way we could deliver the Access course is at a local socially distanced training site. The Access syllabus can be modified to accommodate your specific training needs.
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.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are EDF Energy PLC, Yell Group PLC, University of Birmingham, Vodafone Group Services, Lloyds TSB Bank PLC, Royal Air Force, Cadbury PLC and Boots UK Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: North East
- 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 ... Working with Events
- See Training Course Details...
Understanding the Development Environment
Using Visual Basic Help
Understanding the Err Object
Using Intrinsic Functions
Understanding the DoCmd Object
Working with the Code Editor
Declaring and Creating Object Variables
Creating a Function Procedure
Handling Errors
Determining the Value of Expressions
Specifying a Recordset Cursor Location - Optional
Considering Variable Scope and Lifetime Together
Working with Boolean Expressions
Creating a Standard Module
Naming Procedures
Understanding Recordset Cursor Properties - Optional
Understanding VBA's Error Trapping Options
Microsoft Access
- 2 day course
- Location: North East
- 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 ... Using a Navigation Form
- See Training Course Details...
Relational Database Design
Formatting Tables
Creating and Using Reports
Creating a Lookup Database
Macros on Forms
Modifying Forms
Macro Techniques
Setting Table Relationships
Multi Table Queries
Understanding VBA
An Introduction to VBA
Database Wellness
Modifying Table Structures
Data Validation
Calculations in Queries
Creating Queries
Action Queries
Navigation Pane Protection
Parameter Queries
Getting to Know Access
Email us about this courses
Other North East Enable Technology Training Courses
SSAS Tabular - North East SQL Server Analysis Services Training Courses
Power Query - North East Excel Training Courses
JavaScript North East Training Courses
SSAS - North East SQL Server Analysis Services Training Courses
Excel 365 Basic North East Training Courses
JQuery North East Training Courses