ACCESS TRAINING COURSES SOUTHPORT
About Enable Technology Southport Access Training Courses
We offer intensive two and three days Access courses. All Enable Technology tutors are Microsoft certified experts. We will issue each Access training participant with learning resources which they can refer to post training. If delegates have have questions about Access after the course they are welcome to contact the course Tutor. This post training support is ongoing.
Access training courses are instructor led and task based. Participants get to practice new skills in a controlled environment. Enable Technology Access courses can be delivered onsite at your premises. We bring a fully equipped training lab with us. We can also deliver the Access course at a local training venue in Southport. The Access syllabus can be modified to accommodate your specific training needs.
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: Carillion PLC, Dollond & Aitchison Limited, Vodafone Group Services, Queen's Medical Centre Nottingham, Aston University, DHL Express, Shell UK Oil Products Ltd and Royal Air Force.
Microsoft Access
- 2 day course
- Location: Southport
- 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 ... Setting Table Relationships
- See Training Course Details...
Creating and Using Reports
Macros on Forms
Creating Queries
Relational Database Design
Creating a Relational Database
Multi Table Queries
Action Queries
Modifying Forms
Parameter Queries
Importing and Exporting Records
Aggregation Queries
Calculations in Queries
Data Validation
Understanding VBA
Formatting Tables
Designing a Lookup Database
DIY Forms
Creating and Using Forms
Creating and Using Macros
Getting to Know Access
Microsoft Access Programming Using VBA
- 3 day course
- Location: Southport
- 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 ... Using Visual Basic Help
- See Training Course Details...
Controlling Program Execution
Calling Procedures
Understanding Expressions and Statements
Understanding Classes and Objects
Declaring Variables
Handling Errors
Understanding Recordset Cursor Properties - Optional
Declaring and Creating Object Variables
Understanding VBA's Error Trapping Options
Using Expressions, Variables, and Intrinsic Functions
Working with Methods
Understanding Control-of-Flow Structures
Working with the Code Editor
Locking Records for Updating
Naming Procedures
Using Intrinsic Constants
Determining the Value of Expressions
Email us about this courses
Other Southport Enable Technology Training Courses
Oracle SQL - Southport SQL Training Courses
SSIS - Southport SQL Server Integration Services Training Courses
SSAS Southport Training Courses
DAX Southport Training Courses
PL/SQL - Southport SQL Training Courses
JavaScript - Southport JavaScript Training Courses