ACCESS TRAINING COURSES NORMANTON
About Enable Technology Normanton Access Training Courses
We are a company that provides short intensive Access training courses. The tutor teaching the course will be an experienced developer and Microsoft certified professional. All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. It is our company policy to provide Access training participants with ongoing support from the course Tutor. People who attend a Access course can contact the Tutor for as long as they need assistance after the training.
Courses are instructor led and groups sizes small. If you can provide a training room, we can bring the necessary laptops with software installed and deliver the Access onsite. We are also more than happy to organise a local course at a training location in Normanton. The Access syllabus can be adjusted and additional topics incorporated if helpful.
Access courses are also available online. Participants can join scheduled virtual classes, watch the tutor demonstrate the topic, ask questions and share their screen
In the Midlands the Enable Technology team have been providing technical training since 1998. Some of our clients are Dollond & Aitchison Limited, DHL Express, Keele University, Homeserve PLC, Aston University, Fujistu PLC, Royal & Sun Alliance Group PLC and Countrywide Homes Limited.
Microsoft Access
- 2 day course
- Location: Normanton
- 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 ... Navigation Pane Protection
- See Training Course Details...
Database Security
Data Validation
Understanding VBA
Aggregation Queries
Macro Techniques
Macros on Forms
Creating and Using Macros
Designing a Lookup Database
Calculations in Queries
Action Queries
Sorting and Filtering
Creating Queries
Adding Transactional Records
Working With Records
Relational Database Design
Formatting Tables
Setting Table Relationships
Modifying Forms
Getting to Know Access
Creating a Lookup Database
Microsoft Access Programming Using VBA
- 3 day course
- Location: Normanton
- 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 ... Using Message Boxes
- See Training Course Details...
Using Break Mode during Run Mode
Using the CacheSize Property - Optional
Considering Variable Scope and Lifetime Together
Handling Errors
Working with the ADODB Recordset Object
Using Visual Basic Help
Understanding the Form Object
Introduction to Programming in Access
Using the Do...Loop Structure
Understanding Recordset Cursor Properties - Optional
Declaring and Creating Object Variables
Calling Procedures
Debugging Code
Working with Recordsets
Using Intrinsic Functions
Working with Boolean Expressions
Using Input Boxes
Determining the Value of Expressions
Working with the Application Object
Email us about this courses
Other Normanton Enable Technology Training Courses
Excel 365 Intermediate - Normanton Excel Training Courses
JavaScript - Normanton JavaScript Training Courses
Power BI Normanton Training Courses
SSAS Tabular - Normanton SQL Server Analysis Services Training Courses
Power Query Normanton Training Courses
SSAS - Normanton SQL Server Analysis Services Training Courses