ACCESS TRAINING COURSES BATLEY
About Enable Technology Batley Access Training Courses
Enable Technology provides practical Access skills based technology training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every course participant will receives course practice files and Access course resources that can be referenced post training. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
Enable Technology offers instructor led training taught by technology specialists. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Another way we could deliver the Access course is at a local training site. All Access courses can be customised to meet your particular requirements.
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 had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Homeserve PLC, Nuclear Engineering Services, Birmingham Heartlands Hospital, EDF Energy PLC, Loughborough University, Carillion PLC, Capita Group PLC and Birmingham City University.
Microsoft Access
- 2 day course
- Location: Batley
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Macro Techniques
- See Training Course Details...
Adding Transactional Records
Creating and Using Macros
Modifying Forms
Parameter Queries
Creating and Using Forms
Sorting and Filtering
Multi Table Queries
Data Validation
Creating a Relational Database
Creating a Lookup Database
Aggregation Queries
Relational Database Design
Database Wellness
Creating and Using Reports
Understanding VBA
DIY Forms
Calculations in Queries
Getting to Know Access
Action Queries
Navigation Pane Protection
Microsoft Access Programming Using VBA
- 3 day course
- Location: Batley
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Using the Immediate Window to Call Procedures
- See Training Course Details...
Introduction to Programming in Access
Writing an Error-Handling Routine
Understanding Collections
Using the For...Next Structure
Working with Inline Error Handling
Understanding Procedures
Understanding the DoCmd Object
Working with Events
Using Intrinsic Constants
Using the For Each...Next Structure
Using the Do...Loop Structure
Using Message Boxes
Declaring and Creating Object Variables
Creating a Sub Procedure
Locking Records for Updating
Working with Methods
Understanding Data Types
Naming Procedures
Email us about this courses
Other Batley Enable Technology Training Courses
Report Builder - Batley SQL Server Reporting Services Training Courses
SSAS Tabular - Batley SQL Server Analysis Services Training Courses
Excel 365 Intermediate - Batley Excel Training Courses
SSIS - Batley SQL Server Integration Services Training Courses
Oracle SQL - Batley SQL Training Courses
JQuery Batley Training Courses