ACCESS TRAINING COURSES ECCLES
About Enable Technology Eccles Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We can also deliver the Access course at a socially distanced local training venue in Eccles. The Access syllabus can be modified to accommodate your specific training needs.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Shell UK Oil Products Ltd, Norfolk Police Constabulary, Carillion PLC, DHL Express, West Bromwich Building Society, Capita Group PLC, Royal & Sun Alliance Group PLC and Yell Group PLC.
Microsoft Access
- 2 day course
- Location: Eccles
- 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 ... Querying Techniques
- See Training Course Details...
Calculations in Queries
Multi Table Queries
Aggregation Queries
Database Security
Parameter Queries
Creating and Using Macros
Creating and Using Reports
Adding Records to a Table
Modifying Forms
Understanding VBA
Macro Techniques
Data Validation
Action Queries
An Introduction to VBA
Creating Queries
Adding Transactional Records
Creating a Relational Database
Formatting Tables
Working With Records
Relational Database Design
Microsoft Access Programming Using VBA
- 3 day course
- Location: Eccles
- Telephone on 01952 938014
- 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 ... Working with Events
- See Training Course Details...
Using Debugging Tools
Specifying a Recordset Cursor Type
Naming Procedures
Understanding Procedures
Declaring Variables
Determining the Value of Expressions
Considering Variable Scope and Lifetime Together
Creating a Standard Module
Calling Procedures
Working with Variable Lifetime
Using Break Mode during Run Mode
Using the For...Next Structure
Understanding Objects
Stepping through Code
Working with the ADODB Recordset Object
Setting Break Expressions
Using Intrinsic Constants
Email us about this courses
Other Eccles Enable Technology Training Courses
TSQL Eccles Training Courses
SQL - Eccles SQL Training Courses
JQuery Mobile - Eccles JavaScript Training Courses
Power BI Eccles Training Courses
VBA - Eccles Excel Training Courses
PL/SQL Eccles Training Courses