ACCESS TRAINING COURSES STOURBRIDGE
About Enable Technology Stourbridge Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We are set up to deliver Access training courses onsite at your premises. Alternatively we could schedule a Access course at an alternative training site in Stourbridge. Every Access course can be modified to meet your bespoke 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.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: National Power PLC, South Staffordshire Water PLC, Wolverhampton City Council, Birmingham City Council, Homeserve PLC, Birmingham City University, Birmingham Heartlands Hospital and Nuclear Engineering Services.
Microsoft Access
- 2 day course
- Location: Stourbridge
- 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 ... Sorting and Filtering
- See Training Course Details...
Aggregation Queries
Creating and Using Forms
Parameter Queries
Adding Transactional Records
Calculations in Queries
Data Validation
Modifying Table Structures
Database Security
Setting Table Relationships
Formatting Tables
Action Queries
Getting to Know Access
An Introduction to VBA
Macros on Forms
Understanding VBA
Querying Techniques
Multi Table Queries
Navigation Pane Protection
DIY Forms
Relational Database Design
Microsoft Access Programming Using VBA
- 3 day course
- Location: Stourbridge
- 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 For...Next Structure
- See Training Course Details...
Using the For Each...Next Structure
Working with Events
Using the If...End If Decision Structures
Handling Errors
Trapping Errors with the On Error Statement
Understanding the Order of Events
Using Expressions, Variables, and Intrinsic Functions
Using the With Statement
Stepping through Code
Using Break Mode during Run Mode
Working with Procedures and Functions
Setting Break Expressions
Understanding Collections
Understanding VBA's Error Trapping Options
Using Input Boxes
Working with Variable Scope
Working with Recordsets
Navigating the Access Object Hierarchy
Email us about this courses
Other Stourbridge Enable Technology Training Courses
Power Query Stourbridge Training Courses
Excel Power Pivot Stourbridge Training Courses
SSAS - Stourbridge SQL Server Analysis Services Training Courses
SSRS Stourbridge Training Courses
Power BI Stourbridge Training Courses
Oracle SQL Stourbridge Training Courses