ACCESS TRAINING COURSES WEST BROMWICH
About Enable Technology West Bromwich Access Training Courses
We offer intensive two and three days Access courses. The training will be delivered by a Microsoft professional with development experience. 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.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. 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. The Access course could also be scheduled at a socially distanced site near you in West Bromwich. The Access syllabus can be adjusted and additional topics incorporated if helpful.
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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: GKN PLC, Vodafone Group Services, National Power PLC, Capita Group PLC, Halfords Group PLC, Canadian High Commission, Shell UK Oil Products Ltd and Homeserve PLC.
Microsoft Access
- 2 day course
- Location: West Bromwich
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Modifying Forms
- See Training Course Details...
Macro Techniques
Adding Records to a Table
Database Security
Working With Records
Creating Queries
Using a Navigation Form
Modifying Table Structures
Creating and Using Forms
Aggregation Queries
Calculations in Queries
An Introduction to VBA
Creating a Relational Database
Creating a Lookup Database
Formatting Tables
Getting to Know Access
Macros on Forms
Setting Table Relationships
Creating and Using Macros
Parameter Queries
Relational Database Design
Microsoft Access Programming Using VBA
- 3 day course
- Location: West Bromwich
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Working with the ADODB Recordset Object
- See Training Course Details...
Creating a Sub Procedure
Working with Methods
Working with Variable Scope
Trapping Errors with the On Error Statement
Working with Inline Error Handling
Working with Boolean Expressions
Specifying a Recordset Cursor Location - Optional
Using Intrinsic Constants
Controlling Program Execution
Setting Break Expressions
Understanding Error Handling
Understanding VBA's Error Trapping Options
Understanding Errors
Working with Variable Lifetime
Using the With Statement
Why Program in Access?
Using the For...Next Structure
Calling Procedures
Setting Breakpoints
Email us about this courses
Other West Bromwich Enable Technology Training Courses
SSAS Tabular - West Bromwich SQL Server Analysis Services Training Courses
Power Query West Bromwich Training Courses
TSQL - West Bromwich SQL Training Courses
SQL - West Bromwich SQL Training Courses
Power BI - West Bromwich Microsoft Power BI Training Courses
Excel Power Pivot West Bromwich Training Courses