ACCESS TRAINING COURSES GLOUCESTER
About Enable Technology Gloucester Access Training Courses
Enable Technology provides practical Access skills based technology training. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant will receives course practice files and Access course resources that can be referenced post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Courses are instructor led and groups sizes small. 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 also offer the option of scheduling of Access course at a socially distanced venue near you in Gloucester. We are happy to discuss customising the course content should you have particular Access training requirements.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Our clients include: Nuclear Engineering Services, Vodafone Group Services, Norwich Union PLC, Birmingham City Council, EDF Energy PLC, Unipart Group, Royal & Sun Alliance Group PLC and Lloyds TSB Bank PLC.
Microsoft Access
- 2 day course
- Location: Gloucester
- 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 ... Database Security
- See Training Course Details...
Database Wellness
Relational Database Design
DIY Forms
Navigation Pane Protection
Getting to Know Access
Action Queries
Calculations in Queries
Modifying Table Structures
Adding Records to a Table
Parameter Queries
Understanding VBA
Creating and Using Forms
Creating a Lookup Database
Adding Transactional Records
Modifying Forms
Creating a Relational Database
Sorting and Filtering
Macro Techniques
An Introduction to VBA
Data Validation
Microsoft Access Programming Using VBA
- 3 day course
- Location: Gloucester
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Creating a Standard Module
- See Training Course Details...
Organizing Code and Procedures
Introduction to Programming in Access
Working with Procedures and Functions
Guidelines for use of Branching Structures
Working with Methods
Working with Boolean Expressions
Why Program in Access?
Creating a Sub Procedure
Declaring and Creating Object Variables
Understanding Errors
Using Message Boxes
Working with Variable Scope
Using the Immediate Window to Call Procedures
Working with the Application Object
Working with the ADODB Recordset Object
Working with Variable Lifetime
Understanding Expressions and Statements
Using Visual Basic Help
Understanding the Err Object
Email us about this courses
Other Gloucester Enable Technology Training Courses
SSAS - Gloucester SQL Server Analysis Services Training Courses
DAX Gloucester Training Courses
SQL Gloucester Training Courses
Oracle SQL Gloucester Training Courses
Excel 365 Advanced Gloucester Training Courses
Report Builder - Gloucester SQL Server Reporting Services Training Courses