ACCESS TRAINING COURSES LLANRUMNEY
About Enable Technology Llanrumney Access Training Courses
We have a twenty year history of providing skills based Access industry training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Access courses are taught by a Microsoft Certified Solutions Expert. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We also offer the option of scheduling of Access course at a socially distanced venue near you in Llanrumney. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Shell UK Oil Products Ltd, Yell Group PLC, Birmingham City University, Homeserve PLC, Royal Air Force, Birmingham Heartlands Hospital, Capita Group PLC and Birmingham City Council.
Microsoft Access
- 2 day course
- Location: Llanrumney
- Telephone on 01952 938014
- 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...
Querying Techniques
Creating a Lookup Database
Importing and Exporting Records
Designing a Lookup Database
Using a Navigation Form
Modifying Table Structures
Macros on Forms
Creating a Relational Database
Navigation Pane Protection
DIY Forms
Data Validation
Setting Table Relationships
Formatting Tables
Creating and Using Reports
Creating and Using Macros
Adding Records to a Table
Adding Transactional Records
Understanding VBA
Modifying Forms
Action Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Llanrumney
- 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 ... Using the Select Case...End Select Structure
- See Training Course Details...
Using Intrinsic Constants
Naming Procedures
Using Input Boxes
Stepping through Code
Working with the Code Editor
Guidelines for use of Branching Structures
Specifying a Recordset Cursor Type
Calling Procedures
Working with Inline Error Handling
Writing an Error-Handling Routine
Understanding Recordset Cursor Properties - Optional
Understanding the Order of Events
Understanding Expressions and Statements
Introduction to Programming in Access
Understanding the Form Object
Handling Errors
Using Intrinsic Functions
Understanding Classes and Objects
Understanding Collections
Email us about this courses
Other Llanrumney Enable Technology Training Courses
SSIS Llanrumney Training Courses
VBA Llanrumney Training Courses
SSRS - Llanrumney SQL Server Reporting Services Training Courses
Power Query - Llanrumney Excel Training Courses
Excel Power Pivot - Llanrumney Excel Training Courses
SQL Llanrumney Training Courses