ACCESS TRAINING COURSES BRIDGNORTH
About Enable Technology Bridgnorth Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. We guarantee the training will be delivered by a Microsoft certified expert. Every course participant will receives course practice files and Access course resources that can be referenced post training. Our policy is to provide open ended Access post training support to participants. This additional service is an important part ofhow we help people implement the skills they have learned in the workplace.
Our primary method of delivery is instructor led training coupled with practical hands on activities. We are set up to deliver Access training courses onsite at your premises. We are also more than happy to organise a local course at a socially distanced training location in Bridgnorth. We are more than happy to incorporate additional topics to accommodate your organisations Access training needs.
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.
In the Midlands the Enable Technology team have been providing technical training since 1998. Our clients include: Boots UK Limited, Unipart Group, Norfolk Police Constabulary, Yell Group PLC, Lloyds TSB Bank PLC, Canadian High Commission, Cadbury PLC and Barclays Bank PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Bridgnorth
- 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 If...End If Decision Structures
- See Training Course Details...
Trapping Errors with the On Error Statement
Using Message Boxes
Guidelines for use of Branching Structures
Working with Methods
Working with Procedures and Functions
Setting Break Expressions
Working with Variable Lifetime
Understanding Recordset Cursor Properties - Optional
Using Intrinsic Functions
Working with Boolean Expressions
Organizing Code and Procedures
Debugging Code
Understanding Modules
Using the With Statement
Using the For...Next Structure
Specifying a Recordset Cursor Type
Naming Procedures
Using Input Boxes
Microsoft Access
- 2 day course
- Location: Bridgnorth
- 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 ... Creating a Relational Database
- See Training Course Details...
Creating a Lookup Database
Aggregation Queries
Understanding VBA
Macros on Forms
Calculations in Queries
Importing and Exporting Records
Adding Transactional Records
Macro Techniques
Action Queries
Querying Techniques
Formatting Tables
Creating and Using Forms
DIY Forms
Sorting and Filtering
Working With Records
Modifying Table Structures
Navigation Pane Protection
Designing a Lookup Database
Parameter Queries
Database Security
Email us about this courses
Other Bridgnorth Enable Technology Training Courses
JQuery Mobile - Bridgnorth JavaScript Training Courses
Excel Power Pivot Bridgnorth Training Courses
SSAS Tabular Bridgnorth Training Courses
JavaScript Bridgnorth Training Courses
SSIS Bridgnorth Training Courses
Excel 365 Advanced Bridgnorth Training Courses