ACCESS TRAINING COURSES NEWPORT
About Enable Technology Newport Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. All of our tutors are Microsoft Certified Professionals. We provide every candidate with Access training materials which they keep after the course. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
Our primary method of delivery is instructor led training coupled with practical hands on activities. Our Access training courses can be delivered onsite at your location. You simply need to provide a room. We can supply the equipment and software. The Access course could also be scheduled at a socially distanced site near you in Newport. We are happy to modify the Access syllabus to match your teams training requirements.
This course can also be delivered in a virtual classroom. Delegates can log into a scheduled Access course, watch the tutor demonstrate tasks, ask questions and share their own screen.
The Enable Technology team have been providing IT training primarily in the Midlands for two decades. Some of our clients are West Bromwich Building Society, Birmingham City Council, Canadian High Commission, Homeserve PLC, Aston University, South Staffordshire Water PLC, Barclays Bank PLC and TalkTalk Direct Limited.
Microsoft Access
- 2 day course
- Location: Newport
- 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 ... Macro Techniques
- See Training Course Details...
Data Validation
Setting Table Relationships
Getting to Know Access
Sorting and Filtering
Adding Records to a Table
Modifying Table Structures
Database Wellness
Working With Records
An Introduction to VBA
Database Security
Importing and Exporting Records
Formatting Tables
Aggregation Queries
Relational Database Design
Multi Table Queries
Creating and Using Reports
Creating a Relational Database
Navigation Pane Protection
Creating and Using Forms
Macros on Forms
Microsoft Access Programming Using VBA
- 3 day course
- Location: Newport
- Telephone on 01952 938014
- Course Outline
-
This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.
- Some of the training topics covered include ... Writing an Error-Handling Routine
- See Training Course Details...
Understanding Modules
Using the Do...Loop Structure
Using the CacheSize Property - Optional
Considering Variable Scope and Lifetime Together
Understanding VBA's Error Trapping Options
Handling Errors
Declaring Variables
Why Program in Access?
Working with Methods
Understanding the DoCmd Object
Working with Inline Error Handling
Understanding the Err Object
Working with Events
Working with the Code Editor
Using Visual Basic Help
Specifying a Recordset Cursor Location - Optional
Controlling Program Execution
Email us about this courses
Other Newport Enable Technology Training Courses
Excel 365 Advanced - Newport Excel Training Courses
Power Query - Newport Excel Training Courses
Excel 365 Intermediate Newport Training Courses
JQuery Mobile - Newport JavaScript Training Courses
Oracle SQL Newport Training Courses
Data Warehouse Newport Training Courses