ACCESS TRAINING COURSES DORCHESTER
About Enable Technology Dorchester Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and Access course resources that can be referenced post training. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. 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 Dorchester. 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.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
We have operated primarily in the West Midlands for twenty years. Our clients include: Loughborough University, Unipart Group, Cadbury PLC, Nuclear Engineering Services, Birmingham Heartlands Hospital, Fujistu PLC, Vodafone Group Services and Carillion PLC.
Microsoft Access
- 2 day course
- Location: Dorchester
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Parameter Queries
- See Training Course Details...
Using a Navigation Form
Creating a Relational Database
Setting Table Relationships
Modifying Forms
Database Security
Calculations in Queries
Querying Techniques
Understanding VBA
Creating and Using Reports
Macros on Forms
An Introduction to VBA
Data Validation
Formatting Tables
Multi Table Queries
Importing and Exporting Records
Adding Transactional Records
Creating Queries
Sorting and Filtering
Working With Records
Designing a Lookup Database
Microsoft Access Programming Using VBA
- 3 day course
- Location: Dorchester
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Working with Boolean Expressions
- See Training Course Details...
Using Visual Basic Help
Understanding VBA's Error Trapping Options
Using Input Boxes
Using Debugging Tools
Controlling Program Execution
Using the Select Case...End Select Structure
Understanding Modules
Using Intrinsic Functions
Understanding Constants
Understanding Classes and Objects
Understanding Errors
Setting Break Expressions
Trapping Errors with the On Error Statement
Declaring and Creating Object Variables
Using the For Each...Next Structure
Naming Procedures
Working with Inline Error Handling
Working with Properties
Email us about this courses
Other Dorchester Enable Technology Training Courses
Excel Power Pivot - Dorchester Excel Training Courses
Power BI Dorchester Training Courses
SSRS - Dorchester SQL Server Reporting Services Training Courses
SSAS - Dorchester SQL Server Analysis Services Training Courses
PL/SQL Dorchester Training Courses
Report Builder - Dorchester SQL Server Reporting Services Training Courses