ACCESS TRAINING COURSES WEDNESBURY
About Enable Technology Wednesbury Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. The person delivering the course will be a Microsoft Solutions Expert (MCSE). Every course participant is given Access courseware which they can refer to after the training. We also provide an ongoing support service to people attending our Access courses. Delegates can contact the course tutor with specific Access questions for as long as they need following the course.
Delegates are taught by an experienced Microsoft professional. Access courses are delivered through a mix of practical hands on exercises and walk throughs. 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 Wednesbury. The Access syllabus can be adjusted and additional topics incorporated if helpful.
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 group of companies has been operating continuously providing IT training since 1998. Some of our clients are Fujistu PLC, Unipart Group, Lloyds TSB Bank PLC, Countrywide Homes Limited, West Bromwich Building Society, TalkTalk Direct Limited, Boots UK Limited and Carillion PLC.
Microsoft Access
- 2 day course
- Location: Wednesbury
- 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 ... Using a Navigation Form
- See Training Course Details...
Aggregation Queries
Setting Table Relationships
Macro Techniques
Understanding VBA
Navigation Pane Protection
Calculations in Queries
Querying Techniques
An Introduction to VBA
Modifying Forms
DIY Forms
Creating a Lookup Database
Designing a Lookup Database
Database Security
Macros on Forms
Parameter Queries
Multi Table Queries
Adding Transactional Records
Importing and Exporting Records
Relational Database Design
Data Validation
Microsoft Access Programming Using VBA
- 3 day course
- Location: Wednesbury
- 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 ... Using Break Mode during Run Mode
- See Training Course Details...
Understanding Modules
Creating a Sub Procedure
Understanding Classes and Objects
Using the With Statement
Understanding Constants
Locking Records for Updating
Working with Inline Error Handling
Understanding Procedures
Debugging Code
Controlling Program Execution
Understanding Expressions and Statements
Handling Errors
Using the For...Next Structure
Declaring and Creating Object Variables
Using Intrinsic Functions
Introduction to Programming in Access
Why Program in Access?
Understanding Objects
Email us about this courses
Other Wednesbury Enable Technology Training Courses
SSAS - Wednesbury SQL Server Analysis Services Training Courses
TSQL - Wednesbury SQL Training Courses
PL/SQL Wednesbury Training Courses
Power BI Wednesbury Training Courses
SSRS Wednesbury Training Courses
Excel 365 Basic Wednesbury Training Courses