ACCESS TRAINING COURSES SCUNTHORPE
About Enable Technology Scunthorpe 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. Every person attending a Access course will be provided with training materials and practice files to retain after the course. 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.
Access courses are taught by a Microsoft Certified Solutions Expert. 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 socially distanced training location in Scunthorpe. We are happy to discuss customising the course content should you have particular Access 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 guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Homeserve PLC, Loughborough University, Barclays Bank PLC, Unipart Group, Norwich Union PLC, Birmingham City Council, Nuclear Engineering Services and Royal & Sun Alliance Group PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Scunthorpe
- 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 Recordsets
- See Training Course Details...
Using the Do...Loop Structure
Creating a Function Procedure
Setting Break Expressions
Using the Object Browser
Using the With Statement
Using the Select Case...End Select Structure
Using Intrinsic Constants
Using Break Mode during Run Mode
Stepping through Code
Writing an Error-Handling Routine
Using the CacheSize Property - Optional
Organizing Code and Procedures
Understanding Errors
Guidelines for use of Branching Structures
Handling Errors
Understanding Objects
Understanding the Development Environment
Understanding Constants
Microsoft Access
- 2 day course
- Location: Scunthorpe
- 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 ... Working With Records
- See Training Course Details...
Macro Techniques
Using a Navigation Form
Data Validation
Relational Database Design
Navigation Pane Protection
Creating a Lookup Database
An Introduction to VBA
Setting Table Relationships
Creating a Relational Database
Calculations in Queries
Creating and Using Macros
Modifying Table Structures
Action Queries
Creating Queries
Getting to Know Access
Understanding VBA
Importing and Exporting Records
Modifying Forms
Parameter Queries
DIY Forms
Email us about this courses
Other Scunthorpe Enable Technology Training Courses
Power Query Scunthorpe Training Courses
Excel 365 Advanced Scunthorpe Training Courses
TSQL Scunthorpe Training Courses
JQuery Scunthorpe Training Courses
PL/SQL Scunthorpe Training Courses
SSRS - Scunthorpe SQL Server Reporting Services Training Courses