ACCESS TRAINING COURSES BLACKWOOD
About Enable Technology Blackwood Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Every course participant is given Access courseware which they can refer to after the training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Access courses are taught by a Microsoft Certified Solutions Expert. We can set up a training lab at your premises and deliver Access courses onsite at your site. The Access course could also be scheduled at a socially distanced site near you in Blackwood. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.
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: Shell UK Oil Products Ltd, University of Birmingham, Norwich Union PLC, Dollond & Aitchison Limited, Countrywide Homes Limited, West Bromwich Building Society, Lloyds TSB Bank PLC and Birmingham City University.
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 ... Working with Methods
- See Training Course Details...
Understanding Expressions and Statements
Understanding Recordset Cursor Properties - Optional
Introduction to Programming in Access
Using Expressions, Variables, and Intrinsic Functions
Using Intrinsic Constants
Specifying a Recordset Cursor Type
Understanding Classes and Objects
Considering Variable Scope and Lifetime Together
Using the Object Browser
Working with Variable Scope
Using Intrinsic Functions
Organizing Code and Procedures
Working with Recordsets
Using the For...Next Structure
Using the With Statement
Working with Boolean Expressions
Working with the Application Object
Controlling Program Execution
Using Debugging Tools
Microsoft Access
- 2 day course
- Location: Blackwood
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Formatting Tables
- See Training Course Details...
Adding Transactional Records
An Introduction to VBA
Using a Navigation Form
Adding Records to a Table
Getting to Know Access
Modifying Table Structures
Modifying Forms
Macro Techniques
Designing a Lookup Database
Navigation Pane Protection
Aggregation Queries
Data Validation
Action Queries
Working With Records
Creating a Relational Database
Database Wellness
Calculations in Queries
Importing and Exporting Records
Creating a Lookup Database
Sorting and Filtering
Email us about this courses
Other Blackwood Enable Technology Training Courses
PL/SQL - Blackwood SQL Training Courses
SSIS Blackwood Training Courses
SSAS - Blackwood SQL Server Analysis Services Training Courses
Excel 365 Advanced - Blackwood Excel Training Courses
Excel 365 Basic - Blackwood Excel Training Courses
Excel Power Pivot Blackwood Training Courses