ACCESS TRAINING COURSES SUNDERLAND
About Enable Technology Sunderland Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every person attending a Access course will be provided with training materials and practice files to retain after the course. It is our policy to support delegates apply their new skill after the course. All candidate will be able to contact the course Tutor for as long as they feel they need help.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We can set up a training lab at your premises and deliver Access courses onsite at your site. We are also more than happy to organise a local course at a training location in Sunderland. All Access courses can be customised to meet your particular 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
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are Royal & Sun Alliance Group PLC, South Staffordshire Water PLC, Norfolk Police Constabulary, Wolverhampton City Council, Nationwide Building Society Limited, Homeserve PLC, Countrywide Homes Limited and Vodafone Group Services.
Microsoft Access
- 2 day course
- Location: Sunderland
- 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 ... Formatting Tables
- See Training Course Details...
Understanding VBA
Creating Queries
Adding Records to a Table
Aggregation Queries
Adding Transactional Records
Getting to Know Access
Querying Techniques
Action Queries
Importing and Exporting Records
Designing a Lookup Database
Working With Records
An Introduction to VBA
Navigation Pane Protection
DIY Forms
Database Wellness
Macro Techniques
Calculations in Queries
Setting Table Relationships
Modifying Table Structures
Creating and Using Reports
Microsoft Access Programming Using VBA
- 3 day course
- Location: Sunderland
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Understanding the Err Object
- See Training Course Details...
Using Break Mode during Run Mode
Determining the Value of Expressions
Organizing Code and Procedures
Working with Boolean Expressions
Considering Variable Scope and Lifetime Together
Using Intrinsic Constants
Working with the Application Object
Using the With Statement
Understanding the Form Object
Working with Properties
Understanding Data Types
Understanding Errors
Using the Immediate Window to Call Procedures
Understanding Constants
Understanding Classes and Objects
Naming Procedures
Navigating the Access Object Hierarchy
Understanding Collections
Email us about this courses
Other Sunderland Enable Technology Training Courses
JQuery - Sunderland JavaScript Training Courses
SSIS Sunderland Training Courses
PL/SQL Sunderland Training Courses
DAX - Sunderland Excel Training Courses
Report Builder Sunderland Training Courses
JQuery Mobile Sunderland Training Courses