ACCESS TRAINING COURSES SOUTH GLAMORGAN
About Enable Technology South Glamorgan Access Training Courses
Enable Technology provides practical Access skills based technology training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). We will issue each Access training participant with learning resources which they can refer to post 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.
Enable Technology training courses are delivered as instructor led courses. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We can also deliver the Access course at a local training venue in South Glamorgan. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Norfolk Police Constabulary, Norwich Union PLC, South Staffordshire Water PLC, Birmingham Heartlands Hospital, Royal & Sun Alliance Group PLC, Countrywide Homes Limited, TalkTalk Direct Limited and Dollond & Aitchison Limited.
Microsoft Access
- 2 day course
- Location: South Glamorgan
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Relational Database Design
- See Training Course Details...
Database Security
Navigation Pane Protection
Modifying Table Structures
Adding Records to a Table
Working With Records
Creating Queries
Multi Table Queries
Creating and Using Forms
Creating a Relational Database
Parameter Queries
Using a Navigation Form
Modifying Forms
Creating and Using Reports
Sorting and Filtering
DIY Forms
Aggregation Queries
Creating a Lookup Database
Creating and Using Macros
Understanding VBA
Designing a Lookup Database
Microsoft Access Programming Using VBA
- 3 day course
- Location: South Glamorgan
- 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 ... Working with Properties
- See Training Course Details...
Understanding the Err Object
Considering Variable Scope and Lifetime Together
Navigating the Access Object Hierarchy
Why Program in Access?
Using Intrinsic Constants
Working with the Application Object
Understanding Recordset Cursor Properties - Optional
Understanding Classes and Objects
Using the CacheSize Property - Optional
Using the For Each...Next Structure
Using Visual Basic Help
Working with Events
Using the If...End If Decision Structures
Understanding VBA's Error Trapping Options
Creating a Sub Procedure
Locking Records for Updating
Using the Object Browser
Understanding Expressions and Statements
Working with Procedures and Functions
Email us about this courses
Other South Glamorgan Enable Technology Training Courses
Oracle SQL South Glamorgan Training Courses
JQuery Mobile - South Glamorgan JavaScript Training Courses
VBA - South Glamorgan Excel Training Courses
Excel 365 Intermediate - South Glamorgan Excel Training Courses
Power BI South Glamorgan Training Courses
JavaScript - South Glamorgan JavaScript Training Courses