ACCESS TRAINING COURSES PRESTON
About Enable Technology Preston Access Training Courses
Enable Technology specialise in succinct skills based Access training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. 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.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Another option is we can organise a local socially distanced training site in Preston. We are happy to discuss customising the course content should you have particular Access training requirements.
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.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are Fujistu PLC, Wolverhampton City Council, Countrywide Homes Limited, Barclays Bank PLC, West Bromwich Building Society, Halfords Group PLC, University of Birmingham and Yell Group PLC.
Microsoft Access
- 2 day course
- Location: Preston
- Telephone on 01952 938014
- Course Outline
-
This two day intensive Enable Technology course cover working with Microsoft Access forms, tables, queries and reports. Candidates will learn both how to build a Microsoft Access databases to store company information and produce automated reports that filter and aggregate data.
- Some of the training topics covered include ... Calculations in Queries
- See Training Course Details...
Creating a Lookup Database
Parameter Queries
Database Security
Working With Records
Creating and Using Reports
Action Queries
DIY Forms
Modifying Table Structures
Getting to Know Access
Sorting and Filtering
Macro Techniques
Aggregation Queries
Setting Table Relationships
Formatting Tables
Creating and Using Macros
An Introduction to VBA
Navigation Pane Protection
Using a Navigation Form
Importing and Exporting Records
Relational Database Design
Microsoft Access Programming Using VBA
- 3 day course
- Location: Preston
- 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 ... Understanding the Order of Events
- See Training Course Details...
Using Expressions, Variables, and Intrinsic Functions
Creating a Sub Procedure
Working with Methods
Using the If...End If Decision Structures
Organizing Code and Procedures
Introduction to Programming in Access
Writing an Error-Handling Routine
Specifying a Recordset Cursor Location - Optional
Understanding VBA's Error Trapping Options
Understanding the Err Object
Working with Inline Error Handling
Creating a Function Procedure
Working with Variable Lifetime
Understanding Procedures
Using Input Boxes
Declaring Variables
Understanding Constants
Using the CacheSize Property - Optional
Email us about this courses
Other Preston Enable Technology Training Courses
SQL - Preston SQL Training Courses
VBA Preston Training Courses
JQuery Mobile Preston Training Courses
Oracle SQL Preston Training Courses
SSAS - Preston SQL Server Analysis Services Training Courses
SSRS - Preston SQL Server Reporting Services Training Courses