ACCESS TRAINING COURSES BOLTON
About Enable Technology Bolton Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The training will be delivered by a Microsoft professional with development experience. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
Access courses are taught by a Microsoft Certified Solutions Expert. 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. If delivery onsite is an issue we will organise a venue near you in Bolton. All Access courses can be customised to meet your particular requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Nationwide Building Society Limited, Birmingham City University, Total Telecommunications Limited, DHL Express, Norfolk Police Constabulary, Yell Group PLC, Keele University and TalkTalk Direct Limited.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bolton
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Using Expressions, Variables, and Intrinsic Functions
- See Training Course Details...
Using Visual Basic Help
Using the If...End If Decision Structures
Understanding the DoCmd Object
Setting Break Expressions
Writing an Error-Handling Routine
Navigating the Access Object Hierarchy
Working with Variable Lifetime
Why Program in Access?
Organizing Code and Procedures
Understanding the Development Environment
Using the CacheSize Property - Optional
Understanding Error Handling
Debugging Code
Using Break Mode during Run Mode
Understanding Errors
Using Message Boxes
Creating a Sub Procedure
Working with the ADODB Recordset Object
Guidelines for use of Branching Structures
Microsoft Access
- 2 day course
- Location: Bolton
- 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 Macros
- See Training Course Details...
Data Validation
Formatting Tables
Database Wellness
Understanding VBA
DIY Forms
Action Queries
Working With Records
Parameter Queries
Modifying Table Structures
Importing and Exporting Records
Macro Techniques
Navigation Pane Protection
Designing a Lookup Database
Modifying Forms
Adding Records to a Table
Database Security
Relational Database Design
Calculations in Queries
Querying Techniques
An Introduction to VBA
Email us about this courses
Other Bolton Enable Technology Training Courses
VBA Bolton Training Courses
Oracle SQL Bolton Training Courses
SSIS - Bolton SQL Server Integration Services Training Courses
Power BI - Bolton Microsoft Power BI Training Courses
DAX Bolton Training Courses
Report Builder - Bolton SQL Server Reporting Services Training Courses