ACCESS TRAINING COURSES HEXHAM
About Enable Technology Hexham 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. We provide every candidate with Access training materials which they keep after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Access courses are taught by a Microsoft Certified Solutions Expert. We can set up a training lab at your premises and deliver Access courses onsite at your site. The Access course could also be scheduled at a socially distanced site near you in Hexham. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
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.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Total Telecommunications Limited, Carillion PLC, Cadbury PLC, West Bromwich Building Society, Lloyds TSB Bank PLC, South Staffordshire Water PLC, Royal & Sun Alliance Group PLC and Royal Air Force.
Microsoft Access
- 2 day course
- Location: Hexham
- 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 ... Parameter Queries
- See Training Course Details...
Creating and Using Macros
Modifying Table Structures
Sorting and Filtering
Database Wellness
An Introduction to VBA
Creating and Using Reports
Calculations in Queries
Macro Techniques
Adding Records to a Table
Multi Table Queries
Creating and Using Forms
Designing a Lookup Database
Creating a Lookup Database
Adding Transactional Records
DIY Forms
Modifying Forms
Creating Queries
Macros on Forms
Formatting Tables
Relational Database Design
Microsoft Access Programming Using VBA
- 3 day course
- Location: Hexham
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Using Debugging Tools
- See Training Course Details...
Using the Do...Loop Structure
Working with Recordsets
Using the Object Browser
Using the With Statement
Handling Errors
Determining the Value of Expressions
Using Message Boxes
Understanding Error Handling
Understanding VBA's Error Trapping Options
Declaring Variables
Understanding the Form Object
Understanding Objects
Declaring and Creating Object Variables
Working with the Application Object
Creating a Function Procedure
Understanding Procedures
Working with Properties
Understanding Constants
Writing an Error-Handling Routine
Email us about this courses
Other Hexham Enable Technology Training Courses
JQuery Hexham Training Courses
JQuery Mobile Hexham Training Courses
SSRS - Hexham SQL Server Reporting Services Training Courses
SSAS Hexham Training Courses
Power BI Hexham Training Courses
SSAS Tabular Hexham Training Courses