ACCESS TRAINING COURSES DERBY
About Enable Technology Derby Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We can deliver at your premises. We can provide the equipment. Alternatively we could schedule a course at a local socially distanced venue in Derby. All Access courses can be customised to meet your particular 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.
We have operated primarily in the West Midlands for twenty years. Our clients include: Capita Group PLC, West Bromwich Building Society, Queen's Medical Centre Nottingham, Barclays Bank PLC, Cadbury PLC, Norwich Union PLC, EDF Energy PLC and Birmingham Heartlands Hospital.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Derby
- 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 ... Creating a Standard Module
- See Training Course Details...
Using the If...End If Decision Structures
Writing an Error-Handling Routine
Navigating the Access Object Hierarchy
Working with Events
Using the Object Browser
Working with the ADODB Recordset Object
Understanding Objects
Understanding Errors
Working with Methods
Why Program in Access?
Using the Immediate Window to Call Procedures
Using Debugging Tools
Understanding Data Types
Understanding the Form Object
Using the With Statement
Using Expressions, Variables, and Intrinsic Functions
Microsoft Access
- 2 day course
- Location: Derby
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Creating a Relational Database
- See Training Course Details...
Adding Transactional Records
Modifying Forms
DIY Forms
Creating Queries
Understanding VBA
Working With Records
Multi Table Queries
Creating and Using Macros
Using a Navigation Form
Macro Techniques
Database Security
Designing a Lookup Database
Calculations in Queries
Querying Techniques
Importing and Exporting Records
Sorting and Filtering
Action Queries
Setting Table Relationships
An Introduction to VBA
Relational Database Design
Email us about this courses
Other Derby Enable Technology Training Courses
SSAS Tabular - Derby SQL Server Analysis Services Training Courses
Excel Power Pivot Derby Training Courses
Data Warehouse Derby Training Courses
TSQL - Derby SQL Training Courses
JavaScript Derby Training Courses
Power BI Derby Training Courses