ACCESS TRAINING COURSES LLANTRISANT
About Enable Technology Llantrisant Access Training Courses
We have a twenty year history of providing skills based Access industry training. The training will be delivered by a Microsoft professional with development experience. Every person attending a Access course will be provided with training materials and practice files to retain after the course. 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.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Another option is we can organise a local training site in Llantrisant. We are happy to modify the Access syllabus to match your teams training requirements.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Total Telecommunications Limited, Unipart Group, Nuclear Engineering Services, Capita Group PLC, TalkTalk Direct Limited, Lloyds TSB Bank PLC, Aston University and Keele University.
Microsoft Access
- 2 day course
- Location: Llantrisant
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Querying Techniques
- See Training Course Details...
Parameter Queries
Action Queries
Multi Table Queries
Creating and Using Forms
Understanding VBA
Creating and Using Macros
Setting Table Relationships
Database Wellness
Getting to Know Access
Creating a Relational Database
Relational Database Design
An Introduction to VBA
Modifying Forms
Creating Queries
Adding Records to a Table
Importing and Exporting Records
Modifying Table Structures
Calculations in Queries
Macro Techniques
Designing a Lookup Database
Microsoft Access Programming Using VBA
- 3 day course
- Location: Llantrisant
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Understanding the Form Object
- See Training Course Details...
Understanding Expressions and Statements
Using Visual Basic Help
Specifying a Recordset Cursor Type
Working with Inline Error Handling
Using Message Boxes
Introduction to Programming in Access
Understanding the Order of Events
Working with Procedures and Functions
Understanding Collections
Creating a Function Procedure
Understanding Objects
Understanding Control-of-Flow Structures
Using Intrinsic Constants
Using Intrinsic Functions
Working with the ADODB Recordset Object
Understanding Constants
Understanding the Err Object
Stepping through Code
Why Program in Access?
Email us about this courses
Other Llantrisant Enable Technology Training Courses
SSIS Llantrisant Training Courses
JQuery - Llantrisant JavaScript Training Courses
JQuery Mobile Llantrisant Training Courses
SQL - Llantrisant SQL Training Courses
Excel 365 Basic - Llantrisant Excel Training Courses
Excel 365 Advanced Llantrisant Training Courses