ACCESS TRAINING COURSES SCARBOROUGH
About Enable Technology Scarborough Access Training Courses
Enable Technology offer short intensive skills based Access training courses. We guarantee the training will be delivered by a Microsoft certified expert. Each person attending a course takes away Access courseware which can be used as reference materials after the training. We offer all delegates open ended post training support. Delegates can contact the Tutor after the course with Access queries.
Enable Technology offers instructor led training taught by technology specialists. Enable Technology Access training courses can be delivered at your offices. We can supply the necessary software and computers. The Access course could also be scheduled at a socially distanced site near you in Scarborough. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
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, Keele University, Cadbury PLC, Capita Group PLC, Yell Group PLC, University of Birmingham, West Bromwich Building Society and Fujistu PLC.
Microsoft Access
- 2 day course
- Location: Scarborough
- 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 ... Creating a Relational Database
- See Training Course Details...
Importing and Exporting Records
Formatting Tables
Creating a Lookup Database
Adding Transactional Records
Creating and Using Forms
Calculations in Queries
Navigation Pane Protection
Creating and Using Reports
Adding Records to a Table
An Introduction to VBA
DIY Forms
Multi Table Queries
Database Wellness
Sorting and Filtering
Querying Techniques
Aggregation Queries
Creating Queries
Modifying Forms
Database Security
Modifying Table Structures
Microsoft Access Programming Using VBA
- 3 day course
- Location: Scarborough
- Telephone on 01952 938014
- Course Outline
-
A three day course enabling participants to build Access based business applications. No prior programming experience is assumed.
- Some of the training topics covered include ... Using the Immediate Window to Call Procedures
- See Training Course Details...
Understanding Modules
Specifying a Recordset Cursor Type
Working with the Application Object
Using the If...End If Decision Structures
Using Debugging Tools
Handling Errors
Debugging Code
Why Program in Access?
Guidelines for use of Branching Structures
Declaring Variables
Working with Inline Error Handling
Using Visual Basic Help
Working with Events
Working with Methods
Working with the Code Editor
Understanding the DoCmd Object
Using Intrinsic Functions
Email us about this courses
Other Scarborough Enable Technology Training Courses
JavaScript - Scarborough JavaScript Training Courses
JQuery Mobile Scarborough Training Courses
Excel 365 Basic Scarborough Training Courses
Power Query Scarborough Training Courses
SSIS - Scarborough SQL Server Integration Services Training Courses
TSQL Scarborough Training Courses