ACCESS TRAINING COURSES CLWYD
About Enable Technology Clwyd Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Everyone attending a Access course receives learning resources which also serves as a reference source 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.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. We also offer the option of scheduling of Access course at a venue near you in Clwyd. 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. Some of our clients are Capita Group PLC, Barclays Bank PLC, Homeserve PLC, Shell UK Oil Products Ltd, Fujistu PLC, Birmingham Heartlands Hospital, Norfolk Police Constabulary and DHL Express.
Microsoft Access
- 2 day course
- Location: Clwyd
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Understanding VBA
- See Training Course Details...
Using a Navigation Form
Calculations in Queries
Sorting and Filtering
Creating and Using Macros
Multi Table Queries
Modifying Table Structures
Importing and Exporting Records
Aggregation Queries
Working With Records
Macros on Forms
Database Wellness
Querying Techniques
Action Queries
Creating a Relational Database
Designing a Lookup Database
Getting to Know Access
Data Validation
Modifying Forms
Relational Database Design
Creating and Using Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Clwyd
- 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 Order of Events
- See Training Course Details...
Controlling Program Execution
Understanding Collections
Working with Variable Scope
Understanding Expressions and Statements
Specifying a Recordset Cursor Type
Writing an Error-Handling Routine
Using Message Boxes
Declaring Variables
Considering Variable Scope and Lifetime Together
Declaring and Creating Object Variables
Understanding Data Types
Understanding Errors
Setting Break Expressions
Understanding the DoCmd Object
Creating a Function Procedure
Using Input Boxes
Understanding the Err Object
Working with Variable Lifetime
Email us about this courses
Other Clwyd Enable Technology Training Courses
TSQL - Clwyd SQL Training Courses
Excel 365 Intermediate - Clwyd Excel Training Courses
VBA Clwyd Training Courses
SQL - Clwyd SQL Training Courses
Excel 365 Advanced - Clwyd Excel Training Courses
SSIS Clwyd Training Courses