ACCESS TRAINING COURSES NORTH EAST
About Enable Technology North East Access Training Courses
Enable Technology offer short intensive skills based Access training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Every course participant will receives course practice files and Access course resources that can be referenced post training. 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.
Courses are instructor led and groups sizes small. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. Alternatively we could schedule a Access course at an alternative training site in North East. We are happy to modify the Access syllabus to match your teams training requirements.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Our clients include: Barclays Bank PLC, Total Telecommunications Limited, Dollond & Aitchison Limited, West Bromwich Building Society, Shell UK Oil Products Ltd, Carillion PLC, Boots UK Limited and TalkTalk Direct Limited.
Microsoft Access
- 2 day course
- Location: North East
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Database Security
- See Training Course Details...
Macros on Forms
Adding Transactional Records
Database Wellness
Parameter Queries
Creating and Using Macros
Aggregation Queries
Getting to Know Access
Relational Database Design
An Introduction to VBA
Designing a Lookup Database
Using a Navigation Form
Creating a Lookup Database
Setting Table Relationships
Modifying Table Structures
Calculations in Queries
Modifying Forms
Data Validation
Macro Techniques
Querying Techniques
Multi Table Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: North East
- 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 ... Declaring Variables
- See Training Course Details...
Working with Variable Scope
Guidelines for use of Branching Structures
Using the Do...Loop Structure
Working with Procedures and Functions
Determining the Value of Expressions
Organizing Code and Procedures
Locking Records for Updating
Naming Procedures
Using the For Each...Next Structure
Using the If...End If Decision Structures
Calling Procedures
Working with Properties
Understanding the Development Environment
Understanding Control-of-Flow Structures
Trapping Errors with the On Error Statement
Using the With Statement
Understanding Data Types
Setting Breakpoints
Using Intrinsic Constants
Email us about this courses
Other North East Enable Technology Training Courses
SQL North East Training Courses
Data Warehouse North East Training Courses
Excel 365 Advanced North East Training Courses
DAX North East Training Courses
JQuery Mobile - North East JavaScript Training Courses
TSQL North East Training Courses