ACCESS TRAINING COURSES BANGOR
About Enable Technology Bangor Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. We provide every candidate with Access training materials which they keep 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.
Courses are instructor led and groups sizes small. 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. Alternatively we could schedule a course at a local venue in Bangor. We are happy to modify the Access syllabus to match your teams 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.
The Enable group of companies has been delivering technical training principally in the Midlands region for twenty years. Some of our clients are Royal & Sun Alliance Group PLC, Barclays Bank PLC, University of Birmingham, Royal Air Force, Shell UK Oil Products Ltd, Keele University, Total Telecommunications Limited and Norwich Union PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bangor
- 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 Variable Scope
- See Training Course Details...
Introduction to Programming in Access
Calling Procedures
Specifying a Recordset Cursor Type
Specifying a Recordset Cursor Location - Optional
Understanding Modules
Trapping Errors with the On Error Statement
Using the For Each...Next Structure
Understanding Control-of-Flow Structures
Working with Properties
Setting Breakpoints
Understanding Expressions and Statements
Using the Select Case...End Select Structure
Understanding Data Types
Considering Variable Scope and Lifetime Together
Debugging Code
Understanding Collections
Understanding Procedures
Understanding Constants
Microsoft Access
- 2 day course
- Location: Bangor
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Sorting and Filtering
- See Training Course Details...
Querying Techniques
Getting to Know Access
Relational Database Design
Multi Table Queries
Parameter Queries
Database Wellness
Creating and Using Macros
Creating a Lookup Database
Adding Transactional Records
Data Validation
Macros on Forms
Designing a Lookup Database
Creating and Using Reports
Understanding VBA
Navigation Pane Protection
Adding Records to a Table
Importing and Exporting Records
Creating Queries
Action Queries
Creating and Using Forms
Email us about this courses
Other Bangor Enable Technology Training Courses
Excel 365 Advanced Bangor Training Courses
SQL Bangor Training Courses
TSQL Bangor Training Courses
JQuery Bangor Training Courses
SSAS Tabular Bangor Training Courses
VBA Bangor Training Courses