ACCESS TRAINING COURSES ELLESMERE PORT
About Enable Technology Ellesmere Port Access Training Courses
Enable Technology specialise in succinct skills based Access training. The course will always be taught by a Microsoft Certified Professional (MCP). 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. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Alternatively we could schedule a course at a local socially distanced venue in Ellesmere Port. 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. Our clients include: Total Telecommunications Limited, South Staffordshire Water PLC, Cadbury PLC, Countrywide Homes Limited, DHL Express, Birmingham City Council, Royal & Sun Alliance Group PLC and Birmingham Heartlands Hospital.
Microsoft Access
- 2 day course
- Location: Ellesmere Port
- 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...
DIY Forms
Calculations in Queries
Formatting Tables
Designing a Lookup Database
Understanding VBA
Sorting and Filtering
Navigation Pane Protection
Setting Table Relationships
Macros on Forms
Using a Navigation Form
Macro Techniques
Getting to Know Access
Creating and Using Reports
Adding Records to a Table
Parameter Queries
Querying Techniques
Creating a Lookup Database
Multi Table Queries
Adding Transactional Records
Modifying Table Structures
Microsoft Access Programming Using VBA
- 3 day course
- Location: Ellesmere Port
- 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 ... Introduction to Programming in Access
- See Training Course Details...
Navigating the Access Object Hierarchy
Understanding Constants
Trapping Errors with the On Error Statement
Understanding Procedures
Using Expressions, Variables, and Intrinsic Functions
Working with the ADODB Recordset Object
Understanding Control-of-Flow Structures
Locking Records for Updating
Debugging Code
Understanding the Order of Events
Using Intrinsic Functions
Understanding Expressions and Statements
Understanding the Development Environment
Understanding Objects
Using the For Each...Next Structure
Using the CacheSize Property - Optional
Using the With Statement
Working with Events
Email us about this courses
Other Ellesmere Port Enable Technology Training Courses
Oracle SQL - Ellesmere Port SQL Training Courses
Excel 365 Basic Ellesmere Port Training Courses
Report Builder - Ellesmere Port SQL Server Reporting Services Training Courses
SSRS - Ellesmere Port SQL Server Reporting Services Training Courses
JQuery Mobile Ellesmere Port Training Courses
Power Query Ellesmere Port Training Courses