ACCESS TRAINING COURSES WARWICK
About Enable Technology Warwick Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. We guarantee the training will be delivered by a Microsoft certified expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
We specialise in instructor led teaching with small groups. The training is hands on and delegates will practice the skills they acquire. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. We are also more than happy to organise a local course at a training location in Warwick. We are happy to discuss customising the course content should you have particular Access training requirements.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions and share their screen with the tutor.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: TalkTalk Direct Limited, Halfords Group PLC, Canadian High Commission, Vodafone Group Services, DHL Express, Unipart Group, Total Telecommunications Limited and Loughborough University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Warwick
- 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 ... Introduction to Programming in Access
- See Training Course Details...
Understanding Collections
Understanding the DoCmd Object
Guidelines for use of Branching Structures
Specifying a Recordset Cursor Type
Declaring and Creating Object Variables
Understanding Expressions and Statements
Understanding Error Handling
Working with the ADODB Recordset Object
Why Program in Access?
Working with Events
Creating a Standard Module
Using Intrinsic Constants
Understanding Modules
Using the If...End If Decision Structures
Understanding Data Types
Working with Methods
Considering Variable Scope and Lifetime Together
Using Break Mode during Run Mode
Microsoft Access
- 2 day course
- Location: Warwick
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Action Queries
- See Training Course Details...
Setting Table Relationships
Aggregation Queries
Database Security
Parameter Queries
Creating a Lookup Database
Creating and Using Reports
Modifying Forms
Modifying Table Structures
Database Wellness
Macros on Forms
Creating a Relational Database
Adding Transactional Records
Importing and Exporting Records
Designing a Lookup Database
Macro Techniques
DIY Forms
Data Validation
Formatting Tables
Working With Records
Sorting and Filtering
Email us about this courses
Other Warwick Enable Technology Training Courses
SSAS Warwick Training Courses
Excel 365 Advanced Warwick Training Courses
TSQL Warwick Training Courses
PL/SQL - Warwick SQL Training Courses
SQL Warwick Training Courses
Excel Power Pivot - Warwick Excel Training Courses