ACCESS TRAINING COURSES LLANRUMNEY
About Enable Technology Llanrumney Access Training Courses
Enable Technology specialise in succinct skills based Access training. All Enable Technology tutors are Microsoft certified experts. Everyone attending a Access course receives learning resources which also serves as a reference source 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.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We can set up a training lab at your premises and deliver Access courses onsite at your site. We can also deliver the Access course at a local training venue in Llanrumney. The Access syllabus can be adjusted and additional topics incorporated if helpful.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Cadbury PLC, Norwich Union PLC, Countrywide Homes Limited, Norfolk Police Constabulary, Loughborough University, National Power PLC, Total Telecommunications Limited and Lloyds TSB Bank PLC.
Microsoft Access
- 2 day course
- Location: Llanrumney
- 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 ... Getting to Know Access
- See Training Course Details...
Adding Records to a Table
Database Wellness
Calculations in Queries
Action Queries
Understanding VBA
Creating and Using Macros
Relational Database Design
Multi Table Queries
Importing and Exporting Records
Formatting Tables
Database Security
Adding Transactional Records
Navigation Pane Protection
Parameter Queries
Creating a Lookup Database
Designing a Lookup Database
Data Validation
DIY Forms
Aggregation Queries
Creating and Using Reports
Microsoft Access Programming Using VBA
- 3 day course
- Location: Llanrumney
- 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 the For Each...Next Structure
- See Training Course Details...
Understanding Objects
Working with Properties
Working with Procedures and Functions
Understanding Errors
Using the If...End If Decision Structures
Navigating the Access Object Hierarchy
Declaring Variables
Using Debugging Tools
Introduction to Programming in Access
Understanding Error Handling
Understanding Modules
Understanding Constants
Working with Events
Working with the Application Object
Creating a Function Procedure
Creating a Standard Module
Organizing Code and Procedures
Why Program in Access?
Understanding Recordset Cursor Properties - Optional
Email us about this courses
Other Llanrumney Enable Technology Training Courses
Power BI Llanrumney Training Courses
SSAS - Llanrumney SQL Server Analysis Services Training Courses
SQL - Llanrumney SQL Training Courses
SSRS - Llanrumney SQL Server Reporting Services Training Courses
Excel Power Pivot - Llanrumney Excel Training Courses
VBA Llanrumney Training Courses