ACCESS TRAINING COURSES NEWCASTLE UPON TYNE
About Enable Technology Newcastle Upon Tyne Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Every course participant will receives course practice files and Access course resources that can be referenced post training. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Courses are instructor led and groups sizes small. We can deliver at your premises. We can provide the equipment. We also offer the option of scheduling of Access course at a venue near you in Newcastle Upon Tyne. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
The Enable Technology team have had two decades of experience delivering technical training mainly in the Midlands region. Our clients include: Vodafone Group Services, Total Telecommunications Limited, Aston University, GKN PLC, Norfolk Police Constabulary, Nationwide Building Society Limited, Carillion PLC and TalkTalk Direct Limited.
Microsoft Access
- 2 day course
- Location: Newcastle Upon Tyne
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Designing a Lookup Database
- See Training Course Details...
Adding Records to a Table
Creating and Using Forms
Data Validation
DIY Forms
Macro Techniques
Aggregation Queries
Sorting and Filtering
Calculations in Queries
Creating a Lookup Database
Creating and Using Reports
Action Queries
Adding Transactional Records
Using a Navigation Form
Macros on Forms
Modifying Table Structures
Creating a Relational Database
Getting to Know Access
Database Security
Database Wellness
Formatting Tables
Microsoft Access Programming Using VBA
- 3 day course
- Location: Newcastle Upon Tyne
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Understanding the Development Environment
- See Training Course Details...
Working with Methods
Writing an Error-Handling Routine
Setting Breakpoints
Understanding the Err Object
Setting Break Expressions
Introduction to Programming in Access
Understanding VBA's Error Trapping Options
Understanding Recordset Cursor Properties - Optional
Naming Procedures
Working with Recordsets
Debugging Code
Determining the Value of Expressions
Creating a Function Procedure
Working with Procedures and Functions
Using Break Mode during Run Mode
Stepping through Code
Email us about this courses
Other Newcastle Upon Tyne Enable Technology Training Courses
JQuery - Newcastle Upon Tyne JavaScript Training Courses
SSIS - Newcastle Upon Tyne SQL Server Integration Services Training Courses
DAX - Newcastle Upon Tyne Excel Training Courses
Data Warehouse Newcastle Upon Tyne Training Courses
SSAS - Newcastle Upon Tyne SQL Server Analysis Services Training Courses
Excel 365 Basic Newcastle Upon Tyne Training Courses