ACCESS TRAINING COURSES CAERPHILLY
About Enable Technology Caerphilly Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and Access course resources that can be referenced post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. 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. Another way we could deliver the Access course is at a local training site. We are happy to discuss customising the course content should you have particular Access training requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are University of Birmingham, Fujistu PLC, Queen's Medical Centre Nottingham, Cadbury PLC, Royal & Sun Alliance Group PLC, Canadian High Commission, Dollond & Aitchison Limited and Aston University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Caerphilly
- 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 ... Declaring and Creating Object Variables
- See Training Course Details...
Using Input Boxes
Organizing Code and Procedures
Understanding Procedures
Understanding the Form Object
Guidelines for use of Branching Structures
Using the Object Browser
Understanding Classes and Objects
Understanding the Order of Events
Stepping through Code
Setting Breakpoints
Using the Immediate Window to Call Procedures
Handling Errors
Debugging Code
Specifying a Recordset Cursor Location - Optional
Using Break Mode during Run Mode
Using Message Boxes
Understanding Objects
Navigating the Access Object Hierarchy
Microsoft Access
- 2 day course
- Location: Caerphilly
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Navigation Pane Protection
- See Training Course Details...
Creating a Relational Database
Creating and Using Macros
Working With Records
Creating and Using Reports
Aggregation Queries
Setting Table Relationships
Getting to Know Access
DIY Forms
Parameter Queries
Calculations in Queries
Macro Techniques
Action Queries
Macros on Forms
Querying Techniques
Creating and Using Forms
Multi Table Queries
Using a Navigation Form
Relational Database Design
Modifying Forms
Sorting and Filtering
Email us about this courses
Other Caerphilly Enable Technology Training Courses
SSAS Tabular Caerphilly Training Courses
Excel 365 Advanced - Caerphilly Excel Training Courses
JQuery - Caerphilly JavaScript Training Courses
SQL Caerphilly Training Courses
Excel 365 Basic Caerphilly Training Courses
DAX - Caerphilly Excel Training Courses