ACCESS TRAINING COURSES WEST MIDLANDS
About Enable Technology West Midlands Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All course participants are issued Access training manuals they can refer to after the course. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Enable Technology training courses are delivered as instructor led courses. 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. We can also deliver the Access course at a socially distanced local training venue in West Midlands. All Access courses can be customised to meet your particular requirements.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
Our teaching team have over twenty years continuous technical training experience. Some of our clients are Countrywide Homes Limited, Capita Group PLC, Birmingham City Council, Wolverhampton City Council, TalkTalk Direct Limited, Total Telecommunications Limited, South Staffordshire Water PLC and Vodafone Group Services.
Microsoft Access
- 2 day course
- Location: West Midlands
- 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 ... An Introduction to VBA
- See Training Course Details...
Macros on Forms
Understanding VBA
Data Validation
DIY Forms
Creating and Using Reports
Aggregation Queries
Creating and Using Forms
Calculations in Queries
Importing and Exporting Records
Formatting Tables
Relational Database Design
Database Security
Database Wellness
Working With Records
Creating a Lookup Database
Using a Navigation Form
Creating and Using Macros
Modifying Table Structures
Macro Techniques
Multi Table Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: West Midlands
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Working with Variable Scope
- See Training Course Details...
Understanding Expressions and Statements
Handling Errors
Creating a Standard Module
Understanding Data Types
Using the Select Case...End Select Structure
Introduction to Programming in Access
Naming Procedures
Using Expressions, Variables, and Intrinsic Functions
Understanding the DoCmd Object
Using the With Statement
Guidelines for use of Branching Structures
Using Debugging Tools
Understanding Procedures
Working with the ADODB Recordset Object
Working with Methods
Controlling Program Execution
Using Break Mode during Run Mode
Working with the Code Editor
Email us about this courses
Other West Midlands Enable Technology Training Courses
PL/SQL West Midlands Training Courses
JavaScript - West Midlands JavaScript Training Courses
Power BI West Midlands Training Courses
Excel 365 Basic West Midlands Training Courses
JQuery Mobile West Midlands Training Courses
Excel 365 Advanced West Midlands Training Courses