ACCESS TRAINING COURSES BLACKPOOL
About Enable Technology Blackpool Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and Access course resources that can be referenced post training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Courses are instructor led and groups sizes small. We can set up a training lab at your premises and deliver Access courses onsite at your site. We are also more than happy to organise a local course at a training location in Blackpool. The Access syllabus can be modified to accommodate your specific training needs.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
We have operated primarily in the West Midlands for twenty years. Some of our clients are Yell Group PLC, Capita Group PLC, Royal Air Force, University of Birmingham, Fujistu PLC, Queen's Medical Centre Nottingham, Lloyds TSB Bank PLC and Vodafone Group Services.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Blackpool
- 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 ... Understanding Collections
- See Training Course Details...
Determining the Value of Expressions
Working with the Application Object
Declaring Variables
Using Visual Basic Help
Using the CacheSize Property - Optional
Working with Variable Scope
Considering Variable Scope and Lifetime Together
Working with Inline Error Handling
Understanding Errors
Using Expressions, Variables, and Intrinsic Functions
Using the For Each...Next Structure
Understanding Error Handling
Understanding Objects
Understanding Modules
Working with Recordsets
Creating a Function Procedure
Stepping through Code
Working with Variable Lifetime
Microsoft Access
- 2 day course
- Location: Blackpool
- 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 ... Creating a Lookup Database
- See Training Course Details...
Importing and Exporting Records
An Introduction to VBA
Modifying Forms
Formatting Tables
Database Wellness
Understanding VBA
Creating and Using Macros
Calculations in Queries
Creating and Using Forms
Macro Techniques
Working With Records
Action Queries
Setting Table Relationships
Modifying Table Structures
Creating Queries
Navigation Pane Protection
Sorting and Filtering
Querying Techniques
Multi Table Queries
Macros on Forms
Email us about this courses
Other Blackpool Enable Technology Training Courses
JQuery Blackpool Training Courses
Excel 365 Advanced - Blackpool Excel Training Courses
SSIS - Blackpool SQL Server Integration Services Training Courses
PL/SQL Blackpool Training Courses
Report Builder - Blackpool SQL Server Reporting Services Training Courses
TSQL - Blackpool SQL Training Courses