ACCESS TRAINING COURSES COVENTRY
About Enable Technology Coventry Access Training Courses
We have a twenty year history of providing skills based Access industry training. The course will always be taught by a Microsoft Certified Professional (MCP). Each person attending a course takes away Access courseware which can be used as reference materials after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. Another option is we can organise a local training site in Coventry. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
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.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: South Staffordshire Water PLC, University of Birmingham, Countrywide Homes Limited, DHL Express, Queen's Medical Centre Nottingham, Loughborough University, Keele University and Lloyds TSB Bank PLC.
Microsoft Access
- 2 day course
- Location: Coventry
- 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 ... Creating and Using Forms
- See Training Course Details...
Adding Transactional Records
Database Security
Adding Records to a Table
Multi Table Queries
Working With Records
Getting to Know Access
Macros on Forms
Database Wellness
Parameter Queries
Creating Queries
Querying Techniques
Creating and Using Macros
Creating a Lookup Database
Action Queries
Using a Navigation Form
Modifying Forms
Macro Techniques
Data Validation
Designing a Lookup Database
Sorting and Filtering
Microsoft Access Programming Using VBA
- 3 day course
- Location: Coventry
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Calling Procedures
- See Training Course Details...
Understanding the Order of Events
Creating a Standard Module
Using Expressions, Variables, and Intrinsic Functions
Specifying a Recordset Cursor Location - Optional
Understanding Recordset Cursor Properties - Optional
Creating a Function Procedure
Using Intrinsic Functions
Understanding Data Types
Working with Properties
Creating a Sub Procedure
Working with Boolean Expressions
Determining the Value of Expressions
Writing an Error-Handling Routine
Understanding Objects
Using the With Statement
Considering Variable Scope and Lifetime Together
Declaring and Creating Object Variables
Trapping Errors with the On Error Statement
Why Program in Access?
Working with the Application Object
Email us about this courses
Other Coventry Enable Technology Training Courses
DAX Coventry Training Courses
VBA Coventry Training Courses
SQL Coventry Training Courses
Excel Power Pivot Coventry Training Courses
SSAS Tabular - Coventry SQL Server Analysis Services Training Courses
Excel 365 Advanced - Coventry Excel Training Courses