ACCESS TRAINING COURSES WINSFORD
About Enable Technology Winsford Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The tutor delivering the course will be a Microsoft certified expert. 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.
Courses are instructor led and groups sizes small. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another way we could deliver the Access course is at a local training site. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Carillion PLC, Countrywide Homes Limited, Keele University, Norfolk Police Constabulary, Wolverhampton City Council, Halfords Group PLC, West Bromwich Building Society and Cadbury PLC.
Microsoft Access
- 2 day course
- Location: Winsford
- 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 ... Sorting and Filtering
- See Training Course Details...
Database Wellness
Creating Queries
Formatting Tables
Querying Techniques
Parameter Queries
Setting Table Relationships
Data Validation
Understanding VBA
Multi Table Queries
Creating and Using Forms
Using a Navigation Form
Navigation Pane Protection
Calculations in Queries
Getting to Know Access
Macros on Forms
Creating and Using Reports
Adding Records to a Table
Importing and Exporting Records
Adding Transactional Records
Aggregation Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Winsford
- 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 ... Determining the Value of Expressions
- See Training Course Details...
Declaring and Creating Object Variables
Using Input Boxes
Using the CacheSize Property - Optional
Understanding VBA's Error Trapping Options
Working with Boolean Expressions
Handling Errors
Creating a Sub Procedure
Working with Events
Calling Procedures
Naming Procedures
Using the For Each...Next Structure
Navigating the Access Object Hierarchy
Trapping Errors with the On Error Statement
Considering Variable Scope and Lifetime Together
Working with Variable Lifetime
Understanding the Form Object
Setting Breakpoints
Using the With Statement
Email us about this courses
Other Winsford Enable Technology Training Courses
Excel 365 Advanced - Winsford Excel Training Courses
Excel 365 Intermediate - Winsford Excel Training Courses
JQuery - Winsford JavaScript Training Courses
TSQL Winsford Training Courses
Oracle SQL Winsford Training Courses
SSAS Winsford Training Courses