ACCESS TRAINING COURSES SHREWSBURY
About Enable Technology Shrewsbury 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. 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 provide instructor led training coupled with hands on training. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a Access course at an alternative training site in Shrewsbury. We are happy to modify the Access syllabus to match your teams training requirements.
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.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Queen's Medical Centre Nottingham, Yell Group PLC, Capita Group PLC, National Power PLC, GKN PLC, Halfords Group PLC, Total Telecommunications Limited and Norfolk Police Constabulary.
Microsoft Access
- 2 day course
- Location: Shrewsbury
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Creating a Lookup Database
- See Training Course Details...
Macro Techniques
DIY Forms
Modifying Forms
Importing and Exporting Records
Relational Database Design
Adding Transactional Records
Formatting Tables
Using a Navigation Form
Calculations in Queries
Creating and Using Macros
Working With Records
Getting to Know Access
Navigation Pane Protection
Creating a Relational Database
Understanding VBA
Multi Table Queries
Sorting and Filtering
Setting Table Relationships
Macros on Forms
Action Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Shrewsbury
- 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 ... Working with the Code Editor
- See Training Course Details...
Understanding VBA's Error Trapping Options
Specifying a Recordset Cursor Type
Creating a Sub Procedure
Creating a Function Procedure
Using the For Each...Next Structure
Using the Immediate Window to Call Procedures
Understanding Control-of-Flow Structures
Using the Object Browser
Understanding Error Handling
Considering Variable Scope and Lifetime Together
Working with Boolean Expressions
Using Intrinsic Constants
Working with the ADODB Recordset Object
Working with the Application Object
Working with Properties
Working with Methods
Understanding Constants
Controlling Program Execution
Locking Records for Updating
Email us about this courses
Other Shrewsbury Enable Technology Training Courses
Power BI - Shrewsbury Microsoft Power BI Training Courses
SSAS Tabular - Shrewsbury SQL Server Analysis Services Training Courses
JavaScript Shrewsbury Training Courses
SSIS Shrewsbury Training Courses
Excel Power Pivot - Shrewsbury Excel Training Courses
DAX Shrewsbury Training Courses