ACCESS TRAINING COURSES PENARTH
About Enable Technology Penarth Access Training Courses
Enable Technology provides practical Access skills based technology training. The tutor delivering the course will be a Microsoft certified expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can set up a training lab at your premises and deliver Access courses onsite at your site. Another option is we can organise a local socially distanced training site in Penarth. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Norfolk Police Constabulary, Birmingham Heartlands Hospital, EDF Energy PLC, Unipart Group, University of Birmingham, Birmingham City Council, Nationwide Building Society Limited and Royal & Sun Alliance Group PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Penarth
- 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 Intrinsic Functions
- See Training Course Details...
Understanding Errors
Creating a Function Procedure
Using the Immediate Window to Call Procedures
Considering Variable Scope and Lifetime Together
Working with the Code Editor
Using Expressions, Variables, and Intrinsic Functions
Working with Events
Using Break Mode during Run Mode
Working with the ADODB Recordset Object
Using the Object Browser
Using Message Boxes
Working with Procedures and Functions
Setting Breakpoints
Setting Break Expressions
Creating a Standard Module
Understanding Data Types
Understanding Error Handling
Specifying a Recordset Cursor Type
Navigating the Access Object Hierarchy
Microsoft Access
- 2 day course
- Location: Penarth
- 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 ... Macro Techniques
- See Training Course Details...
Working With Records
Creating and Using Forms
Getting to Know Access
An Introduction to VBA
Creating Queries
Calculations in Queries
Creating a Relational Database
Designing a Lookup Database
Setting Table Relationships
Macros on Forms
Understanding VBA
Multi Table Queries
Formatting Tables
Database Security
Adding Transactional Records
DIY Forms
Data Validation
Querying Techniques
Creating and Using Macros
Modifying Table Structures
Email us about this courses
Other Penarth Enable Technology Training Courses
Excel 365 Advanced - Penarth Excel Training Courses
SSRS - Penarth SQL Server Reporting Services Training Courses
SSIS Penarth Training Courses
PL/SQL Penarth Training Courses
SSAS Penarth Training Courses
TSQL - Penarth SQL Training Courses