ACCESS TRAINING COURSES LLANDUDNO
About Enable Technology Llandudno Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every course participant is given Access courseware which they can refer to after the training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
We provide instructor led training coupled with hands on training. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. The Access course could also be scheduled at a socially distanced site near you in Llandudno. The Access syllabus can be modified to accommodate your specific training needs.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Queen's Medical Centre Nottingham, University of Birmingham, National Power PLC, Vodafone Group Services, Halfords Group PLC, EDF Energy PLC, Aston University and Norwich Union PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Llandudno
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Using Intrinsic Functions
- See Training Course Details...
Working with Variable Scope
Creating a Standard Module
Working with Variable Lifetime
Debugging Code
Understanding Errors
Using Expressions, Variables, and Intrinsic Functions
Naming Procedures
Understanding the Err Object
Creating a Sub Procedure
Working with Events
Using the For Each...Next Structure
Using the For...Next Structure
Creating a Function Procedure
Navigating the Access Object Hierarchy
Understanding Error Handling
Controlling Program Execution
Using Break Mode during Run Mode
Trapping Errors with the On Error Statement
Working with Inline Error Handling
Understanding the Form Object
Microsoft Access
- 2 day course
- Location: Llandudno
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Sorting and Filtering
- See Training Course Details...
Relational Database Design
Calculations in Queries
Multi Table Queries
Database Wellness
Adding Records to a Table
Creating a Relational Database
Data Validation
Getting to Know Access
Database Security
Modifying Table Structures
Macros on Forms
Action Queries
Creating and Using Macros
Using a Navigation Form
Adding Transactional Records
Parameter Queries
Querying Techniques
Importing and Exporting Records
Macro Techniques
DIY Forms
Email us about this courses
Other Llandudno Enable Technology Training Courses
JQuery - Llandudno JavaScript Training Courses
SSAS Tabular Llandudno Training Courses
JavaScript - Llandudno JavaScript Training Courses
TSQL Llandudno Training Courses
Report Builder Llandudno Training Courses
Excel 365 Basic Llandudno Training Courses