ACCESS TRAINING COURSES UTTOXETER
About Enable Technology Uttoxeter Access Training Courses
We have a twenty year history of providing skills based Access industry training. All Enable Technology tutors are Microsoft certified experts. Each course participant will be issued with training Access resources which they can continue to use after the training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We can set up a training lab at your premises and deliver Access courses onsite at your site. Alternatively we could schedule a course at a local venue in Uttoxeter. The Access syllabus can be modified to accommodate your specific training needs.
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 had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Vodafone Group Services, Norfolk Police Constabulary, Keele University, Nationwide Building Society Limited, Fujistu PLC, Wolverhampton City Council, Homeserve PLC and Yell Group PLC.
Microsoft Access
- 2 day course
- Location: Uttoxeter
- 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 ... Database Security
- See Training Course Details...
Sorting and Filtering
Adding Records to a Table
Creating and Using Reports
Querying Techniques
Navigation Pane Protection
Calculations in Queries
Adding Transactional Records
Importing and Exporting Records
Action Queries
Using a Navigation Form
Getting to Know Access
Database Wellness
Aggregation Queries
Creating and Using Macros
An Introduction to VBA
Designing a Lookup Database
Macro Techniques
Modifying Forms
Parameter Queries
Setting Table Relationships
Microsoft Access Programming Using VBA
- 3 day course
- Location: Uttoxeter
- 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 Variable Lifetime
- See Training Course Details...
Specifying a Recordset Cursor Type
Understanding Errors
Understanding the Err Object
Understanding Classes and Objects
Navigating the Access Object Hierarchy
Understanding the Form Object
Understanding the Development Environment
Declaring Variables
Using the Object Browser
Working with Variable Scope
Using Visual Basic Help
Understanding Constants
Determining the Value of Expressions
Considering Variable Scope and Lifetime Together
Using the CacheSize Property - Optional
Working with Properties
Using the With Statement
Setting Breakpoints
Working with Procedures and Functions
Email us about this courses
Other Uttoxeter Enable Technology Training Courses
Power Query Uttoxeter Training Courses
Data Warehouse Uttoxeter Training Courses
SSAS Uttoxeter Training Courses
Oracle SQL Uttoxeter Training Courses
PL/SQL Uttoxeter Training Courses
Excel 365 Intermediate Uttoxeter Training Courses