ACCESS TRAINING COURSES PRESTWICH
About Enable Technology Prestwich Access Training Courses
We offer intensive two and three days Access courses. The training will be delivered by a Microsoft professional with development experience. All course participants are issued Access training manuals they can refer to after the course. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
Enable Technology offers instructor led training taught by technology specialists. 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. The Access course could also be scheduled at a socially distanced site near you in Prestwich. We are happy to modify the Access syllabus to match your teams training requirements.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
We guarantee you tutor will have at least twenty years of technical training experience. Some of our clients are Countrywide Homes Limited, Total Telecommunications Limited, Fujistu PLC, West Bromwich Building Society, Cadbury PLC, Royal & Sun Alliance Group PLC, EDF Energy PLC and Birmingham City Council.
Microsoft Access
- 2 day course
- Location: Prestwich
- 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 ... Modifying Forms
- See Training Course Details...
Database Wellness
Formatting Tables
Importing and Exporting Records
Creating a Lookup Database
Action Queries
Setting Table Relationships
Multi Table Queries
Querying Techniques
Getting to Know Access
Adding Transactional Records
Sorting and Filtering
Macros on Forms
Designing a Lookup Database
Parameter Queries
Creating and Using Macros
Understanding VBA
Calculations in Queries
Navigation Pane Protection
Creating a Relational Database
Creating and Using Reports
Microsoft Access Programming Using VBA
- 3 day course
- Location: Prestwich
- 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 ... Specifying a Recordset Cursor Type
- See Training Course Details...
Understanding Classes and Objects
Working with Variable Lifetime
Determining the Value of Expressions
Understanding Collections
Understanding the Order of Events
Working with Properties
Handling Errors
Understanding Data Types
Using the With Statement
Using Intrinsic Constants
Using the If...End If Decision Structures
Working with Recordsets
Setting Breakpoints
Understanding Recordset Cursor Properties - Optional
Organizing Code and Procedures
Naming Procedures
Understanding the Development Environment
Understanding Errors
Declaring and Creating Object Variables
Email us about this courses
Other Prestwich Enable Technology Training Courses
VBA Prestwich Training Courses
Oracle SQL Prestwich Training Courses
SSAS Tabular Prestwich Training Courses
DAX Prestwich Training Courses
JQuery Mobile Prestwich Training Courses
Excel 365 Basic - Prestwich Excel Training Courses