ACCESS TRAINING COURSES CARLISLE
About Enable Technology Carlisle Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Every course participant will receives course practice files and Access course resources that can be referenced post 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.
Courses are instructor led and groups sizes small. 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. We can also deliver the Access course at a socially distanced local training venue in Carlisle. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Aston University, Unipart Group, Boots UK Limited, Dollond & Aitchison Limited, Nuclear Engineering Services, Yell Group PLC, Royal Air Force and Birmingham City University.
Microsoft Access
- 2 day course
- Location: Carlisle
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Importing and Exporting Records
- See Training Course Details...
Parameter Queries
Setting Table Relationships
Calculations in Queries
Macro Techniques
Macros on Forms
An Introduction to VBA
Understanding VBA
Querying Techniques
Navigation Pane Protection
Creating a Lookup Database
Database Security
Modifying Forms
Adding Transactional Records
Creating Queries
Creating and Using Reports
Database Wellness
Data Validation
Action Queries
Using a Navigation Form
Sorting and Filtering
Microsoft Access Programming Using VBA
- 3 day course
- Location: Carlisle
- 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 ... Understanding the Form Object
- See Training Course Details...
Understanding VBA's Error Trapping Options
Handling Errors
Using Intrinsic Constants
Debugging Code
Using the If...End If Decision Structures
Understanding Recordset Cursor Properties - Optional
Specifying a Recordset Cursor Type
Using Message Boxes
Understanding Data Types
Guidelines for use of Branching Structures
Understanding Constants
Creating a Sub Procedure
Using the Object Browser
Understanding the DoCmd Object
Working with Events
Using the For...Next Structure
Using the Do...Loop Structure
Using Break Mode during Run Mode
Email us about this courses
Other Carlisle Enable Technology Training Courses
JQuery Mobile Carlisle Training Courses
Excel Power Pivot Carlisle Training Courses
VBA - Carlisle Excel Training Courses
Power BI - Carlisle Microsoft Power BI Training Courses
Data Warehouse Carlisle Training Courses
SSAS Tabular - Carlisle SQL Server Analysis Services Training Courses