ACCESS TRAINING COURSES BARGOED
About Enable Technology Bargoed Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant is given Access courseware which they can refer to after the training. 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.
Enable Technology training courses are delivered as instructor led courses. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. We can also deliver the Access course at a local training venue in Bargoed. The Access syllabus can be adjusted and additional topics incorporated if helpful.
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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Royal Air Force, GKN PLC, DHL Express, Carillion PLC, Wolverhampton City Council, Lloyds TSB Bank PLC, South Staffordshire Water PLC and Loughborough University.
Microsoft Access
- 2 day course
- Location: Bargoed
- 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 ... Navigation Pane Protection
- See Training Course Details...
Adding Records to a Table
Aggregation Queries
Macro Techniques
Database Wellness
DIY Forms
Creating and Using Reports
Adding Transactional Records
Parameter Queries
Using a Navigation Form
Calculations in Queries
Modifying Table Structures
Designing a Lookup Database
Relational Database Design
Working With Records
An Introduction to VBA
Understanding VBA
Importing and Exporting Records
Multi Table Queries
Database Security
Modifying Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bargoed
- 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 ... Creating a Sub Procedure
- See Training Course Details...
Considering Variable Scope and Lifetime Together
Using the If...End If Decision Structures
Controlling Program Execution
Using Expressions, Variables, and Intrinsic Functions
Working with the Application Object
Using Message Boxes
Understanding the Err Object
Working with the Code Editor
Using Break Mode during Run Mode
Understanding Classes and Objects
Specifying a Recordset Cursor Location - Optional
Navigating the Access Object Hierarchy
Working with Recordsets
Creating a Function Procedure
Understanding Modules
Understanding the Order of Events
Email us about this courses
Other Bargoed Enable Technology Training Courses
Data Warehouse Bargoed Training Courses
DAX - Bargoed Excel Training Courses
SSAS - Bargoed SQL Server Analysis Services Training Courses
Report Builder Bargoed Training Courses
Excel 365 Advanced Bargoed Training Courses
SSIS - Bargoed SQL Server Integration Services Training Courses