ACCESS TRAINING COURSES FLINT
About Enable Technology Flint Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Everyone attending a Access course receives learning resources which also serves as a reference source after the course. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Enable Technology training courses are delivered as instructor led courses. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We also offer the option of scheduling of Access course at a venue near you in Flint. All Access courses can be customised to meet your particular requirements.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Birmingham City University, Cadbury PLC, Barclays Bank PLC, Aston University, Boots UK Limited, Nuclear Engineering Services, TalkTalk Direct Limited and University of Birmingham.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Flint
- Telephone on 01952 938014
- Course Outline
-
This short intensive course teaches participants how to fully automate and extend the functionality of Microsoft Access. This programming course assumes no prior knowledge of Visual Basic for Applications (VBA). Delegates will learn how to build user defined functions, create sub procedures and connect remotely to external data sources.
- Some of the training topics covered include ... Using the For...Next Structure
- See Training Course Details...
Using the Object Browser
Using Input Boxes
Setting Break Expressions
Controlling Program Execution
Using the If...End If Decision Structures
Using Break Mode during Run Mode
Setting Breakpoints
Understanding Classes and Objects
Specifying a Recordset Cursor Location - Optional
Using Visual Basic Help
Why Program in Access?
Stepping through Code
Using Message Boxes
Using the Immediate Window to Call Procedures
Using Debugging Tools
Creating a Sub Procedure
Using Expressions, Variables, and Intrinsic Functions
Understanding VBA's Error Trapping Options
Microsoft Access
- 2 day course
- Location: Flint
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Database Wellness
- See Training Course Details...
Getting to Know Access
Creating and Using Macros
Modifying Forms
Importing and Exporting Records
Action Queries
Adding Records to a Table
Parameter Queries
Sorting and Filtering
DIY Forms
Database Security
Understanding VBA
Designing a Lookup Database
Calculations in Queries
Creating Queries
Relational Database Design
Modifying Table Structures
Querying Techniques
Formatting Tables
Navigation Pane Protection
Macros on Forms
Email us about this courses
Other Flint Enable Technology Training Courses
SSIS - Flint SQL Server Integration Services Training Courses
PL/SQL Flint Training Courses
Data Warehouse Flint Training Courses
Power Query - Flint Excel Training Courses
Oracle SQL - Flint SQL Training Courses
SSRS - Flint SQL Server Reporting Services Training Courses