ACCESS TRAINING COURSES EVESHAM
About Enable Technology Evesham Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The tutor delivering the course will be a Microsoft certified expert. Each course participant will be issued with training Access resources which they can continue to use after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Courses are instructor led and groups sizes small. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a Access course at an alternative training site in Evesham. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Shell UK Oil Products Ltd, Birmingham City Council, Dollond & Aitchison Limited, Boots UK Limited, University of Birmingham, Lloyds TSB Bank PLC, Loughborough University and Royal & Sun Alliance Group PLC.
Microsoft Access
- 2 day course
- Location: Evesham
- Telephone on 01952 938014
- 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 ... Parameter Queries
- See Training Course Details...
Macro Techniques
Formatting Tables
Multi Table Queries
Creating and Using Macros
Modifying Table Structures
Calculations in Queries
Data Validation
Sorting and Filtering
Adding Records to a Table
DIY Forms
Creating a Relational Database
Creating and Using Forms
Database Security
Designing a Lookup Database
Macros on Forms
Querying Techniques
Setting Table Relationships
Importing and Exporting Records
Action Queries
Creating and Using Reports
Microsoft Access Programming Using VBA
- 3 day course
- Location: Evesham
- 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 Constants
- See Training Course Details...
Guidelines for use of Branching Structures
Declaring Variables
Controlling Program Execution
Using Expressions, Variables, and Intrinsic Functions
Specifying a Recordset Cursor Type
Using the CacheSize Property - Optional
Debugging Code
Understanding the DoCmd Object
Using Input Boxes
Considering Variable Scope and Lifetime Together
Working with Variable Lifetime
Understanding Collections
Understanding Objects
Understanding Recordset Cursor Properties - Optional
Working with the Code Editor
Navigating the Access Object Hierarchy
Specifying a Recordset Cursor Location - Optional
Email us about this courses
Other Evesham Enable Technology Training Courses
SSAS Tabular Evesham Training Courses
DAX - Evesham Excel Training Courses
VBA Evesham Training Courses
Excel 365 Intermediate - Evesham Excel Training Courses
Excel 365 Advanced - Evesham Excel Training Courses
Data Warehouse Evesham Training Courses