ACCESS TRAINING COURSES STAFFORDSHIRE
About Enable Technology Staffordshire Access Training Courses
Enable Technology offer short intensive skills based Access training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. All course participants are issued Access training manuals they can refer to 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.
Access courses are taught by a Microsoft Certified Solutions Expert. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. The Access course could also be scheduled at a socially distanced site near you in Staffordshire. Every Access course can be modified to meet your bespoke requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are EDF Energy PLC, Countrywide Homes Limited, DHL Express, Canadian High Commission, Vodafone Group Services, West Bromwich Building Society, Lloyds TSB Bank PLC and Nuclear Engineering Services.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Staffordshire
- 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 the Application Object
- See Training Course Details...
Using Input Boxes
Working with Events
Using the For...Next Structure
Controlling Program Execution
Stepping through Code
Working with Variable Lifetime
Working with Variable Scope
Using the CacheSize Property - Optional
Understanding the Development Environment
Working with Properties
Trapping Errors with the On Error Statement
Declaring Variables
Using Expressions, Variables, and Intrinsic Functions
Understanding Classes and Objects
Considering Variable Scope and Lifetime Together
Using the For Each...Next Structure
Understanding Data Types
Understanding Collections
Microsoft Access
- 2 day course
- Location: Staffordshire
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Navigation Pane Protection
- See Training Course Details...
Setting Table Relationships
Creating a Lookup Database
Data Validation
Macros on Forms
Using a Navigation Form
DIY Forms
Adding Records to a Table
Designing a Lookup Database
Formatting Tables
Working With Records
Creating and Using Reports
Parameter Queries
Calculations in Queries
Adding Transactional Records
Multi Table Queries
Modifying Forms
Modifying Table Structures
Getting to Know Access
Creating and Using Forms
Creating Queries
Email us about this courses
Other Staffordshire Enable Technology Training Courses
Excel 365 Advanced Staffordshire Training Courses
SSAS - Staffordshire SQL Server Analysis Services Training Courses
Data Warehouse - Staffordshire SQL Training Courses
SSIS - Staffordshire SQL Server Integration Services Training Courses
JavaScript - Staffordshire JavaScript Training Courses
Excel Power Pivot Staffordshire Training Courses