ACCESS TRAINING COURSES DERBY
About Enable Technology Derby Access Training Courses
We are company which specialises in short, two and three day intensive Access technology training 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. 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 Access training courses can be delivered at your offices. We can supply the necessary software and computers. We can also deliver the Access course at a local training venue in Derby. We are happy to modify the Access syllabus to match your teams training 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. Some of our clients are Shell UK Oil Products Ltd, Norwich Union PLC, University of Birmingham, DHL Express, TalkTalk Direct Limited, Birmingham City University, Birmingham Heartlands Hospital and Barclays Bank PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Derby
- 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 ... Creating a Sub Procedure
- See Training Course Details...
Navigating the Access Object Hierarchy
Using Expressions, Variables, and Intrinsic Functions
Guidelines for use of Branching Structures
Setting Breakpoints
Working with Methods
Creating a Standard Module
Trapping Errors with the On Error Statement
Naming Procedures
Working with Variable Scope
Understanding Expressions and Statements
Working with the Application Object
Specifying a Recordset Cursor Type
Understanding Classes and Objects
Understanding Constants
Working with the ADODB Recordset Object
Understanding Data Types
Setting Break Expressions
Debugging Code
Using Visual Basic Help
Using the If...End If Decision Structures
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 ... Data Validation
- See Training Course Details...
Creating and Using Macros
Querying Techniques
Creating a Relational Database
Modifying Table Structures
Formatting Tables
Understanding VBA
Parameter Queries
Macro Techniques
Calculations in Queries
Aggregation Queries
Navigation Pane Protection
Creating a Lookup Database
Sorting and Filtering
Designing a Lookup Database
Modifying Forms
Adding Records to a Table
Database Wellness
Relational Database Design
Creating and Using Forms
Multi Table Queries
Email us about this courses
Other Derby Enable Technology Training Courses
SSRS Derby Training Courses
Data Warehouse Derby Training Courses
SQL Derby Training Courses
DAX Derby Training Courses
Power Query - Derby Excel Training Courses
SSAS Tabular Derby Training Courses