ACCESS TRAINING COURSES FARNWORTH
About Enable Technology Farnworth Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every course participant is given Access courseware which they can refer to after the training. 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.
Access courses are taught by a Microsoft Certified Solutions Expert. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. If delivery onsite is an issue we will organise a venue near you in Farnworth. We are happy to modify the Access syllabus to match your teams training requirements.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to 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. Our clients include: Royal Air Force, Halfords Group PLC, Homeserve PLC, Nuclear Engineering Services, Queen's Medical Centre Nottingham, South Staffordshire Water PLC, West Bromwich Building Society and Birmingham Heartlands Hospital.
Microsoft Access
- 2 day course
- Location: Farnworth
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Parameter Queries
- See Training Course Details...
Understanding VBA
An Introduction to VBA
Macro Techniques
Importing and Exporting Records
Adding Transactional Records
Modifying Forms
Getting to Know Access
Creating a Lookup Database
Database Security
Multi Table Queries
Navigation Pane Protection
Creating Queries
Aggregation Queries
Setting Table Relationships
Creating a Relational Database
Adding Records to a Table
Using a Navigation Form
Formatting Tables
Sorting and Filtering
Modifying Table Structures
Microsoft Access Programming Using VBA
- 3 day course
- Location: Farnworth
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Navigating the Access Object Hierarchy
- See Training Course Details...
Understanding Procedures
Stepping through Code
Understanding Modules
Using Debugging Tools
Locking Records for Updating
Naming Procedures
Using the Object Browser
Understanding Recordset Cursor Properties - Optional
Specifying a Recordset Cursor Type
Using Intrinsic Functions
Understanding the Form Object
Working with Inline Error Handling
Organizing Code and Procedures
Using the Do...Loop Structure
Using the For...Next Structure
Using Break Mode during Run Mode
Working with the ADODB Recordset Object
Understanding Constants
Email us about this courses
Other Farnworth Enable Technology Training Courses
JavaScript - Farnworth JavaScript Training Courses
DAX Farnworth Training Courses
SSRS - Farnworth SQL Server Reporting Services Training Courses
SSIS - Farnworth SQL Server Integration Services Training Courses
VBA - Farnworth Excel Training Courses
Power BI - Farnworth Microsoft Power BI Training Courses