ACCESS TRAINING COURSES BLACKWOOD
About Enable Technology Blackwood Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant is given Access courseware which they can refer to after the training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can deliver at your premises. We can provide the equipment. Another way we could deliver the Access course is at a local training site. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Loughborough University, Aston University, DHL Express, Carillion PLC, Cadbury PLC, EDF Energy PLC, Total Telecommunications Limited and TalkTalk Direct Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Blackwood
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Using the Do...Loop Structure
- See Training Course Details...
Setting Breakpoints
Working with the Code Editor
Understanding Classes and Objects
Creating a Standard Module
Organizing Code and Procedures
Understanding Objects
Using Intrinsic Functions
Using Expressions, Variables, and Intrinsic Functions
Understanding VBA's Error Trapping Options
Controlling Program Execution
Specifying a Recordset Cursor Type
Working with Events
Working with Variable Scope
Using the Object Browser
Using the Select Case...End Select Structure
Specifying a Recordset Cursor Location - Optional
Microsoft Access
- 2 day course
- Location: Blackwood
- 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 ... Macros on Forms
- See Training Course Details...
Data Validation
Setting Table Relationships
Action Queries
Creating a Lookup Database
Formatting Tables
Creating a Relational Database
Querying Techniques
Using a Navigation Form
Understanding VBA
Creating and Using Macros
Adding Records to a Table
Creating Queries
Importing and Exporting Records
Creating and Using Forms
Aggregation Queries
Working With Records
Modifying Table Structures
Getting to Know Access
Database Security
Relational Database Design
Email us about this courses
Other Blackwood Enable Technology Training Courses
Excel 365 Intermediate - Blackwood Excel Training Courses
Excel 365 Advanced Blackwood Training Courses
PL/SQL Blackwood Training Courses
SQL - Blackwood SQL Training Courses
VBA Blackwood Training Courses
JQuery - Blackwood JavaScript Training Courses