ACCESS TRAINING COURSES BARRY
About Enable Technology Barry Access Training Courses
We are a company that offers short, practical, Access hands on technology courses. The tutor delivering the course will be a Microsoft certified expert. Everyone attending a Access course receives learning resources which also serves as a reference source after the course. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
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. Alternatively we could schedule a course at a local venue in Barry. The Access syllabus can be adjusted and additional topics incorporated if helpful.
Access courses are available via virtual classrooms. Training participants can log onto scheduled classes, watch the tutor talk through and demonstrate each topic, ask questions and share their screen with the tutor if they need assistance.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are Birmingham City Council, Unipart Group, Yell Group PLC, Vodafone Group Services, Queen's Medical Centre Nottingham, Royal & Sun Alliance Group PLC, University of Birmingham and Norfolk Police Constabulary.
Microsoft Access
- 2 day course
- Location: Barry
- Telephone on 01952 938014
- Course Outline
-
A two day intensive course. The course assumes no prior Access knowledge but takes candidates to the point where they can build, manage and query an Access based relational database.
- Some of the training topics covered include ... Macros on Forms
- See Training Course Details...
Formatting Tables
Adding Transactional Records
Querying Techniques
Designing a Lookup Database
Multi Table Queries
Modifying Table Structures
Creating and Using Reports
Creating and Using Macros
Macro Techniques
Aggregation Queries
Data Validation
Creating a Relational Database
Understanding VBA
Sorting and Filtering
Adding Records to a Table
Creating and Using Forms
Working With Records
Setting Table Relationships
An Introduction to VBA
Parameter Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Barry
- 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 ... Why Program in Access?
- See Training Course Details...
Specifying a Recordset Cursor Location - Optional
Working with Procedures and Functions
Understanding the Form Object
Trapping Errors with the On Error Statement
Understanding Recordset Cursor Properties - Optional
Using the Object Browser
Working with the Application Object
Working with the Code Editor
Setting Breakpoints
Controlling Program Execution
Using the CacheSize Property - Optional
Using the Do...Loop Structure
Using Intrinsic Functions
Stepping through Code
Using the For Each...Next Structure
Calling Procedures
Working with the ADODB Recordset Object
Working with Inline Error Handling
Email us about this courses
Other Barry Enable Technology Training Courses
Power BI - Barry Microsoft Power BI Training Courses
JQuery Mobile - Barry JavaScript Training Courses
JQuery - Barry JavaScript Training Courses
Data Warehouse Barry Training Courses
Excel 365 Advanced - Barry Excel Training Courses
Excel 365 Basic - Barry Excel Training Courses