ACCESS TRAINING COURSES GWYNEDD
About Enable Technology Gwynedd Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The training will be delivered by a Microsoft professional with development experience. Every person attending a Access course will be provided with training materials and practice files to retain after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Access courses are taught by a Microsoft Certified Solutions Expert. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Alternatively we could schedule a course at a local venue in Gwynedd. The Access syllabus can be adjusted and additional topics incorporated if helpful.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Queen's Medical Centre Nottingham, Canadian High Commission, Aston University, Halfords Group PLC, Cadbury PLC, Royal & Sun Alliance Group PLC, Keele University and Carillion PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Gwynedd
- 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 ... Using the Object Browser
- See Training Course Details...
Using the Immediate Window to Call Procedures
Understanding Objects
Using the Select Case...End Select Structure
Organizing Code and Procedures
Creating a Function Procedure
Stepping through Code
Debugging Code
Specifying a Recordset Cursor Type
Understanding the Form Object
Understanding Errors
Understanding the DoCmd Object
Declaring and Creating Object Variables
Using the CacheSize Property - Optional
Working with Properties
Understanding the Order of Events
Understanding Collections
Working with Methods
Considering Variable Scope and Lifetime Together
Using Expressions, Variables, and Intrinsic Functions
Working with Procedures and Functions
Microsoft Access
- 2 day course
- Location: Gwynedd
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Creating and Using Forms
- See Training Course Details...
Sorting and Filtering
Creating and Using Reports
Formatting Tables
Understanding VBA
Working With Records
Creating a Relational Database
Aggregation Queries
Creating a Lookup Database
Setting Table Relationships
Querying Techniques
Database Security
Action Queries
Navigation Pane Protection
Creating Queries
Macro Techniques
Multi Table Queries
Getting to Know Access
Creating and Using Macros
An Introduction to VBA
Adding Records to a Table
Email us about this courses
Other Gwynedd Enable Technology Training Courses
SSAS Tabular - Gwynedd SQL Server Analysis Services Training Courses
Oracle SQL - Gwynedd SQL Training Courses
JavaScript Gwynedd Training Courses
JQuery Gwynedd Training Courses
Power BI Gwynedd Training Courses
Report Builder Gwynedd Training Courses