ACCESS TRAINING COURSES BARNSLEY
About Enable Technology Barnsley Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All course participants are issued Access training manuals they can refer to after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We can bring the equipment necessary to deliver Access courses at your site. If delivery onsite is an issue we will organise a venue near you in Barnsley. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Birmingham Heartlands Hospital, Unipart Group, DHL Express, Lloyds TSB Bank PLC, Shell UK Oil Products Ltd, GKN PLC, Barclays Bank PLC and Fujistu PLC.
Microsoft Access
- 2 day course
- Location: Barnsley
- 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 ... Action Queries
- See Training Course Details...
Modifying Forms
Understanding VBA
Setting Table Relationships
Modifying Table Structures
Querying Techniques
Adding Records to a Table
Creating Queries
Creating and Using Reports
Creating a Lookup Database
Aggregation Queries
Parameter Queries
Adding Transactional Records
Working With Records
Importing and Exporting Records
Creating and Using Macros
Database Wellness
Formatting Tables
Multi Table Queries
Relational Database Design
Macro Techniques
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 ... Navigating the Access Object Hierarchy
- See Training Course Details...
Declaring Variables
Working with Inline Error Handling
Using Input Boxes
Understanding Objects
Understanding Classes and Objects
Stepping through Code
Using the CacheSize Property - Optional
Working with Variable Lifetime
Understanding VBA's Error Trapping Options
Using Expressions, Variables, and Intrinsic Functions
Working with the Application Object
Using the Immediate Window to Call Procedures
Using Message Boxes
Using the For...Next Structure
Naming Procedures
Working with Variable Scope
Understanding Constants
Understanding the DoCmd Object
Email us about this courses
Other Barnsley Enable Technology Training Courses
SSIS - Barnsley SQL Server Integration Services Training Courses
Excel 365 Advanced - Barnsley Excel Training Courses
SSAS - Barnsley SQL Server Analysis Services Training Courses
DAX Barnsley Training Courses
SSAS Tabular Barnsley Training Courses
SQL Barnsley Training Courses