ACCESS TRAINING COURSES CROSBY
About Enable Technology Crosby Access Training Courses
Enable Technology provides practical Access skills based technology training. The person delivering the course will be a Microsoft Solutions Expert (MCSE). 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. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. Another option is we can organise a local training site in Crosby. We are happy to modify the Access syllabus to match your teams 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 team have had two decades of experience delivering technical training mainly in the Midlands region. Some of our clients are South Staffordshire Water PLC, Homeserve PLC, West Bromwich Building Society, Royal Air Force, Birmingham Heartlands Hospital, Carillion PLC, Loughborough University and Total Telecommunications Limited.
Microsoft Access
- 2 day course
- Location: Crosby
- 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 ... Database Wellness
- See Training Course Details...
Creating a Lookup Database
Creating and Using Macros
Relational Database Design
Database Security
Macro Techniques
Creating and Using Forms
An Introduction to VBA
DIY Forms
Setting Table Relationships
Modifying Table Structures
Multi Table Queries
Calculations in Queries
Getting to Know Access
Parameter Queries
Creating a Relational Database
Data Validation
Modifying Forms
Querying Techniques
Using a Navigation Form
Understanding VBA
Microsoft Access Programming Using VBA
- 3 day course
- Location: Crosby
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Understanding Constants
- See Training Course Details...
Understanding Control-of-Flow Structures
Using the CacheSize Property - Optional
Locking Records for Updating
Using the Do...Loop Structure
Using Input Boxes
Understanding the DoCmd Object
Setting Breakpoints
Understanding Objects
Using the For Each...Next Structure
Using Visual Basic Help
Handling Errors
Working with Methods
Stepping through Code
Understanding Error Handling
Understanding Errors
Using the For...Next Structure
Working with the Application Object
Declaring and Creating Object Variables
Trapping Errors with the On Error Statement
Writing an Error-Handling Routine
Email us about this courses
Other Crosby Enable Technology Training Courses
Excel 365 Basic - Crosby Excel Training Courses
SSAS Tabular Crosby Training Courses
JQuery Crosby Training Courses
DAX - Crosby Excel Training Courses
JavaScript - Crosby JavaScript Training Courses
Data Warehouse - Crosby SQL Training Courses