ACCESS TRAINING COURSES RISCA
About Enable Technology Risca Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The course will always be taught by a Microsoft Certified Professional (MCP). 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.
Enable Technology training courses are delivered as instructor led courses. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another way we could deliver the Access course is at a local training site. Every Access course can be modified to meet your bespoke requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Total Telecommunications Limited, Countrywide Homes Limited, Royal Air Force, Dollond & Aitchison Limited, Keele University, Aston University, Lloyds TSB Bank PLC and TalkTalk Direct Limited.
Microsoft Access
- 2 day course
- Location: Risca
- 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 ... Creating a Lookup Database
- See Training Course Details...
Database Wellness
DIY Forms
Modifying Table Structures
Data Validation
Getting to Know Access
Database Security
An Introduction to VBA
Working With Records
Multi Table Queries
Formatting Tables
Aggregation Queries
Importing and Exporting Records
Parameter Queries
Creating and Using Macros
Calculations in Queries
Creating and Using Reports
Relational Database Design
Using a Navigation Form
Macros on Forms
Querying Techniques
Microsoft Access Programming Using VBA
- 3 day course
- Location: Risca
- 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 ... Guidelines for use of Branching Structures
- See Training Course Details...
Declaring Variables
Working with Methods
Understanding Collections
Working with Recordsets
Controlling Program Execution
Understanding the Order of Events
Understanding Errors
Specifying a Recordset Cursor Type
Why Program in Access?
Setting Break Expressions
Using the For Each...Next Structure
Using Debugging Tools
Using Visual Basic Help
Understanding the Err Object
Using Message Boxes
Understanding Control-of-Flow Structures
Setting Breakpoints
Specifying a Recordset Cursor Location - Optional
Working with the ADODB Recordset Object
Email us about this courses
Other Risca Enable Technology Training Courses
Excel Power Pivot Risca Training Courses
Data Warehouse - Risca SQL Training Courses
JQuery - Risca JavaScript Training Courses
Excel 365 Intermediate - Risca Excel Training Courses
VBA Risca Training Courses
JQuery Mobile - Risca JavaScript Training Courses