ACCESS TRAINING COURSES SALISBURY
About Enable Technology Salisbury Access Training Courses
Enable Technology provides practical Access skills based technology training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. Each course participant will be issued with training Access resources which they can continue to use after the training. 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 offers instructor led training taught by technology specialists. Enable Technology can supply all of the equipment necessary to deliver Access courses onsite at your offices. You simply need to provide a suitable room. We are also more than happy to organise a local course at a training location in Salisbury. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.
This instructor led Access training is also available online. Participants can see the tutors screen, ask questions 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. Our clients include: Carillion PLC, Aston University, TalkTalk Direct Limited, South Staffordshire Water PLC, Norfolk Police Constabulary, Birmingham City University, Keele University and Vodafone Group Services.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Salisbury
- 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 ... Creating a Standard Module
- See Training Course Details...
Using Expressions, Variables, and Intrinsic Functions
Using the With Statement
Using the Select Case...End Select Structure
Using the For...Next Structure
Trapping Errors with the On Error Statement
Working with Properties
Naming Procedures
Using Message Boxes
Navigating the Access Object Hierarchy
Understanding Modules
Specifying a Recordset Cursor Type
Using the Immediate Window to Call Procedures
Understanding Expressions and Statements
Organizing Code and Procedures
Why Program in Access?
Working with Procedures and Functions
Using Input Boxes
Understanding Data Types
Microsoft Access
- 2 day course
- Location: Salisbury
- 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 ... Getting to Know Access
- See Training Course Details...
Setting Table Relationships
Data Validation
Database Security
Creating and Using Macros
Modifying Forms
Relational Database Design
Calculations in Queries
Adding Records to a Table
Sorting and Filtering
DIY Forms
Designing a Lookup Database
Querying Techniques
Macro Techniques
Modifying Table Structures
Understanding VBA
Creating Queries
Aggregation Queries
Working With Records
Adding Transactional Records
Creating and Using Reports
Email us about this courses
Other Salisbury Enable Technology Training Courses
JQuery - Salisbury JavaScript Training Courses
Excel Power Pivot - Salisbury Excel Training Courses
Excel 365 Advanced Salisbury Training Courses
JQuery Mobile Salisbury Training Courses
VBA Salisbury Training Courses
Report Builder - Salisbury SQL Server Reporting Services Training Courses