ACCESS TRAINING COURSES SOUTH WEST
About Enable Technology South West Access Training Courses
We offer intensive two and three days Access courses. 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We also offer the option of scheduling of Access course at a socially distanced venue near you in the South West. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Unipart Group, Dollond & Aitchison Limited, Lloyds TSB Bank PLC, Aston University, University of Birmingham, Norfolk Police Constabulary, Loughborough University and Keele University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: South West
- 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 Procedures and Functions
- See Training Course Details...
Understanding the Development Environment
Using Message Boxes
Understanding Procedures
Introduction to Programming in Access
Using Visual Basic Help
Using the Object Browser
Using the For Each...Next Structure
Using Intrinsic Constants
Understanding Data Types
Using Intrinsic Functions
Declaring Variables
Understanding the Form Object
Understanding Constants
Considering Variable Scope and Lifetime Together
Understanding the DoCmd Object
Controlling Program Execution
Understanding Expressions and Statements
Using the For...Next Structure
Microsoft Access
- 2 day course
- Location: South West
- 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 ... Calculations in Queries
- See Training Course Details...
An Introduction to VBA
Working With Records
Sorting and Filtering
Importing and Exporting Records
Creating a Lookup Database
Macro Techniques
Database Security
Relational Database Design
Creating and Using Forms
Understanding VBA
Adding Transactional Records
Using a Navigation Form
Creating and Using Reports
Multi Table Queries
Designing a Lookup Database
Creating Queries
Modifying Forms
Database Wellness
Macros on Forms
Navigation Pane Protection
Email us about this courses
Other South West Enable Technology Training Courses
Power Query - South West Excel Training Courses
SSIS South West Training Courses
Report Builder South West Training Courses
SSAS - South West SQL Server Analysis Services Training Courses
VBA South West Training Courses
Oracle SQL - South West SQL Training Courses