ACCESS TRAINING COURSES LEICESTER
About Enable Technology Leicester Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant is given Access courseware which they can refer to after the training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We can deliver at your premises. We can provide the equipment. Another way we could deliver the Access course is at a local socially distanced training site. The Access syllabus can be modified to accommodate your specific training needs.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
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, Aston University, Nationwide Building Society Limited, University of Birmingham, TalkTalk Direct Limited, Lloyds TSB Bank PLC and Fujistu PLC.
Microsoft Access
- 2 day course
- Location: Leicester
- 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 ... Aggregation Queries
- See Training Course Details...
Using a Navigation Form
Importing and Exporting Records
Multi Table Queries
Getting to Know Access
Modifying Forms
Database Security
Relational Database Design
Data Validation
Creating Queries
Creating and Using Macros
Action Queries
Designing a Lookup Database
Understanding VBA
Querying Techniques
Formatting Tables
Calculations in Queries
Navigation Pane Protection
An Introduction to VBA
Database Wellness
Creating and Using Reports
Microsoft Access Programming Using VBA
- 3 day course
- Location: Leicester
- 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 ... Working with the Application Object
- See Training Course Details...
Considering Variable Scope and Lifetime Together
Calling Procedures
Working with Variable Lifetime
Understanding Error Handling
Why Program in Access?
Understanding VBA's Error Trapping Options
Introduction to Programming in Access
Working with Properties
Working with the Code Editor
Using Visual Basic Help
Working with Boolean Expressions
Trapping Errors with the On Error Statement
Stepping through Code
Working with Variable Scope
Understanding the Order of Events
Understanding the Form Object
Naming Procedures
Understanding the Development Environment
Email us about this courses
Other Leicester Enable Technology Training Courses
VBA - Leicester Excel Training Courses
Excel 365 Intermediate - Leicester Excel Training Courses
DAX Leicester Training Courses
SSAS Tabular - Leicester SQL Server Analysis Services Training Courses
SSIS - Leicester SQL Server Integration Services Training Courses
Power BI - Leicester Microsoft Power BI Training Courses