ACCESS TRAINING COURSES UTTOXETER
About Enable Technology Uttoxeter Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Each course participant will be issued with training Access resources which they can continue to use after the training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We are set up to deliver Access training courses onsite at your premises. We also offer the option of scheduling of Access course at a venue near you in Uttoxeter. All Access courses can be customised to meet your particular requirements.
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.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Birmingham City Council, TalkTalk Direct Limited, Queen's Medical Centre Nottingham, Carillion PLC, EDF Energy PLC, Dollond & Aitchison Limited, DHL Express and Nuclear Engineering Services.
Microsoft Access
- 2 day course
- Location: Uttoxeter
- 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 Macros
- See Training Course Details...
Modifying Table Structures
Working With Records
DIY Forms
Adding Transactional Records
Calculations in Queries
Creating and Using Forms
Creating and Using Reports
Database Security
Parameter Queries
Navigation Pane Protection
Getting to Know Access
Creating a Relational Database
Querying Techniques
Modifying Forms
Using a Navigation Form
Creating a Lookup Database
Data Validation
Relational Database Design
Database Wellness
Setting Table Relationships
Microsoft Access Programming Using VBA
- 3 day course
- Location: Uttoxeter
- 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 the Object Browser
- See Training Course Details...
Setting Break Expressions
Guidelines for use of Branching Structures
Creating a Standard Module
Using the Do...Loop Structure
Working with Procedures and Functions
Working with Events
Understanding Recordset Cursor Properties - Optional
Why Program in Access?
Understanding Collections
Understanding the Form Object
Specifying a Recordset Cursor Location - Optional
Using the For Each...Next Structure
Calling Procedures
Understanding VBA's Error Trapping Options
Considering Variable Scope and Lifetime Together
Declaring Variables
Email us about this courses
Other Uttoxeter Enable Technology Training Courses
Report Builder - Uttoxeter SQL Server Reporting Services Training Courses
SSRS - Uttoxeter SQL Server Reporting Services Training Courses
Excel 365 Advanced - Uttoxeter Excel Training Courses
DAX - Uttoxeter Excel Training Courses
SSAS - Uttoxeter SQL Server Analysis Services Training Courses
Oracle SQL Uttoxeter Training Courses