ACCESS TRAINING COURSES KENILWORTH
About Enable Technology Kenilworth Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). We will issue each Access training participant with learning resources which they can refer to post training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Enable Technology offers instructor led training taught by technology specialists. We can deliver at your premises. We can provide the equipment. If delivery onsite is an issue we will organise a socially distanced venue near you in Kenilworth. We are happy to discuss customising the course content should you have particular Access training requirements.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Norwich Union PLC, Dollond & Aitchison Limited, Carillion PLC, Wolverhampton City Council, Birmingham City University, Homeserve PLC, Aston University and Capita Group PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Kenilworth
- 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 Errors
- See Training Course Details...
Why Program in Access?
Calling Procedures
Creating a Function Procedure
Using Intrinsic Constants
Using Visual Basic Help
Organizing Code and Procedures
Understanding Collections
Understanding Modules
Working with Procedures and Functions
Understanding the DoCmd Object
Determining the Value of Expressions
Specifying a Recordset Cursor Location - Optional
Naming Procedures
Understanding Procedures
Declaring Variables
Working with Boolean Expressions
Using the For Each...Next Structure
Working with Properties
Working with Variable Lifetime
Working with the ADODB Recordset Object
Microsoft Access
- 2 day course
- Location: Kenilworth
- 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...
Working With Records
Aggregation Queries
An Introduction to VBA
Adding Records to a Table
Creating and Using Reports
Creating a Relational Database
Creating and Using Forms
Database Security
Data Validation
Macro Techniques
Creating a Lookup Database
Using a Navigation Form
Getting to Know Access
Querying Techniques
Setting Table Relationships
Formatting Tables
DIY Forms
Action Queries
Calculations in Queries
Creating Queries
Email us about this courses
Other Kenilworth Enable Technology Training Courses
SQL Kenilworth Training Courses
Excel Power Pivot Kenilworth Training Courses
JQuery - Kenilworth JavaScript Training Courses
SSRS - Kenilworth SQL Server Reporting Services Training Courses
Excel 365 Basic - Kenilworth Excel Training Courses
JavaScript - Kenilworth JavaScript Training Courses