ACCESS TRAINING COURSES RHOSLLANERCHRUGOG
About Enable Technology Rhosllanerchrugog Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. Every course participant will receives course practice files and Access course resources that can be referenced post training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. We can deliver at your premises. We can provide the equipment. The Access course could also be scheduled at a socially distanced site near you in Rhosllanerchrugog. We are happy to discuss customising the course content should you have particular Access 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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Birmingham City Council, Wolverhampton City Council, Unipart Group, West Bromwich Building Society, Nationwide Building Society Limited, Shell UK Oil Products Ltd, Royal & Sun Alliance Group PLC and Canadian High Commission.
Microsoft Access
- 2 day course
- Location: Rhosllanerchrugog
- 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 ... Creating and Using Macros
- See Training Course Details...
Getting to Know Access
Modifying Table Structures
An Introduction to VBA
Sorting and Filtering
Importing and Exporting Records
Understanding VBA
Navigation Pane Protection
Database Wellness
Macro Techniques
Aggregation Queries
Creating a Relational Database
Designing a Lookup Database
Creating and Using Reports
Creating and Using Forms
Relational Database Design
Database Security
Data Validation
Macros on Forms
Using a Navigation Form
Working With Records
Microsoft Access Programming Using VBA
- 3 day course
- Location: Rhosllanerchrugog
- 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...
Using Break Mode during Run Mode
Debugging Code
Understanding the Order of Events
Understanding Recordset Cursor Properties - Optional
Navigating the Access Object Hierarchy
Understanding the DoCmd Object
Understanding Error Handling
Working with Boolean Expressions
Determining the Value of Expressions
Controlling Program Execution
Declaring Variables
Calling Procedures
Using the Object Browser
Understanding Errors
Considering Variable Scope and Lifetime Together
Using the Do...Loop Structure
Using Expressions, Variables, and Intrinsic Functions
Understanding the Err Object
Email us about this courses
Other Rhosllanerchrugog Enable Technology Training Courses
SSAS - Rhosllanerchrugog SQL Server Analysis Services Training Courses
SSIS - Rhosllanerchrugog SQL Server Integration Services Training Courses
Oracle SQL Rhosllanerchrugog Training Courses
JavaScript Rhosllanerchrugog Training Courses
PL/SQL Rhosllanerchrugog Training Courses
SQL Rhosllanerchrugog Training Courses