ACCESS TRAINING COURSES RUNCORN
About Enable Technology Runcorn Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and Access course resources that can be referenced post training. 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a course at a local venue in Runcorn. We are happy to modify the Access syllabus to match your teams training requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: University of Birmingham, Carillion PLC, GKN PLC, Wolverhampton City Council, Total Telecommunications Limited, South Staffordshire Water PLC, Dollond & Aitchison Limited and Norwich Union PLC.
Microsoft Access
- 2 day course
- Location: Runcorn
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Creating and Using Macros
- See Training Course Details...
Calculations in Queries
Creating Queries
Action Queries
Parameter Queries
Creating and Using Reports
Database Wellness
Multi Table Queries
Adding Records to a Table
Creating a Relational Database
Modifying Forms
Understanding VBA
Data Validation
Aggregation Queries
Querying Techniques
Getting to Know Access
Setting Table Relationships
Macro Techniques
Working With Records
Sorting and Filtering
Adding Transactional Records
Microsoft Access Programming Using VBA
- 3 day course
- Location: Runcorn
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Guidelines for use of Branching Structures
- See Training Course Details...
Understanding the Development Environment
Declaring and Creating Object Variables
Using the Immediate Window to Call Procedures
Controlling Program Execution
Working with Properties
Introduction to Programming in Access
Writing an Error-Handling Routine
Locking Records for Updating
Using Message Boxes
Debugging Code
Understanding Expressions and Statements
Working with Procedures and Functions
Understanding the Order of Events
Using the Do...Loop Structure
Using Expressions, Variables, and Intrinsic Functions
Setting Breakpoints
Working with Methods
Understanding the DoCmd Object
Email us about this courses
Other Runcorn Enable Technology Training Courses
Power BI - Runcorn Microsoft Power BI Training Courses
Excel 365 Intermediate Runcorn Training Courses
JavaScript - Runcorn JavaScript Training Courses
TSQL - Runcorn SQL Training Courses
DAX Runcorn Training Courses
Oracle SQL Runcorn Training Courses