ACCESS TRAINING COURSES BRYN PYDEW
About Enable Technology Bryn Pydew Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training courses. The training will be delivered by a Microsoft professional with development experience. Every person attending a Access course will be provided with training materials and practice files to retain after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We can set up a training lab at your premises and deliver Access courses onsite at your site. Another way we could deliver the Access course is at a local socially distanced training site. Every Access course can be modified to meet your bespoke requirements.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: National Power PLC, Canadian High Commission, Fujistu PLC, University of Birmingham, Yell Group PLC, Aston University, Norwich Union PLC and Shell UK Oil Products Ltd.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bryn Pydew
- 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 Message Boxes
- See Training Course Details...
Using the With Statement
Organizing Code and Procedures
Using Intrinsic Constants
Using the Select Case...End Select Structure
Understanding Objects
Understanding Constants
Creating a Function Procedure
Declaring Variables
Controlling Program Execution
Working with Events
Using Debugging Tools
Naming Procedures
Declaring and Creating Object Variables
Stepping through Code
Understanding VBA's Error Trapping Options
Considering Variable Scope and Lifetime Together
Microsoft Access
- 2 day course
- Location: Bryn Pydew
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Database Security
- See Training Course Details...
Multi Table Queries
Creating a Relational Database
Creating and Using Reports
Working With Records
An Introduction to VBA
Creating and Using Forms
Adding Records to a Table
Macros on Forms
Data Validation
Navigation Pane Protection
Parameter Queries
DIY Forms
Adding Transactional Records
Formatting Tables
Modifying Table Structures
Designing a Lookup Database
Querying Techniques
Relational Database Design
Action Queries
Modifying Forms
Email us about this courses
Other Bryn Pydew Enable Technology Training Courses
Power Query - Bryn Pydew Excel Training Courses
JQuery - Bryn Pydew JavaScript Training Courses
VBA - Bryn Pydew Excel Training Courses
Power BI - Bryn Pydew Microsoft Power BI Training Courses
SSAS Tabular - Bryn Pydew SQL Server Analysis Services Training Courses
SSRS Bryn Pydew Training Courses