ACCESS TRAINING COURSES MID GLAMORGAN
About Enable Technology Mid Glamorgan Access Training Courses
We offer intensive two and three days Access courses. The course will always be taught by a Microsoft Certified Professional (MCP). Every course participant is given Access courseware which they can refer to after the training. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. Another way we could deliver the Access course is at a local training site. All Access courses can be customised to meet your particular requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Birmingham Heartlands Hospital, Boots UK Limited, Barclays Bank PLC, University of Birmingham, Fujistu PLC, Vodafone Group Services, Carillion PLC and Dollond & Aitchison Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Mid Glamorgan
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Understanding Constants
- See Training Course Details...
Using Message Boxes
Using the Do...Loop Structure
Understanding Classes and Objects
Locking Records for Updating
Understanding Objects
Understanding Errors
Using Expressions, Variables, and Intrinsic Functions
Working with Methods
Working with Properties
Creating a Function Procedure
Using the Object Browser
Guidelines for use of Branching Structures
Understanding Data Types
Using the Select Case...End Select Structure
Working with Boolean Expressions
Using Intrinsic Functions
Using the With Statement
Setting Break Expressions
Calling Procedures
Understanding the Form Object
Microsoft Access
- 2 day course
- Location: Mid Glamorgan
- 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 ... Creating Queries
- See Training Course Details...
Modifying Table Structures
Data Validation
Creating and Using Macros
DIY Forms
Creating and Using Forms
Working With Records
Adding Records to a Table
Sorting and Filtering
Modifying Forms
Creating a Lookup Database
Relational Database Design
Getting to Know Access
Querying Techniques
Parameter Queries
Calculations in Queries
Multi Table Queries
Using a Navigation Form
Aggregation Queries
Adding Transactional Records
Macros on Forms
Email us about this courses
Other Mid Glamorgan Enable Technology Training Courses
SSAS Mid Glamorgan Training Courses
JavaScript - Mid Glamorgan JavaScript Training Courses
Excel Power Pivot Mid Glamorgan Training Courses
Power BI Mid Glamorgan Training Courses
DAX - Mid Glamorgan Excel Training Courses
Excel 365 Intermediate Mid Glamorgan Training Courses