ACCESS TRAINING COURSES CHESTER
About Enable Technology Chester Access Training Courses
Enable Technology offer short intensive skills based Access training courses. All of our tutors are Microsoft Certified Professionals. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
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. Alternatively we could schedule a Access course at an alternative training site in Chester. The Access syllabus can be adjusted and additional topics incorporated if helpful.
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.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Boots UK Limited, South Staffordshire Water PLC, Nationwide Building Society Limited, West Bromwich Building Society, Cadbury PLC, Nuclear Engineering Services, DHL Express and Wolverhampton City Council.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Chester
- 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 ... Understanding the DoCmd Object
- See Training Course Details...
Understanding Constants
Specifying a Recordset Cursor Type
Working with Recordsets
Understanding Recordset Cursor Properties - Optional
Why Program in Access?
Understanding Modules
Working with Boolean Expressions
Using the Select Case...End Select Structure
Understanding Classes and Objects
Using Intrinsic Functions
Working with the Application Object
Using Visual Basic Help
Navigating the Access Object Hierarchy
Considering Variable Scope and Lifetime Together
Locking Records for Updating
Understanding Errors
Naming Procedures
Microsoft Access
- 2 day course
- Location: Chester
- 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 and Using Reports
- See Training Course Details...
Understanding VBA
Using a Navigation Form
Adding Transactional Records
Navigation Pane Protection
Creating a Relational Database
Setting Table Relationships
Relational Database Design
Macro Techniques
Modifying Table Structures
Action Queries
Creating and Using Macros
Adding Records to a Table
Sorting and Filtering
An Introduction to VBA
Importing and Exporting Records
Database Wellness
Aggregation Queries
Creating and Using Forms
Modifying Forms
Working With Records
Email us about this courses
Other Chester Enable Technology Training Courses
Data Warehouse Chester Training Courses
VBA Chester Training Courses
SSRS Chester Training Courses
Excel 365 Intermediate Chester Training Courses
Power BI - Chester Microsoft Power BI Training Courses
Oracle SQL Chester Training Courses