ACCESS TRAINING COURSES NEWCASTLE UNDER LYME
About Enable Technology Newcastle Under Lyme Access Training Courses
We offer intensive two and three days Access courses. All of our tutors are Microsoft Certified Professionals. We will issue each Access training participant with learning resources which they can refer to 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.
Enable Technology offers instructor led training taught by technology specialists. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We are also more than happy to organise a local course at a training location in Newcastle Under Lyme. We are happy to discuss customising the course content should you have particular Access training 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 two decades of delivering technical training predominantly in the West Midlands. Our clients include: Aston University, Countrywide Homes Limited, Royal & Sun Alliance Group PLC, Yell Group PLC, Dollond & Aitchison Limited, West Bromwich Building Society, Cadbury PLC and Capita Group PLC.
Microsoft Access
- 2 day course
- Location: Newcastle Under Lyme
- 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 ... Importing and Exporting Records
- See Training Course Details...
Modifying Forms
Creating and Using Reports
Understanding VBA
Creating a Lookup Database
Setting Table Relationships
Creating and Using Macros
Using a Navigation Form
Navigation Pane Protection
Calculations in Queries
Adding Transactional Records
Creating Queries
Querying Techniques
Working With Records
Designing a Lookup Database
Action Queries
Modifying Table Structures
Database Wellness
Parameter Queries
Aggregation Queries
DIY Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Newcastle Under Lyme
- 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 ... Handling Errors
- See Training Course Details...
Considering Variable Scope and Lifetime Together
Creating a Standard Module
Working with the Code Editor
Understanding Error Handling
Setting Breakpoints
Understanding Objects
Working with Inline Error Handling
Understanding Data Types
Understanding Classes and Objects
Working with Events
Specifying a Recordset Cursor Location - Optional
Understanding Collections
Using Visual Basic Help
Locking Records for Updating
Using the With Statement
Creating a Function Procedure
Using the Select Case...End Select Structure
Creating a Sub Procedure
Declaring Variables
Email us about this courses
Other Newcastle Under Lyme Enable Technology Training Courses
SSRS - Newcastle Under Lyme SQL Server Reporting Services Training Courses
SSAS Newcastle Under Lyme Training Courses
Report Builder Newcastle Under Lyme Training Courses
SSAS Tabular - Newcastle Under Lyme SQL Server Analysis Services Training Courses
Excel Power Pivot Newcastle Under Lyme Training Courses
JQuery Newcastle Under Lyme Training Courses