ACCESS TRAINING COURSES NORTHWICH
About Enable Technology Northwich Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. All Enable Technology tutors are Microsoft certified experts. Every course participant will receives course practice files and Access course resources that can be referenced post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. We also offer the option of scheduling of Access course at a venue near you in Northwich. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
The Enable Technology group of companies has been operating continuously providing IT training since 1998. Some of our clients are West Bromwich Building Society, South Staffordshire Water PLC, Total Telecommunications Limited, GKN PLC, Royal & Sun Alliance Group PLC, Aston University, Nuclear Engineering Services and Yell Group PLC.
Microsoft Access
- 2 day course
- Location: Northwich
- 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 ... Adding Transactional Records
- See Training Course Details...
Adding Records to a Table
Macros on Forms
Creating and Using Reports
Aggregation Queries
Macro Techniques
Modifying Forms
Creating and Using Forms
Creating a Lookup Database
Multi Table Queries
Data Validation
Formatting Tables
Creating a Relational Database
Database Wellness
Modifying Table Structures
Importing and Exporting Records
Understanding VBA
Action Queries
DIY Forms
Calculations in Queries
Navigation Pane Protection
Microsoft Access Programming Using VBA
- 3 day course
- Location: Northwich
- 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 ... Working with Events
- See Training Course Details...
Using Intrinsic Constants
Creating a Function Procedure
Debugging Code
Controlling Program Execution
Working with Methods
Using the Select Case...End Select Structure
Using the For Each...Next Structure
Understanding Procedures
Working with the ADODB Recordset Object
Using Message Boxes
Understanding the Order of Events
Understanding the Err Object
Organizing Code and Procedures
Using the With Statement
Understanding Control-of-Flow Structures
Working with the Code Editor
Using the Object Browser
Using Expressions, Variables, and Intrinsic Functions
Locking Records for Updating
Email us about this courses
Other Northwich Enable Technology Training Courses
Excel Power Pivot - Northwich Excel Training Courses
SQL - Northwich SQL Training Courses
Power Query Northwich Training Courses
JavaScript Northwich Training Courses
DAX - Northwich Excel Training Courses
Excel 365 Advanced - Northwich Excel Training Courses