ACCESS TRAINING COURSES BLACK COUNTRY
About Enable Technology Black Country Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The training will be delivered by a Microsoft professional with development experience. All course participants are issued Access training manuals they can refer to 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.
Enable Technology training courses are delivered as instructor led courses. 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 can also deliver the Access course at a local training venue in Black Country. The Access syllabus can be modified to accommodate your specific training needs.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Shell UK Oil Products Ltd, Aston University, Norwich Union PLC, Royal Air Force, Queen's Medical Centre Nottingham, Norfolk Police Constabulary, National Power PLC and South Staffordshire Water PLC.
Microsoft Access
- 2 day course
- Location: Black Country
- 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 ... Querying Techniques
- See Training Course Details...
Sorting and Filtering
Adding Records to a Table
Calculations in Queries
Modifying Table Structures
Aggregation Queries
Creating and Using Reports
Adding Transactional Records
Getting to Know Access
Setting Table Relationships
Designing a Lookup Database
Action Queries
Formatting Tables
Database Security
Data Validation
Database Wellness
Creating and Using Forms
Multi Table Queries
Creating a Lookup Database
Macros on Forms
DIY Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Black Country
- 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 ... Creating a Standard Module
- See Training Course Details...
Specifying a Recordset Cursor Type
Working with Boolean Expressions
Using the For...Next Structure
Using Input Boxes
Setting Break Expressions
Organizing Code and Procedures
Using the For Each...Next Structure
Calling Procedures
Using Break Mode during Run Mode
Using the Select Case...End Select Structure
Using the If...End If Decision Structures
Using the Immediate Window to Call Procedures
Working with Inline Error Handling
Understanding Procedures
Specifying a Recordset Cursor Location - Optional
Considering Variable Scope and Lifetime Together
Naming Procedures
Understanding VBA's Error Trapping Options
Creating a Function Procedure
Email us about this courses
Other Black Country Enable Technology Training Courses
SSAS - Black Country SQL Server Analysis Services Training Courses
SSIS - Black Country SQL Server Integration Services Training Courses
Excel 365 Basic - Black Country Excel Training Courses
PL/SQL - Black Country SQL Training Courses
Excel 365 Intermediate Black Country Training Courses
Report Builder Black Country Training Courses