ACCESS TRAINING COURSES OSWESTRY
About Enable Technology Oswestry Access Training Courses
Enable Technology specialise in succinct skills based Access training. 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. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a Access course at an alternative training site in Oswestry. Every Access course can be modified to meet your bespoke requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
We have operated primarily in the West Midlands for twenty years. Our clients include: Cadbury PLC, Total Telecommunications Limited, Barclays Bank PLC, Countrywide Homes Limited, Wolverhampton City Council, Canadian High Commission, Norwich Union PLC and Halfords Group PLC.
Microsoft Access
- 2 day course
- Location: Oswestry
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... DIY Forms
- See Training Course Details...
Designing a Lookup Database
Setting Table Relationships
Creating a Lookup Database
Adding Transactional Records
Importing and Exporting Records
Creating and Using Reports
An Introduction to VBA
Macros on Forms
Aggregation Queries
Data Validation
Creating Queries
Working With Records
Understanding VBA
Parameter Queries
Modifying Forms
Modifying Table Structures
Multi Table Queries
Database Wellness
Creating a Relational Database
Sorting and Filtering
Microsoft Access Programming Using VBA
- 3 day course
- Location: Oswestry
- 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 ... Working with Properties
- See Training Course Details...
Calling Procedures
Working with Boolean Expressions
Guidelines for use of Branching Structures
Using Intrinsic Functions
Organizing Code and Procedures
Introduction to Programming in Access
Understanding Recordset Cursor Properties - Optional
Using Debugging Tools
Understanding Expressions and Statements
Using the Select Case...End Select Structure
Understanding Classes and Objects
Working with Variable Scope
Understanding Constants
Naming Procedures
Navigating the Access Object Hierarchy
Understanding Data Types
Handling Errors
Why Program in Access?
Determining the Value of Expressions
Email us about this courses
Other Oswestry Enable Technology Training Courses
SSRS - Oswestry SQL Server Reporting Services Training Courses
SQL Oswestry Training Courses
Power BI - Oswestry Microsoft Power BI Training Courses
Oracle SQL - Oswestry SQL Training Courses
JQuery Mobile Oswestry Training Courses
SSIS - Oswestry SQL Server Integration Services Training Courses