ACCESS TRAINING COURSES STAFFORD
About Enable Technology Stafford Access Training Courses
We have a twenty year history of providing skills based Access industry training. The training will be delivered by a Microsoft professional with development experience. Every course participant will receives course practice files and Access course resources that can be referenced post training. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. If delivery onsite is an issue we will organise a socially distanced venue near you in Stafford. We are happy to discuss customising the course content should you have particular Access training requirements.
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.
Our teaching team have over twenty years continuous technical training experience. Our clients include: National Power PLC, Barclays Bank PLC, Yell Group PLC, Dollond & Aitchison Limited, TalkTalk Direct Limited, Vodafone Group Services, Birmingham City University and West Bromwich Building Society.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Stafford
- 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 Intrinsic Functions
- See Training Course Details...
Using Break Mode during Run Mode
Using the If...End If Decision Structures
Using the Do...Loop Structure
Trapping Errors with the On Error Statement
Guidelines for use of Branching Structures
Debugging Code
Understanding Classes and Objects
Using Intrinsic Constants
Using the Select Case...End Select Structure
Working with Events
Understanding Expressions and Statements
Working with the Application Object
Working with Properties
Working with the ADODB Recordset Object
Calling Procedures
Microsoft Access
- 2 day course
- Location: Stafford
- 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 ... Adding Records to a Table
- See Training Course Details...
Sorting and Filtering
Database Wellness
Macros on Forms
Macro Techniques
Using a Navigation Form
Working With Records
Calculations in Queries
Aggregation Queries
Getting to Know Access
Creating and Using Reports
Creating a Relational Database
Creating a Lookup Database
Data Validation
Relational Database Design
Designing a Lookup Database
Formatting Tables
Querying Techniques
Parameter Queries
Understanding VBA
Navigation Pane Protection
Email us about this courses
Other Stafford Enable Technology Training Courses
Oracle SQL - Stafford SQL Training Courses
SSAS Tabular - Stafford SQL Server Analysis Services Training Courses
DAX Stafford Training Courses
SSIS Stafford Training Courses
TSQL Stafford Training Courses
JQuery Mobile Stafford Training Courses