ACCESS TRAINING COURSES SANDWELL
About Enable Technology Sandwell Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. All of our tutors are Microsoft Certified Professionals. Each person attending a course takes away Access courseware which can be used as reference materials after the training. 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.
Access courses are taught by a Microsoft Certified Solutions Expert. We can bring the equipment necessary to deliver Access courses at your site. Another option is we can organise a local socially distanced training site in Sandwell. The Access syllabus can be modified to accommodate your specific training needs.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Birmingham Heartlands Hospital, Homeserve PLC, Boots UK Limited, Birmingham City University, Loughborough University, Norfolk Police Constabulary, Fujistu PLC and Wolverhampton City Council.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Sandwell
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Using Intrinsic Constants
- See Training Course Details...
Using Break Mode during Run Mode
Using Input Boxes
Working with Events
Understanding the DoCmd Object
Working with Inline Error Handling
Using Debugging Tools
Understanding Procedures
Using Message Boxes
Understanding Errors
Understanding Data Types
Understanding Collections
Understanding Control-of-Flow Structures
Understanding Recordset Cursor Properties - Optional
Using the Select Case...End Select Structure
Understanding Expressions and Statements
Understanding Classes and Objects
Locking Records for Updating
Understanding Objects
Microsoft Access
- 2 day course
- Location: Sandwell
- 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 ... Getting to Know Access
- See Training Course Details...
Creating a Relational Database
Working With Records
Macros on Forms
Creating Queries
Creating a Lookup Database
Creating and Using Forms
Creating and Using Macros
Designing a Lookup Database
Setting Table Relationships
Modifying Forms
Formatting Tables
Database Wellness
Multi Table Queries
Modifying Table Structures
Using a Navigation Form
Aggregation Queries
Adding Transactional Records
Relational Database Design
Data Validation
Action Queries
Email us about this courses
Other Sandwell Enable Technology Training Courses
Excel 365 Advanced - Sandwell Excel Training Courses
Data Warehouse - Sandwell SQL Training Courses
VBA - Sandwell Excel Training Courses
Report Builder - Sandwell SQL Server Reporting Services Training Courses
Power BI - Sandwell Microsoft Power BI Training Courses
Excel 365 Basic Sandwell Training Courses