ACCESS TRAINING COURSES STRATFORD UPON AVON
About Enable Technology Stratford Upon Avon Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). All course participants are issued Access training manuals they can refer to after the course. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Access courses are taught by a Microsoft Certified Solutions Expert. We can set up a training lab at your premises and deliver Access courses onsite at your site. Alternatively we could schedule a Access course at an alternative training site in Stratford Upon Avon. We are happy to discuss customising the course content should you have particular Access training requirements.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Birmingham City University, Unipart Group, Loughborough University, Norfolk Police Constabulary, Royal Air Force, Carillion PLC, Canadian High Commission and Nuclear Engineering Services.
Microsoft Access
- 2 day course
- Location: Stratford Upon Avon
- 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 ... Setting Table Relationships
- See Training Course Details...
Working With Records
Creating Queries
Macros on Forms
Querying Techniques
Calculations in Queries
Formatting Tables
Modifying Table Structures
Sorting and Filtering
DIY Forms
Database Wellness
Understanding VBA
Action Queries
Creating and Using Macros
Relational Database Design
Creating a Relational Database
Adding Transactional Records
An Introduction to VBA
Designing a Lookup Database
Importing and Exporting Records
Data Validation
Microsoft Access Programming Using VBA
- 3 day course
- Location: Stratford Upon Avon
- 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 ... Understanding the Form Object
- See Training Course Details...
Using Break Mode during Run Mode
Using the Do...Loop Structure
Stepping through Code
Understanding Recordset Cursor Properties - Optional
Understanding the Err Object
Understanding Control-of-Flow Structures
Understanding Expressions and Statements
Declaring and Creating Object Variables
Specifying a Recordset Cursor Location - Optional
Navigating the Access Object Hierarchy
Understanding the Development Environment
Determining the Value of Expressions
Working with Variable Scope
Using the Object Browser
Setting Breakpoints
Debugging Code
Why Program in Access?
Working with Procedures and Functions
Naming Procedures
Email us about this courses
Other Stratford Upon Avon Enable Technology Training Courses
Power BI Stratford Upon Avon Training Courses
Excel 365 Advanced Stratford Upon Avon Training Courses
PL/SQL Stratford Upon Avon Training Courses
VBA - Stratford Upon Avon Excel Training Courses
Report Builder Stratford Upon Avon Training Courses
JavaScript - Stratford Upon Avon JavaScript Training Courses