ACCESS TRAINING COURSES BARGOED
About Enable Technology Bargoed Access Training Courses
Enable Technology provides practical Access skills based technology training. The training will be delivered by a Microsoft professional with development experience. All course participants are issued Access training manuals they can refer to after the course. 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.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We can deliver at your premises. We can provide the equipment. If you prefer we can offer an offsite socially distanced training location in Bargoed. The Access syllabus can be adjusted and additional topics incorporated if helpful.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Dollond & Aitchison Limited, Boots UK Limited, TalkTalk Direct Limited, GKN PLC, Wolverhampton City Council, National Power PLC, Norfolk Police Constabulary and Vodafone Group Services.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bargoed
- 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 ... Stepping through Code
- See Training Course Details...
Understanding Recordset Cursor Properties - Optional
Using Break Mode during Run Mode
Setting Break Expressions
Guidelines for use of Branching Structures
Working with Methods
Considering Variable Scope and Lifetime Together
Using Visual Basic Help
Understanding Error Handling
Working with the Code Editor
Debugging Code
Locking Records for Updating
Naming Procedures
Working with Procedures and Functions
Using the CacheSize Property - Optional
Using the For Each...Next Structure
Understanding the Form Object
Setting Breakpoints
Understanding Collections
Microsoft Access
- 2 day course
- Location: Bargoed
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Modifying Forms
- See Training Course Details...
Formatting Tables
Action Queries
Creating and Using Forms
Calculations in Queries
Creating a Relational Database
Navigation Pane Protection
Database Security
Adding Records to a Table
Sorting and Filtering
Understanding VBA
Creating and Using Macros
DIY Forms
Multi Table Queries
Creating Queries
Working With Records
Relational Database Design
Database Wellness
Creating and Using Reports
Creating a Lookup Database
Data Validation
Email us about this courses
Other Bargoed Enable Technology Training Courses
Excel 365 Advanced Bargoed Training Courses
JQuery Mobile Bargoed Training Courses
Power BI Bargoed Training Courses
SQL - Bargoed SQL Training Courses
Excel 365 Intermediate - Bargoed Excel Training Courses
Oracle SQL - Bargoed SQL Training Courses