ACCESS TRAINING COURSES ALTRINCHAM
About Enable Technology Altrincham 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. We will issue each Access training participant with learning resources which they can refer to 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.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. We are set up to deliver Access training courses onsite at your premises. The Access course could also be scheduled at a socially distanced site near you in Altrincham. We offer the option of working with you to develop a bespoke Access programme which precisely matches your organisations training requirements.
Access courses are also available online. Delegates join a virtual classroom and participate in a real time instructor led course. Delegates can see the tutors screen, ask questions real time and share their screen with the tutor.
Our teaching team have been delivering technical training in the Midlands for twenty years. Some of our clients are West Bromwich Building Society, Birmingham City Council, EDF Energy PLC, Fujistu PLC, Carillion PLC, Norwich Union PLC, Cadbury PLC and Birmingham City University.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Altrincham
- 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 Modules
- See Training Course Details...
Using Expressions, Variables, and Intrinsic Functions
Working with Boolean Expressions
Using Input Boxes
Calling Procedures
Using the CacheSize Property - Optional
Controlling Program Execution
Understanding the Form Object
Organizing Code and Procedures
Working with the ADODB Recordset Object
Stepping through Code
Understanding the Err Object
Understanding Objects
Setting Breakpoints
Understanding Data Types
Using the For...Next Structure
Using the Immediate Window to Call Procedures
Specifying a Recordset Cursor Type
Working with Methods
Using the With Statement
Microsoft Access
- 2 day course
- Location: Altrincham
- 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 ... Action Queries
- See Training Course Details...
Database Security
Getting to Know Access
Macro Techniques
Calculations in Queries
Navigation Pane Protection
Setting Table Relationships
Modifying Forms
Modifying Table Structures
Importing and Exporting Records
Data Validation
Creating and Using Macros
Understanding VBA
Designing a Lookup Database
Aggregation Queries
Working With Records
Creating and Using Reports
Multi Table Queries
Creating a Lookup Database
An Introduction to VBA
Querying Techniques
Email us about this courses
Other Altrincham Enable Technology Training Courses
Excel 365 Basic - Altrincham Excel Training Courses
Report Builder - Altrincham SQL Server Reporting Services Training Courses
Data Warehouse - Altrincham SQL Training Courses
DAX - Altrincham Excel Training Courses
TSQL - Altrincham SQL Training Courses
Excel 365 Advanced Altrincham Training Courses