ACCESS TRAINING COURSES RISCA
About Enable Technology Risca Access Training Courses
We are a company that provides short intensive Access training courses. All of our tutors are Microsoft Certified Professionals. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Access courses are taught by a Microsoft Certified Solutions Expert. 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 training site. We are happy to modify the Access syllabus to match your teams training requirements.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Wolverhampton City Council, DHL Express, Halfords Group PLC, Aston University, South Staffordshire Water PLC, Yell Group PLC, Nuclear Engineering Services and Birmingham Heartlands Hospital.
Microsoft Access
- 2 day course
- Location: Risca
- 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 ... Action Queries
- See Training Course Details...
Parameter Queries
Designing a Lookup Database
DIY Forms
Macro Techniques
Querying Techniques
Sorting and Filtering
Database Security
Adding Records to a Table
Understanding VBA
Creating a Lookup Database
Modifying Forms
Creating a Relational Database
Relational Database Design
An Introduction to VBA
Using a Navigation Form
Formatting Tables
Calculations in Queries
Data Validation
Adding Transactional Records
Creating Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Risca
- 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 ... Creating a Standard Module
- See Training Course Details...
Working with Boolean Expressions
Specifying a Recordset Cursor Type
Determining the Value of Expressions
Working with the Code Editor
Setting Break Expressions
Working with Inline Error Handling
Understanding Collections
Understanding VBA's Error Trapping Options
Organizing Code and Procedures
Using the CacheSize Property - Optional
Working with Procedures and Functions
Understanding the Form Object
Introduction to Programming in Access
Using Debugging Tools
Working with Recordsets
Understanding Objects
Working with the ADODB Recordset Object
Using Expressions, Variables, and Intrinsic Functions
Email us about this courses
Other Risca Enable Technology Training Courses
SSAS Risca Training Courses
SQL - Risca SQL Training Courses
Excel 365 Advanced - Risca Excel Training Courses
JavaScript - Risca JavaScript Training Courses
Power BI Risca Training Courses
Excel 365 Basic - Risca Excel Training Courses