ACCESS TRAINING COURSES SPLOTT
About Enable Technology Splott Access Training Courses
Enable Technology provides practical Access skills based technology training. The course will always be taught by a Microsoft Certified Professional (MCP). Everyone attending a Access course receives learning resources which also serves as a reference source 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.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. If delivery onsite is an issue we will organise a socially distanced venue near you in Splott. The Access syllabus can be modified to accommodate your specific training needs.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Aston University, Wolverhampton City Council, Carillion PLC, Vodafone Group Services, University of Birmingham, Dollond & Aitchison Limited, Canadian High Commission and Total Telecommunications Limited.
Microsoft Access
- 2 day course
- Location: Splott
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Using a Navigation Form
- See Training Course Details...
Creating and Using Forms
Calculations in Queries
Sorting and Filtering
Action Queries
Getting to Know Access
Navigation Pane Protection
Designing a Lookup Database
Querying Techniques
Setting Table Relationships
Creating and Using Reports
Creating and Using Macros
Understanding VBA
Data Validation
Macros on Forms
Adding Records to a Table
Macro Techniques
Relational Database Design
Modifying Forms
Multi Table Queries
DIY Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Splott
- 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 ... Setting Breakpoints
- See Training Course Details...
Working with the Code Editor
Working with Boolean Expressions
Understanding the Development Environment
Debugging Code
Understanding Recordset Cursor Properties - Optional
Understanding Procedures
Working with Events
Creating a Standard Module
Using the For...Next Structure
Using Break Mode during Run Mode
Calling Procedures
Declaring and Creating Object Variables
Using Visual Basic Help
Understanding the DoCmd Object
Guidelines for use of Branching Structures
Working with Inline Error Handling
Understanding the Order of Events
Email us about this courses
Other Splott Enable Technology Training Courses
SSAS Tabular Splott Training Courses
SSIS Splott Training Courses
Oracle SQL - Splott SQL Training Courses
Excel Power Pivot - Splott Excel Training Courses
JQuery Splott Training Courses
SSAS Splott Training Courses