ACCESS TRAINING COURSES WARWICK
About Enable Technology Warwick Access Training Courses
We offer intensive two and three days Access courses. All Enable Technology tutors are Microsoft certified experts. Every person attending a Access course will be provided with training materials and practice files to retain after the course. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. We are also more than happy to organise a local course at a socially distanced training location in Warwick. Every Access course can be modified to meet your bespoke requirements.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are TalkTalk Direct Limited, Birmingham City University, Nationwide Building Society Limited, Birmingham City Council, Royal Air Force, Yell Group PLC, West Bromwich Building Society and Wolverhampton City Council.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Warwick
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Writing an Error-Handling Routine
- See Training Course Details...
Declaring Variables
Working with Procedures and Functions
Understanding Modules
Using the Select Case...End Select Structure
Using the For...Next Structure
Understanding Errors
Understanding the DoCmd Object
Locking Records for Updating
Working with Recordsets
Understanding the Order of Events
Stepping through Code
Understanding Data Types
Understanding the Err Object
Organizing Code and Procedures
Using the CacheSize Property - Optional
Declaring and Creating Object Variables
Setting Break Expressions
Microsoft Access
- 2 day course
- Location: Warwick
- 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 ... Database Wellness
- See Training Course Details...
Creating Queries
Calculations in Queries
Designing a Lookup Database
Setting Table Relationships
Sorting and Filtering
Importing and Exporting Records
Macro Techniques
Working With Records
Macros on Forms
Adding Transactional Records
Relational Database Design
Getting to Know Access
Adding Records to a Table
Multi Table Queries
Modifying Table Structures
Creating and Using Reports
Action Queries
Understanding VBA
Creating and Using Forms
Modifying Forms
Email us about this courses
Other Warwick Enable Technology Training Courses
Power Query - Warwick Excel Training Courses
Data Warehouse - Warwick SQL Training Courses
SSIS Warwick Training Courses
PL/SQL Warwick Training Courses
Excel Power Pivot - Warwick Excel Training Courses
JQuery Mobile - Warwick JavaScript Training Courses