ACCESS TRAINING COURSES BIRMINGHAM
About Enable Technology Birmingham Access Training Courses
We are a company that provides short intensive Access training courses. All Enable Technology tutors are Microsoft certified experts. We provide every candidate with Access training materials which they keep after the course. 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.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. We also offer the option of scheduling of Access course at a socially distanced venue near you in Birmingham. We are happy to discuss customising the course content should you have particular Access 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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are Norfolk Police Constabulary, Royal Air Force, Nuclear Engineering Services, Queen's Medical Centre Nottingham, Total Telecommunications Limited, Aston University, Canadian High Commission and Wolverhampton City Council.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Birmingham
- 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 ... Debugging Code
- See Training Course Details...
Controlling Program Execution
Using Intrinsic Constants
Understanding Data Types
Locking Records for Updating
Naming Procedures
Creating a Sub Procedure
Using the For Each...Next Structure
Using Expressions, Variables, and Intrinsic Functions
Working with the Code Editor
Using the Immediate Window to Call Procedures
Understanding the Order of Events
Understanding Classes and Objects
Specifying a Recordset Cursor Location - Optional
Declaring and Creating Object Variables
Using the If...End If Decision Structures
Understanding the Err Object
Understanding Expressions and Statements
Understanding Control-of-Flow Structures
Microsoft Access
- 2 day course
- Location: Birmingham
- 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...
Database Security
Modifying Forms
Macro Techniques
Getting to Know Access
Importing and Exporting Records
Creating and Using Macros
Creating Queries
Database Wellness
Understanding VBA
Creating a Relational Database
Querying Techniques
Creating and Using Reports
Parameter Queries
Relational Database Design
Adding Records to a Table
Creating a Lookup Database
Action Queries
Adding Transactional Records
Macros on Forms
Setting Table Relationships
Email us about this courses
Other Birmingham Enable Technology Training Courses
SSRS - Birmingham SQL Server Reporting Services Training Courses
DAX Birmingham Training Courses
SSAS Tabular - Birmingham SQL Server Analysis Services Training Courses
Excel Power Pivot - Birmingham Excel Training Courses
TSQL - Birmingham SQL Training Courses
Excel 365 Advanced Birmingham Training Courses