ACCESS TRAINING COURSES BARNSLEY
About Enable Technology Barnsley Access Training Courses
Enable Technology specialise in succinct skills based Access training. We guarantee the training will be delivered by a Microsoft certified expert. All course participants are issued Access training manuals they can refer to after the course. 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.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We also offer the option of scheduling of Access course at a venue near you in Barnsley. All Access courses can be customised to meet your particular 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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are National Power PLC, Shell UK Oil Products Ltd, Halfords Group PLC, Boots UK Limited, Unipart Group, DHL Express, Birmingham Heartlands Hospital and Loughborough University.
Microsoft Access
- 2 day course
- Location: Barnsley
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Navigation Pane Protection
- See Training Course Details...
Formatting Tables
Adding Records to a Table
Database Wellness
Adding Transactional Records
Action Queries
Sorting and Filtering
Parameter Queries
Modifying Forms
Working With Records
Modifying Table Structures
Creating and Using Forms
Macros on Forms
Creating and Using Reports
Creating a Lookup Database
Creating a Relational Database
Creating Queries
Designing a Lookup Database
Multi Table Queries
An Introduction to VBA
Aggregation Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Barnsley
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Using the If...End If Decision Structures
- See Training Course Details...
Writing an Error-Handling Routine
Using Break Mode during Run Mode
Using the CacheSize Property - Optional
Understanding the Form Object
Understanding the Err Object
Using the Do...Loop Structure
Using the With Statement
Debugging Code
Declaring and Creating Object Variables
Creating a Function Procedure
Creating a Standard Module
Guidelines for use of Branching Structures
Working with the Application Object
Understanding Constants
Handling Errors
Why Program in Access?
Understanding Expressions and Statements
Understanding the Order of Events
Using Expressions, Variables, and Intrinsic Functions
Email us about this courses
Other Barnsley Enable Technology Training Courses
Excel 365 Basic - Barnsley Excel Training Courses
SQL Barnsley Training Courses
Report Builder - Barnsley SQL Server Reporting Services Training Courses
SSIS Barnsley Training Courses
DAX Barnsley Training Courses
JQuery - Barnsley JavaScript Training Courses