ACCESS TRAINING COURSES WORCESTER
About Enable Technology Worcester Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant will receives course practice files and Access course resources that can be referenced post training. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Courses are instructor led and groups sizes small. We can bring the equipment necessary to deliver Access courses at your site. If you prefer we can offer an offsite socially distanced training location in Worcester. We will work with you prior to the course to tailor the Access syllabus to match your 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.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Homeserve PLC, Birmingham City University, Cadbury PLC, GKN PLC, Wolverhampton City Council, Norfolk Police Constabulary, Boots UK Limited and Vodafone Group Services.
Microsoft Access
- 2 day course
- Location: Worcester
- 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 ... Using a Navigation Form
- See Training Course Details...
Navigation Pane Protection
Macros on Forms
Aggregation Queries
Adding Records to a Table
Action Queries
Adding Transactional Records
Data Validation
Database Wellness
Understanding VBA
Sorting and Filtering
An Introduction to VBA
Creating and Using Reports
Creating Queries
Database Security
Parameter Queries
Modifying Table Structures
Relational Database Design
Querying Techniques
Modifying Forms
Formatting Tables
Microsoft Access Programming Using VBA
- 3 day course
- Location: Worcester
- 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 ... Stepping through Code
- See Training Course Details...
Organizing Code and Procedures
Setting Breakpoints
Considering Variable Scope and Lifetime Together
Trapping Errors with the On Error Statement
Specifying a Recordset Cursor Location - Optional
Creating a Function Procedure
Understanding Expressions and Statements
Understanding Data Types
Working with Boolean Expressions
Using the With Statement
Understanding the Development Environment
Using the CacheSize Property - Optional
Working with the Application Object
Understanding Constants
Understanding Objects
Understanding Recordset Cursor Properties - Optional
Working with Procedures and Functions
Using Input Boxes
Controlling Program Execution
Email us about this courses
Other Worcester Enable Technology Training Courses
Report Builder - Worcester SQL Server Reporting Services Training Courses
SSIS Worcester Training Courses
Excel 365 Basic - Worcester Excel Training Courses
DAX - Worcester Excel Training Courses
JQuery Worcester Training Courses
SSRS - Worcester SQL Server Reporting Services Training Courses