ACCESS TRAINING COURSES COLWYN BAY
About Enable Technology Colwyn Bay Access Training Courses
We offer intensive two and three days Access courses. The tutor delivering the course will be a Microsoft certified expert. Every course participant will receives course practice files and Access course resources that can be referenced post training. Enable Technology offer post course help to all delegates. Participants on the Access course can contact the tutor for as long as they like if they encounter Access problems.
Enable Technology Access courses are instructor led and taught by an experienced Microsoft expert. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. Another option is we can organise a local training site in Colwyn Bay. The Access syllabus can be adjusted and additional topics incorporated if helpful.
We can also deliver Access courses through an online virtual classroom. You log onto a scheduled virtual classroom, can view the tutor and exercise demonstrations, ask questions and allow the tutor to share your screen if need help completing the course exercises.
Our teaching team have been delivering technical training in the Midlands for twenty years. Our clients include: Birmingham Heartlands Hospital, Royal & Sun Alliance Group PLC, Countrywide Homes Limited, Dollond & Aitchison Limited, Loughborough University, National Power PLC, Capita Group PLC and Lloyds TSB Bank PLC.
Microsoft Access
- 2 day course
- Location: Colwyn Bay
- 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 ... Setting Table Relationships
- See Training Course Details...
Creating Queries
Macros on Forms
Creating a Relational Database
Creating and Using Forms
Relational Database Design
Navigation Pane Protection
Understanding VBA
Multi Table Queries
Using a Navigation Form
Database Security
Querying Techniques
Aggregation Queries
Creating and Using Reports
Adding Transactional Records
Adding Records to a Table
An Introduction to VBA
Formatting Tables
Modifying Table Structures
Designing a Lookup Database
Calculations in Queries
Microsoft Access Programming Using VBA
- 3 day course
- Location: Colwyn Bay
- 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 ... Working with Inline Error Handling
- See Training Course Details...
Using Break Mode during Run Mode
Creating a Function Procedure
Using Expressions, Variables, and Intrinsic Functions
Trapping Errors with the On Error Statement
Using the Immediate Window to Call Procedures
Using the For Each...Next Structure
Declaring Variables
Using Intrinsic Functions
Using the Select Case...End Select Structure
Working with Methods
Specifying a Recordset Cursor Location - Optional
Using Input Boxes
Handling Errors
Using Message Boxes
Understanding the Err Object
Understanding Objects
Determining the Value of Expressions
Navigating the Access Object Hierarchy
Email us about this courses
Other Colwyn Bay Enable Technology Training Courses
JQuery - Colwyn Bay JavaScript Training Courses
SSRS Colwyn Bay Training Courses
Excel 365 Advanced Colwyn Bay Training Courses
JavaScript - Colwyn Bay JavaScript Training Courses
SSIS Colwyn Bay Training Courses
SSAS Tabular - Colwyn Bay SQL Server Analysis Services Training Courses