ACCESS TRAINING COURSES MOLD
About Enable Technology Mold Access Training Courses
Enable Technology specialise in succinct skills based Access training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every person attending a Access course will be provided with training materials and practice files to retain 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.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another way we could deliver the Access course is at a local training site. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are University of Birmingham, Fujistu PLC, Birmingham City Council, Cadbury PLC, Queen's Medical Centre Nottingham, Halfords Group PLC, GKN PLC and Dollond & Aitchison Limited.
Microsoft Access
- 2 day course
- Location: Mold
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Modifying Table Structures
- See Training Course Details...
Querying Techniques
Macro Techniques
Working With Records
Importing and Exporting Records
Parameter Queries
Adding Records to a Table
Aggregation Queries
Multi Table Queries
Database Security
Macros on Forms
Creating a Relational Database
Designing a Lookup Database
Creating a Lookup Database
Calculations in Queries
Creating and Using Reports
Adding Transactional Records
Action Queries
DIY Forms
Sorting and Filtering
Data Validation
Microsoft Access Programming Using VBA
- 3 day course
- Location: Mold
- 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 With Statement
- See Training Course Details...
Working with Boolean Expressions
Trapping Errors with the On Error Statement
Using the If...End If Decision Structures
Introduction to Programming in Access
Understanding Collections
Understanding the Form Object
Declaring Variables
Using the Object Browser
Using Intrinsic Functions
Creating a Sub Procedure
Using the For...Next Structure
Understanding Data Types
Why Program in Access?
Handling Errors
Understanding Errors
Understanding Constants
Working with Variable Lifetime
Understanding Classes and Objects
Email us about this courses
Other Mold Enable Technology Training Courses
VBA Mold Training Courses
SSAS - Mold SQL Server Analysis Services Training Courses
Oracle SQL Mold Training Courses
Power Query - Mold Excel Training Courses
Excel 365 Basic Mold Training Courses
PL/SQL Mold Training Courses