ACCESS TRAINING COURSES HALESOWEN
About Enable Technology Halesowen Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every person attending a Access course will be provided with training materials and practice files to retain after the course. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
Courses are instructor led and groups sizes small. We can bring the equipment necessary to deliver Access courses at your site. We also offer the option of scheduling of Access course at a venue near you in Halesowen. The Access syllabus can be adjusted and additional topics incorporated if helpful.
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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Royal Air Force, Birmingham City Council, South Staffordshire Water PLC, University of Birmingham, Birmingham Heartlands Hospital, Countrywide Homes Limited, Cadbury PLC and Canadian High Commission.
Microsoft Access
- 2 day course
- Location: Halesowen
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Data Validation
- See Training Course Details...
Working With Records
Creating and Using Reports
DIY Forms
Macros on Forms
Designing a Lookup Database
Creating and Using Forms
An Introduction to VBA
Parameter Queries
Navigation Pane Protection
Understanding VBA
Formatting Tables
Setting Table Relationships
Aggregation Queries
Adding Records to a Table
Importing and Exporting Records
Database Wellness
Creating a Lookup Database
Creating Queries
Modifying Forms
Using a Navigation Form
Microsoft Access Programming Using VBA
- 3 day course
- Location: Halesowen
- 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 Object Browser
- See Training Course Details...
Working with the Code Editor
Using Debugging Tools
Working with Inline Error Handling
Using the Do...Loop Structure
Using the Select Case...End Select Structure
Writing an Error-Handling Routine
Using Intrinsic Functions
Debugging Code
Understanding Collections
Understanding Procedures
Understanding Error Handling
Working with Properties
Stepping through Code
Understanding Recordset Cursor Properties - Optional
Trapping Errors with the On Error Statement
Using the For Each...Next Structure
Declaring Variables
Guidelines for use of Branching Structures
Working with the Application Object
Email us about this courses
Other Halesowen Enable Technology Training Courses
Report Builder - Halesowen SQL Server Reporting Services Training Courses
Power BI - Halesowen Microsoft Power BI Training Courses
SSRS - Halesowen SQL Server Reporting Services Training Courses
DAX - Halesowen Excel Training Courses
Oracle SQL - Halesowen SQL Training Courses
SSAS - Halesowen SQL Server Analysis Services Training Courses