ACCESS TRAINING COURSES TIPTON
About Enable Technology Tipton Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The training will be delivered by a Microsoft professional with development experience. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
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. We are also more than happy to organise a local course at a socially distanced training location in Tipton. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Fujistu PLC, Loughborough University, Birmingham City University, Cadbury PLC, Nationwide Building Society Limited, South Staffordshire Water PLC, Canadian High Commission and National Power PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Tipton
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Considering Variable Scope and Lifetime Together
- See Training Course Details...
Navigating the Access Object Hierarchy
Determining the Value of Expressions
Controlling Program Execution
Understanding Error Handling
Organizing Code and Procedures
Understanding Classes and Objects
Understanding Collections
Setting Break Expressions
Understanding Control-of-Flow Structures
Setting Breakpoints
Using the Object Browser
Working with Events
Understanding Modules
Understanding VBA's Error Trapping Options
Introduction to Programming in Access
Using the With Statement
Microsoft Access
- 2 day course
- Location: Tipton
- 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 ... Designing a Lookup Database
- See Training Course Details...
Getting to Know Access
Adding Transactional Records
Sorting and Filtering
Database Security
Creating a Lookup Database
Adding Records to a Table
Working With Records
Creating a Relational Database
Querying Techniques
Creating and Using Reports
Macros on Forms
Multi Table Queries
Data Validation
An Introduction to VBA
Navigation Pane Protection
Formatting Tables
Parameter Queries
Aggregation Queries
Importing and Exporting Records
Action Queries
Email us about this courses
Other Tipton Enable Technology Training Courses
Excel 365 Intermediate Tipton Training Courses
Report Builder - Tipton SQL Server Reporting Services Training Courses
VBA Tipton Training Courses
SSAS Tipton Training Courses
Excel Power Pivot - Tipton Excel Training Courses
SSIS Tipton Training Courses