ACCESS TRAINING COURSES CIL-Y-COED
About Enable Technology Cil-y-coed Access Training Courses
Enable Technology offer short intensive skills based Access training courses. All Enable Technology tutors are Microsoft certified experts. Every course participant is given Access courseware which they can refer to after the training. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. 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 Cil-y-coed. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are South Staffordshire Water PLC, Aston University, Lloyds TSB Bank PLC, Countrywide Homes Limited, Dollond & Aitchison Limited, Queen's Medical Centre Nottingham, Nuclear Engineering Services and Barclays Bank PLC.
Microsoft Access
- 2 day course
- Location: Cil-y-coed
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Adding Records to a Table
- See Training Course Details...
Parameter Queries
Navigation Pane Protection
Modifying Table Structures
Designing a Lookup Database
Getting to Know Access
Sorting and Filtering
Creating and Using Reports
Setting Table Relationships
Adding Transactional Records
Querying Techniques
Creating Queries
Working With Records
Aggregation Queries
Creating a Lookup Database
Data Validation
Understanding VBA
Using a Navigation Form
Modifying Forms
Relational Database Design
Creating and Using Macros
Microsoft Access Programming Using VBA
- 3 day course
- Location: Cil-y-coed
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Using Debugging Tools
- See Training Course Details...
Locking Records for Updating
Understanding the Order of Events
Using the For...Next Structure
Calling Procedures
Understanding VBA's Error Trapping Options
Controlling Program Execution
Determining the Value of Expressions
Creating a Function Procedure
Using Intrinsic Constants
Setting Breakpoints
Working with Methods
Using Expressions, Variables, and Intrinsic Functions
Specifying a Recordset Cursor Type
Creating a Standard Module
Stepping through Code
Working with Events
Considering Variable Scope and Lifetime Together
Using the Immediate Window to Call Procedures
Email us about this courses
Other Cil-y-coed Enable Technology Training Courses
TSQL - Cil-y-coed SQL Training Courses
JavaScript - Cil-y-coed JavaScript Training Courses
Excel 365 Basic Cil-y-coed Training Courses
JQuery - Cil-y-coed JavaScript Training Courses
Power Query - Cil-y-coed Excel Training Courses
SSIS Cil-y-coed Training Courses