ACCESS TRAINING COURSES LLANDUDNO
About Enable Technology Llandudno Access Training Courses
We have a twenty year history of providing skills based Access industry training. The course will always be taught by a Microsoft Certified Professional (MCP). We will issue each Access training participant with learning resources which they can refer to post training. 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.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. We can bring the equipment necessary to deliver Access courses at your site. If you prefer we can offer an offsite socially distanced training location in Llandudno. 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 group of companies has been operating continuously providing IT training since 1998. Some of our clients are National Power PLC, Queen's Medical Centre Nottingham, Royal & Sun Alliance Group PLC, Nuclear Engineering Services, Birmingham City Council, Shell UK Oil Products Ltd, Birmingham Heartlands Hospital and Halfords Group PLC.
Microsoft Access
- 2 day course
- Location: Llandudno
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Working With Records
- See Training Course Details...
Macro Techniques
Adding Transactional Records
Relational Database Design
Creating and Using Macros
Parameter Queries
Creating and Using Forms
Calculations in Queries
Understanding VBA
Macros on Forms
Importing and Exporting Records
Action Queries
Creating and Using Reports
Database Security
Designing a Lookup Database
Creating Queries
Adding Records to a Table
Aggregation Queries
Getting to Know Access
Modifying Forms
Querying Techniques
Microsoft Access Programming Using VBA
- 3 day course
- Location: Llandudno
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Trapping Errors with the On Error Statement
- See Training Course Details...
Using Expressions, Variables, and Intrinsic Functions
Using the Immediate Window to Call Procedures
Understanding Errors
Locking Records for Updating
Understanding Recordset Cursor Properties - Optional
Guidelines for use of Branching Structures
Understanding the Err Object
Navigating the Access Object Hierarchy
Understanding the DoCmd Object
Calling Procedures
Writing an Error-Handling Routine
Using Break Mode during Run Mode
Using the CacheSize Property - Optional
Working with Methods
Working with Variable Lifetime
Using the For Each...Next Structure
Email us about this courses
Other Llandudno Enable Technology Training Courses
JQuery - Llandudno JavaScript Training Courses
VBA Llandudno Training Courses
DAX Llandudno Training Courses
Excel 365 Basic Llandudno Training Courses
JQuery Mobile Llandudno Training Courses
SSAS Llandudno Training Courses