ACCESS TRAINING COURSES LLANDUDNO
About Enable Technology Llandudno Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every person attending a Access course will be provided with training materials and practice files to retain after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We also offer the option of scheduling of Access course at a venue near you in Llandudno. All Access courses can be customised to meet your particular requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Birmingham City Council, Boots UK Limited, South Staffordshire Water PLC, GKN PLC, Barclays Bank PLC, Canadian High Commission, Cadbury PLC and Nuclear Engineering Services.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Llandudno
- 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 Error Handling
- See Training Course Details...
Why Program in Access?
Working with Procedures and Functions
Specifying a Recordset Cursor Type
Using the For Each...Next Structure
Working with Inline Error Handling
Working with the ADODB Recordset Object
Understanding VBA's Error Trapping Options
Stepping through Code
Navigating the Access Object Hierarchy
Working with Boolean Expressions
Working with Variable Lifetime
Writing an Error-Handling Routine
Understanding Recordset Cursor Properties - Optional
Understanding Constants
Calling Procedures
Setting Break Expressions
Using Intrinsic Functions
Microsoft Access
- 2 day course
- Location: Llandudno
- 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 ... Designing a Lookup Database
- See Training Course Details...
Creating and Using Macros
Data Validation
Modifying Forms
DIY Forms
Parameter Queries
Working With Records
Action Queries
Creating a Lookup Database
Creating a Relational Database
Navigation Pane Protection
Macro Techniques
Getting to Know Access
Relational Database Design
Importing and Exporting Records
Using a Navigation Form
Querying Techniques
Aggregation Queries
Creating and Using Reports
Setting Table Relationships
Multi Table Queries
Email us about this courses
Other Llandudno Enable Technology Training Courses
JQuery Mobile Llandudno Training Courses
JQuery Llandudno Training Courses
JavaScript - Llandudno JavaScript Training Courses
SSAS - Llandudno SQL Server Analysis Services Training Courses
PL/SQL - Llandudno SQL Training Courses
Oracle SQL - Llandudno SQL Training Courses