ACCESS TRAINING COURSES SOUTH SHIELDS
About Enable Technology South Shields Access Training Courses
We are a company that provides short intensive Access training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). 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.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. We can set up a training lab at your premises and deliver Access courses onsite at your site. Alternatively we could schedule a course at a local socially distanced venue in South Shields. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
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.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Birmingham City University, Royal Air Force, Unipart Group, Halfords Group PLC, Birmingham Heartlands Hospital, Lloyds TSB Bank PLC, Shell UK Oil Products Ltd and Royal & Sun Alliance Group PLC.
Microsoft Access
- 2 day course
- Location: South Shields
- Telephone on 01952 938014
- Course Outline
-
This is a two day intensive course. We show candidates how to design and build tables, forms and reports. Participants will learn how to create reports based on queries which filter and aggregate the data. No prior Access experience is assumed.
- Some of the training topics covered include ... Database Security
- See Training Course Details...
Macro Techniques
DIY Forms
Parameter Queries
Sorting and Filtering
Creating a Relational Database
Adding Records to a Table
Navigation Pane Protection
Aggregation Queries
Working With Records
Creating Queries
Setting Table Relationships
Querying Techniques
Creating and Using Forms
Understanding VBA
Database Wellness
Getting to Know Access
Creating and Using Macros
Multi Table Queries
Formatting Tables
Relational Database Design
Microsoft Access Programming Using VBA
- 3 day course
- Location: South Shields
- 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 ... Why Program in Access?
- See Training Course Details...
Using Intrinsic Functions
Working with Inline Error Handling
Using the For...Next Structure
Understanding the Err Object
Understanding Collections
Working with Recordsets
Understanding Modules
Using the With Statement
Using Visual Basic Help
Understanding Expressions and Statements
Writing an Error-Handling Routine
Creating a Standard Module
Using the Object Browser
Using the Immediate Window to Call Procedures
Guidelines for use of Branching Structures
Working with Events
Understanding the Order of Events
Specifying a Recordset Cursor Location - Optional
Understanding Recordset Cursor Properties - Optional
Creating a Function Procedure
Email us about this courses
Other South Shields Enable Technology Training Courses
Excel 365 Basic South Shields Training Courses
Data Warehouse South Shields Training Courses
DAX South Shields Training Courses
Excel Power Pivot South Shields Training Courses
Report Builder South Shields Training Courses
JavaScript - South Shields JavaScript Training Courses