ACCESS TRAINING COURSES NEATH
About Enable Technology Neath Access Training Courses
We are a company that provides short intensive Access training courses. The tutor delivering the course will be a Microsoft certified expert. All course participants are issued Access training manuals they can refer to 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.
Enable Technology training courses are delivered as instructor led courses. We can set up a training lab at your premises and deliver Access courses onsite at your site. We are also more than happy to organise a local course at a training location in Neath. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Vodafone Group Services, Loughborough University, Yell Group PLC, TalkTalk Direct Limited, Birmingham City University, Countrywide Homes Limited, Aston University and Royal Air Force.
Microsoft Access
- 2 day course
- Location: Neath
- 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 a Relational Database
- See Training Course Details...
Calculations in Queries
Parameter Queries
Adding Records to a Table
Aggregation Queries
Formatting Tables
Adding Transactional Records
Importing and Exporting Records
Designing a Lookup Database
Action Queries
Macro Techniques
Database Wellness
Multi Table Queries
Database Security
Sorting and Filtering
Working With Records
Data Validation
Navigation Pane Protection
Getting to Know Access
Modifying Table Structures
Creating and Using Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Neath
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Understanding Recordset Cursor Properties - Optional
- See Training Course Details...
Guidelines for use of Branching Structures
Considering Variable Scope and Lifetime Together
Setting Break Expressions
Understanding Objects
Working with the ADODB Recordset Object
Using Intrinsic Functions
Using Input Boxes
Using the CacheSize Property - Optional
Working with Recordsets
Organizing Code and Procedures
Using Intrinsic Constants
Declaring and Creating Object Variables
Creating a Sub Procedure
Navigating the Access Object Hierarchy
Using the Object Browser
Understanding VBA's Error Trapping Options
Understanding Classes and Objects
Using the Select Case...End Select Structure
Email us about this courses
Other Neath Enable Technology Training Courses
VBA - Neath Excel Training Courses
TSQL Neath Training Courses
Power BI - Neath Microsoft Power BI Training Courses
Power Query - Neath Excel Training Courses
Excel 365 Intermediate - Neath Excel Training Courses
JQuery Mobile - Neath JavaScript Training Courses