ACCESS TRAINING COURSES WEDNESBURY
About Enable Technology Wednesbury Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). 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.
Enable Technology training courses are delivered as instructor led courses. We can set up a training lab at your premises and deliver Access courses onsite at your site. We can also deliver the Access course at a local training venue in Wednesbury. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are DHL Express, Wolverhampton City Council, Loughborough University, Unipart Group, TalkTalk Direct Limited, Birmingham City University, Birmingham Heartlands Hospital and Yell Group PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wednesbury
- 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 ... Using the CacheSize Property - Optional
- See Training Course Details...
Using the Do...Loop Structure
Understanding Error Handling
Navigating the Access Object Hierarchy
Writing an Error-Handling Routine
Why Program in Access?
Working with Events
Working with Methods
Understanding Expressions and Statements
Declaring Variables
Using the If...End If Decision Structures
Declaring and Creating Object Variables
Understanding Classes and Objects
Using Intrinsic Constants
Working with Procedures and Functions
Working with Inline Error Handling
Using the Select Case...End Select Structure
Guidelines for use of Branching Structures
Working with the ADODB Recordset Object
Working with the Application Object
Microsoft Access
- 2 day course
- Location: Wednesbury
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Creating a Relational Database
- See Training Course Details...
Creating Queries
An Introduction to VBA
Modifying Forms
Database Wellness
Getting to Know Access
Querying Techniques
Macros on Forms
Data Validation
Calculations in Queries
Creating and Using Forms
Aggregation Queries
Importing and Exporting Records
Formatting Tables
Creating and Using Macros
Database Security
Creating and Using Reports
Modifying Table Structures
Action Queries
Designing a Lookup Database
Using a Navigation Form
Email us about this courses
Other Wednesbury Enable Technology Training Courses
PL/SQL - Wednesbury SQL Training Courses
Excel 365 Advanced - Wednesbury Excel Training Courses
Excel Power Pivot - Wednesbury Excel Training Courses
TSQL - Wednesbury SQL Training Courses
JQuery Mobile Wednesbury Training Courses
Oracle SQL Wednesbury Training Courses