ACCESS TRAINING COURSES CIL-Y-COED
About Enable Technology Cil-y-coed Access Training Courses
Enable Technology provides practical Access skills based technology training. The training will be delivered by a Microsoft professional with development experience. Every course participant will receives course practice files and Access course resources that can be referenced post training. 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. We can also deliver the Access course at a local training venue in Cil-y-coed. Every Access course can be modified to meet your bespoke requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Fujistu PLC, Unipart Group, Total Telecommunications Limited, Cadbury PLC, Wolverhampton City Council, West Bromwich Building Society, Vodafone Group Services and Carillion PLC.
Microsoft Access
- 2 day course
- Location: Cil-y-coed
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Adding Records to a Table
- See Training Course Details...
Importing and Exporting Records
Navigation Pane Protection
Adding Transactional Records
Data Validation
Modifying Table Structures
Formatting Tables
Setting Table Relationships
Database Wellness
Calculations in Queries
DIY Forms
Designing a Lookup Database
Sorting and Filtering
Action Queries
Querying Techniques
Creating and Using Forms
Understanding VBA
Multi Table Queries
Parameter Queries
Database Security
Using a Navigation Form
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 ... Considering Variable Scope and Lifetime Together
- See Training Course Details...
Controlling Program Execution
Naming Procedures
Understanding Recordset Cursor Properties - Optional
Working with the Application Object
Using Visual Basic Help
Writing an Error-Handling Routine
Understanding Data Types
Understanding the DoCmd Object
Navigating the Access Object Hierarchy
Working with Inline Error Handling
Calling Procedures
Declaring and Creating Object Variables
Using Input Boxes
Organizing Code and Procedures
Using the With Statement
Using Message Boxes
Declaring Variables
Using the Do...Loop Structure
Creating a Function Procedure
Understanding Error Handling
Email us about this courses
Other Cil-y-coed Enable Technology Training Courses
Excel Power Pivot - Cil-y-coed Excel Training Courses
Oracle SQL - Cil-y-coed SQL Training Courses
JQuery Mobile Cil-y-coed Training Courses
DAX Cil-y-coed Training Courses
PL/SQL - Cil-y-coed SQL Training Courses
SSRS - Cil-y-coed SQL Server Reporting Services Training Courses