ACCESS TRAINING COURSES TORQUAY
About Enable Technology Torquay Access Training Courses
Enable Technology specialise in succinct skills based Access training. All of our tutors are Microsoft Certified Professionals. Every person attending a Access course will be provided with training materials and practice files to retain 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.
Enable Technology offers instructor led training taught by technology specialists. 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 way we could deliver the Access course is at a local training site. The Access syllabus can be adjusted and additional topics incorporated if helpful.
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: Lloyds TSB Bank PLC, Unipart Group, Fujistu PLC, Carillion PLC, Nuclear Engineering Services, Norfolk Police Constabulary, DHL Express and Halfords Group PLC.
Microsoft Access
- 2 day course
- Location: Torquay
- 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 ... Importing and Exporting Records
- See Training Course Details...
Setting Table Relationships
Formatting Tables
Creating a Relational Database
Relational Database Design
Creating Queries
Creating a Lookup Database
Creating and Using Reports
Database Security
Data Validation
Macros on Forms
Sorting and Filtering
Designing a Lookup Database
Database Wellness
An Introduction to VBA
Macro Techniques
Action Queries
Getting to Know Access
Calculations in Queries
Aggregation Queries
Navigation Pane Protection
Microsoft Access Programming Using VBA
- 3 day course
- Location: Torquay
- 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 Procedures and Functions
- See Training Course Details...
Understanding Error Handling
Understanding Collections
Understanding the Err Object
Navigating the Access Object Hierarchy
Understanding Objects
Specifying a Recordset Cursor Type
Handling Errors
Understanding the Development Environment
Understanding Constants
Working with Boolean Expressions
Working with the Code Editor
Setting Break Expressions
Using Visual Basic Help
Debugging Code
Creating a Function Procedure
Understanding the Order of Events
Understanding Expressions and Statements
Email us about this courses
Other Torquay Enable Technology Training Courses
Excel 365 Advanced - Torquay Excel Training Courses
JQuery Mobile - Torquay JavaScript Training Courses
PL/SQL - Torquay SQL Training Courses
Excel Power Pivot - Torquay Excel Training Courses
Oracle SQL - Torquay SQL Training Courses
JavaScript - Torquay JavaScript Training Courses