ACCESS TRAINING COURSES BIRMINGHAM
About Enable Technology Birmingham Access Training Courses
Enable Technology provides practical Access skills based technology training. All training will be delivered by an appropriately qualified Microsoft Certified Solutions Expert. We will issue each Access training participant with learning resources which they can refer to post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We can also deliver the Access course at a local training venue in Birmingham. The Enable Technology approach is to discuss your requirements prior to the course. Every onsite Access course to some extent is bespoke and tailored to your needs.
Taught Access courses are also available online. Course participants can join a a virtual classroom. They can talk to the tutor, share their screen and watch the tutor demonstrate each topic.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: DHL Express, Wolverhampton City Council, Countrywide Homes Limited, Royal Air Force, Birmingham City University, Fujistu PLC, Norwich Union PLC and Nationwide Building Society Limited.
Microsoft Access
- 2 day course
- Location: Birmingham
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.
- Some of the training topics covered include ... Importing and Exporting Records
- See Training Course Details...
Creating and Using Reports
Action Queries
Creating Queries
Aggregation Queries
Data Validation
Creating a Lookup Database
Database Security
Setting Table Relationships
Relational Database Design
Querying Techniques
Designing a Lookup Database
DIY Forms
Parameter Queries
Modifying Table Structures
Navigation Pane Protection
Multi Table Queries
Creating and Using Macros
Macro Techniques
Understanding VBA
Sorting and Filtering
Microsoft Access Programming Using VBA
- 3 day course
- Location: Birmingham
- 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 ... Using Message Boxes
- See Training Course Details...
Navigating the Access Object Hierarchy
Understanding Procedures
Calling Procedures
Understanding Collections
Controlling Program Execution
Understanding Error Handling
Working with Boolean Expressions
Understanding VBA's Error Trapping Options
Understanding Classes and Objects
Working with Variable Scope
Introduction to Programming in Access
Working with Methods
Handling Errors
Working with Variable Lifetime
Understanding Constants
Setting Breakpoints
Considering Variable Scope and Lifetime Together
Determining the Value of Expressions
Email us about this courses
Other Birmingham Enable Technology Training Courses
JQuery Mobile - Birmingham JavaScript Training Courses
VBA Birmingham Training Courses
Excel 365 Advanced Birmingham Training Courses
SSRS Birmingham Training Courses
JQuery Birmingham Training Courses
SSAS Tabular - Birmingham SQL Server Analysis Services Training Courses