ACCESS TRAINING COURSES NEWCASTLE UPON TYNE
About Enable Technology Newcastle Upon Tyne Access Training Courses
We are a company that provides short intensive Access training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every course participant will receives course practice files and Access course resources that can be referenced post training. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. Another way we could deliver the Access course is at a local socially distanced training site. Every Access course can be modified to meet your bespoke requirements.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
Our teaching team have over twenty years continuous technical training experience. Our clients include: Wolverhampton City Council, Capita Group PLC, National Power PLC, Queen's Medical Centre Nottingham, Unipart Group, Loughborough University, Birmingham Heartlands Hospital and South Staffordshire Water PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Newcastle Upon Tyne
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Understanding the Order of Events
- See Training Course Details...
Using Visual Basic Help
Using the Immediate Window to Call Procedures
Working with the ADODB Recordset Object
Using the For Each...Next Structure
Trapping Errors with the On Error Statement
Using Intrinsic Constants
Working with Variable Lifetime
Working with Variable Scope
Using Break Mode during Run Mode
Understanding Objects
Handling Errors
Understanding Classes and Objects
Understanding Errors
Stepping through Code
Writing an Error-Handling Routine
Using Message Boxes
Understanding Modules
Calling Procedures
Using Debugging Tools
Microsoft Access
- 2 day course
- Location: Newcastle Upon Tyne
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Database Security
- See Training Course Details...
Macros on Forms
Action Queries
Creating a Lookup Database
Modifying Forms
Relational Database Design
Creating and Using Macros
Multi Table Queries
Modifying Table Structures
Formatting Tables
Macro Techniques
Creating and Using Reports
An Introduction to VBA
Creating and Using Forms
Using a Navigation Form
Data Validation
Adding Records to a Table
Creating a Relational Database
Setting Table Relationships
Getting to Know Access
Aggregation Queries
Email us about this courses
Other Newcastle Upon Tyne Enable Technology Training Courses
DAX - Newcastle Upon Tyne Excel Training Courses
JavaScript - Newcastle Upon Tyne JavaScript Training Courses
Report Builder Newcastle Upon Tyne Training Courses
Excel 365 Advanced - Newcastle Upon Tyne Excel Training Courses
Power BI - Newcastle Upon Tyne Microsoft Power BI Training Courses
SSAS Tabular Newcastle Upon Tyne Training Courses