ACCESS TRAINING COURSES WARWICKSHIRE
About Enable Technology Warwickshire Access Training Courses
We are a company that provides short intensive Access training courses. We guarantee the training will be delivered by a Microsoft certified expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We can bring the equipment necessary to deliver Access courses at your site. We can also deliver the Access course at a socially distanced local training venue in Warwickshire. We are happy to modify the Access syllabus to match your teams training requirements.
This instructor led course is also available online. Participants can log onto a virtual classroom and will be able to see the tutors screen, ask questions real time and share their screen with the Tutor.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are DHL Express, Birmingham City University, South Staffordshire Water PLC, West Bromwich Building Society, Aston University, Canadian High Commission, Royal & Sun Alliance Group PLC and Fujistu PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Warwickshire
- Telephone on 01952 938014
- Course Outline
-
This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.
- Some of the training topics covered include ... Debugging Code
- See Training Course Details...
Working with the Code Editor
Understanding Expressions and Statements
Working with Inline Error Handling
Using Input Boxes
Working with Procedures and Functions
Specifying a Recordset Cursor Type
Using the Do...Loop Structure
Handling Errors
Using Intrinsic Functions
Understanding Constants
Understanding Collections
Setting Break Expressions
Understanding Control-of-Flow Structures
Considering Variable Scope and Lifetime Together
Using Visual Basic Help
Declaring and Creating Object Variables
Understanding Recordset Cursor Properties - Optional
Understanding Errors
Microsoft Access
- 2 day course
- Location: Warwickshire
- 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 ... Adding Records to a Table
- See Training Course Details...
Navigation Pane Protection
Creating Queries
An Introduction to VBA
Querying Techniques
Getting to Know Access
Creating and Using Reports
Aggregation Queries
Creating a Relational Database
Database Security
Understanding VBA
Designing a Lookup Database
Adding Transactional Records
Macros on Forms
Relational Database Design
DIY Forms
Using a Navigation Form
Sorting and Filtering
Setting Table Relationships
Parameter Queries
Creating and Using Macros
Email us about this courses
Other Warwickshire Enable Technology Training Courses
Excel 365 Intermediate - Warwickshire Excel Training Courses
Data Warehouse Warwickshire Training Courses
TSQL - Warwickshire SQL Training Courses
PL/SQL - Warwickshire SQL Training Courses
Excel 365 Advanced Warwickshire Training Courses
Power BI Warwickshire Training Courses