ACCESS TRAINING COURSES GATESHEAD
About Enable Technology Gateshead Access Training Courses
Enable Technology specialise in succinct skills based Access training. All Enable Technology tutors are Microsoft certified experts. Every course participant will receives course practice files and Access course resources that can be referenced post training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
Enable Technology offers instructor led training taught by technology specialists. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Another way we could deliver the Access course is at a local training site. Every Access course can be modified to meet your bespoke 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: TalkTalk Direct Limited, Royal & Sun Alliance Group PLC, GKN PLC, DHL Express, Fujistu PLC, Keele University, Birmingham City University and Lloyds TSB Bank PLC.
Microsoft Access
- 2 day course
- Location: Gateshead
- 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 ... Adding Records to a Table
- See Training Course Details...
Aggregation Queries
Working With Records
Creating and Using Reports
Data Validation
Action Queries
Creating Queries
Setting Table Relationships
Calculations in Queries
An Introduction to VBA
Adding Transactional Records
Creating and Using Macros
Creating and Using Forms
Database Wellness
Creating a Relational Database
Macro Techniques
Modifying Table Structures
Querying Techniques
Multi Table Queries
Understanding VBA
Sorting and Filtering
Microsoft Access Programming Using VBA
- 3 day course
- Location: Gateshead
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Understanding Modules
- See Training Course Details...
Working with Variable Lifetime
Working with the ADODB Recordset Object
Understanding Constants
Declaring Variables
Understanding Expressions and Statements
Debugging Code
Organizing Code and Procedures
Setting Break Expressions
Working with the Code Editor
Understanding Procedures
Setting Breakpoints
Working with Properties
Understanding Collections
Using the With Statement
Understanding the DoCmd Object
Writing an Error-Handling Routine
Working with Events
Understanding Data Types
Working with Inline Error Handling
Email us about this courses
Other Gateshead Enable Technology Training Courses
Oracle SQL Gateshead Training Courses
Excel 365 Advanced - Gateshead Excel Training Courses
TSQL - Gateshead SQL Training Courses
SQL - Gateshead SQL Training Courses
Data Warehouse - Gateshead SQL Training Courses
JQuery Gateshead Training Courses