ACCESS TRAINING COURSES CROSBY
About Enable Technology Crosby Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All Enable Technology tutors are Microsoft certified experts. We provide every candidate with Access training materials which they keep after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can bring the equipment necessary to deliver Access courses at your site. If you prefer we can offer an offsite training location in Crosby. The Access syllabus can be adjusted and additional topics incorporated if helpful.
We also deliver this course online. Delegates participate in a virtual Access class and can both talk to and share their screen with the tutor.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Fujistu PLC, Norfolk Police Constabulary, Lloyds TSB Bank PLC, TalkTalk Direct Limited, Shell UK Oil Products Ltd, Wolverhampton City Council, Capita Group PLC and Norwich Union PLC.
Microsoft Access
- 2 day course
- Location: Crosby
- 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 ... Creating a Relational Database
- See Training Course Details...
Aggregation Queries
Parameter Queries
Creating a Lookup Database
Calculations in Queries
Database Security
Relational Database Design
Navigation Pane Protection
Creating and Using Forms
Sorting and Filtering
DIY Forms
An Introduction to VBA
Getting to Know Access
Modifying Forms
Adding Transactional Records
Modifying Table Structures
Macros on Forms
Macro Techniques
Importing and Exporting Records
Creating and Using Reports
Action Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Crosby
- 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 ... Understanding Objects
- See Training Course Details...
Understanding Constants
Using the Do...Loop Structure
Using Intrinsic Constants
Naming Procedures
Using the Immediate Window to Call Procedures
Using Intrinsic Functions
Specifying a Recordset Cursor Location - Optional
Guidelines for use of Branching Structures
Using the With Statement
Using the For Each...Next Structure
Understanding the Order of Events
Understanding Recordset Cursor Properties - Optional
Understanding Classes and Objects
Using Message Boxes
Determining the Value of Expressions
Understanding Procedures
Declaring Variables
Email us about this courses
Other Crosby Enable Technology Training Courses
Power BI Crosby Training Courses
JQuery Mobile Crosby Training Courses
Power Query - Crosby Excel Training Courses
Excel 365 Intermediate Crosby Training Courses
VBA - Crosby Excel Training Courses
Excel Power Pivot - Crosby Excel Training Courses