ACCESS TRAINING COURSES TROWBRIDGE
About Enable Technology Trowbridge Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The training will be delivered by a Microsoft professional with development experience. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. We offer a post training support service and delegates will have access to a Microsoft expert on Access for as long as they need.
Access courses are taught by a Microsoft Certified Solutions Expert. We can set up a training lab at your premises and deliver Access courses onsite at your site. If you prefer we can offer an offsite training location in Trowbridge. All Access courses can be customised to meet your particular requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
We guarantee you tutor will have at least twenty years of technical training experience. Our clients include: Wolverhampton City Council, Boots UK Limited, Canadian High Commission, Fujistu PLC, GKN PLC, Nuclear Engineering Services, Norfolk Police Constabulary and West Bromwich Building Society.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Trowbridge
- Telephone on 01952 938014
- Course Outline
-
This course introduces participants to programme using Visual Basic for Applications (VBA). We don't assume any prior programming background. Essentially candidates will learn how to create distributed scalable Access applications.
- Some of the training topics covered include ... Organizing Code and Procedures
- See Training Course Details...
Using Break Mode during Run Mode
Using the For Each...Next Structure
Using Intrinsic Constants
Using Message Boxes
Using the Select Case...End Select Structure
Working with Events
Understanding Errors
Working with Methods
Using Debugging Tools
Using Expressions, Variables, and Intrinsic Functions
Understanding Constants
Guidelines for use of Branching Structures
Understanding Objects
Setting Break Expressions
Using the For...Next Structure
Working with Variable Scope
Working with Variable Lifetime
Considering Variable Scope and Lifetime Together
Declaring Variables
Microsoft Access
- 2 day course
- Location: Trowbridge
- 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 ... Sorting and Filtering
- See Training Course Details...
Calculations in Queries
Creating a Lookup Database
Getting to Know Access
Modifying Table Structures
DIY Forms
Creating and Using Reports
Navigation Pane Protection
An Introduction to VBA
Database Security
Aggregation Queries
Creating and Using Forms
Action Queries
Macro Techniques
Creating Queries
Data Validation
Importing and Exporting Records
Working With Records
Adding Records to a Table
Understanding VBA
Formatting Tables
Email us about this courses
Other Trowbridge Enable Technology Training Courses
Power BI Trowbridge Training Courses
TSQL - Trowbridge SQL Training Courses
JQuery Trowbridge Training Courses
Excel 365 Intermediate Trowbridge Training Courses
PL/SQL Trowbridge Training Courses
Power Query - Trowbridge Excel Training Courses