ACCESS TRAINING COURSES SOUTH GLAMORGAN
About Enable Technology South Glamorgan Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Courses are instructor led and groups sizes small. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. If delivery onsite is an issue we will organise a socially distanced venue near you in South Glamorgan. The Access syllabus can be modified to accommodate your specific training needs.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Cadbury PLC, Wolverhampton City Council, EDF Energy PLC, Canadian High Commission, Norfolk Police Constabulary, Birmingham City Council, Loughborough University and GKN PLC.
Microsoft Access
- 2 day course
- Location: South Glamorgan
- 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 ... Getting to Know Access
- See Training Course Details...
Parameter Queries
Multi Table Queries
Querying Techniques
Importing and Exporting Records
Creating and Using Reports
Macro Techniques
Macros on Forms
Action Queries
Adding Transactional Records
Relational Database Design
Database Security
Using a Navigation Form
Aggregation Queries
Modifying Table Structures
Sorting and Filtering
Formatting Tables
Working With Records
Designing a Lookup Database
Creating and Using Macros
Data Validation
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 ... Using Break Mode during Run Mode
- See Training Course Details...
Using the Select Case...End Select Structure
Organizing Code and Procedures
Using the Do...Loop Structure
Determining the Value of Expressions
Using Intrinsic Constants
Locking Records for Updating
Working with Variable Scope
Understanding the DoCmd Object
Understanding Recordset Cursor Properties - Optional
Navigating the Access Object Hierarchy
Understanding Error Handling
Creating a Sub Procedure
Specifying a Recordset Cursor Type
Setting Breakpoints
Understanding Procedures
Working with Events
Email us about this courses
Other South Glamorgan Enable Technology Training Courses
Power Query - South Glamorgan Excel Training Courses
TSQL - South Glamorgan SQL Training Courses
Report Builder South Glamorgan Training Courses
Excel 365 Intermediate South Glamorgan Training Courses
JQuery South Glamorgan Training Courses
VBA - South Glamorgan Excel Training Courses