ACCESS TRAINING COURSES PORTHCAWL
About Enable Technology Porthcawl Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The course will always be taught by a Microsoft Certified Professional (MCP). Every course participant is given Access courseware which they can refer to after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. Alternatively we could schedule a Access course at an alternative training site in Porthcawl. 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. Some of our clients are Cadbury PLC, Royal & Sun Alliance Group PLC, Birmingham City University, Yell Group PLC, South Staffordshire Water PLC, Nuclear Engineering Services, Barclays Bank PLC and Norwich Union PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Porthcawl
- 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 ... Understanding the Form Object
- See Training Course Details...
Creating a Function Procedure
Using the Select Case...End Select Structure
Working with Boolean Expressions
Creating a Standard Module
Specifying a Recordset Cursor Type
Using Expressions, Variables, and Intrinsic Functions
Declaring and Creating Object Variables
Understanding Objects
Determining the Value of Expressions
Understanding Error Handling
Using the For...Next Structure
Understanding the Err Object
Handling Errors
Using the Object Browser
Understanding the DoCmd Object
Trapping Errors with the On Error Statement
Microsoft Access
- 2 day course
- Location: Porthcawl
- Telephone on 01952 938014
- Course Outline
-
In this two day course we teach participants how to design, build and use a Microsoft Access relational database. The syllabus will cover working with tables, queries, reports, forms and macros. The progresses from introductory level to advanced topics.
- Some of the training topics covered include ... Macro Techniques
- See Training Course Details...
DIY Forms
Designing a Lookup Database
Modifying Forms
Macros on Forms
Relational Database Design
Creating a Lookup Database
Sorting and Filtering
Creating and Using Reports
Parameter Queries
Creating a Relational Database
Creating and Using Forms
Getting to Know Access
Creating Queries
Action Queries
Data Validation
Adding Records to a Table
Understanding VBA
Navigation Pane Protection
Formatting Tables
Using a Navigation Form
Email us about this courses
Other Porthcawl Enable Technology Training Courses
Excel 365 Basic Porthcawl Training Courses
Excel 365 Intermediate - Porthcawl Excel Training Courses
JQuery Mobile - Porthcawl JavaScript Training Courses
JQuery - Porthcawl JavaScript Training Courses
Excel Power Pivot Porthcawl Training Courses
Power BI Porthcawl Training Courses