ACCESS TRAINING COURSES NEWCASTLE UPON TYNE
About Enable Technology Newcastle Upon Tyne Access Training Courses
Enable Technology has twenty year track record of providing short intensive Access skills based training courses. All of our tutors are Microsoft Certified Solutions Experts with development backgrounds. Every course participant is given Access courseware which they can refer to after the training. Course participants are welcome contact the Tutor after the course with specific Access queries. This support is open ended.
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. If you prefer we can offer an offsite training location in Newcastle Upon Tyne. We will work with you prior to the course to tailor the Access syllabus to match your requirements.
We also deliver this course online through virtual classrooms. Delegates can join scheduled Access classes, view the tutors demonstrations, ask questions and share their screen with the trainer if they need assistance.
We have two decades of delivering technical training predominantly in the West Midlands. Some of our clients are Shell UK Oil Products Ltd, Wolverhampton City Council, Halfords Group PLC, Total Telecommunications Limited, Fujistu PLC, Countrywide Homes Limited, TalkTalk Direct Limited and National Power PLC.
Microsoft Access Programming Using VBA
- 3 day course
- Location: Newcastle Upon Tyne
- 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 ... Introduction to Programming in Access
- See Training Course Details...
Organizing Code and Procedures
Using the Object Browser
Creating a Sub Procedure
Controlling Program Execution
Why Program in Access?
Handling Errors
Using Input Boxes
Understanding the Order of Events
Using Intrinsic Constants
Using the For Each...Next Structure
Understanding Data Types
Working with Events
Specifying a Recordset Cursor Location - Optional
Understanding Procedures
Naming Procedures
Understanding the Development Environment
Stepping through Code
Understanding Expressions and Statements
Trapping Errors with the On Error Statement
Microsoft Access
- 2 day course
- Location: Newcastle Upon Tyne
- Telephone on 01952 938014
- Course Outline
-
This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.
- Some of the training topics covered include ... Navigation Pane Protection
- See Training Course Details...
Querying Techniques
Designing a Lookup Database
Creating and Using Macros
Modifying Table Structures
Aggregation Queries
Understanding VBA
Relational Database Design
Calculations in Queries
Creating and Using Reports
Creating a Relational Database
Parameter Queries
Sorting and Filtering
Macros on Forms
Creating Queries
Formatting Tables
Adding Transactional Records
Creating and Using Forms
Modifying Forms
Database Wellness
Adding Records to a Table
Email us about this courses
Other Newcastle Upon Tyne Enable Technology Training Courses
Excel 365 Intermediate - Newcastle Upon Tyne Excel Training Courses
Oracle SQL Newcastle Upon Tyne Training Courses
JQuery Mobile - Newcastle Upon Tyne JavaScript Training Courses
Power BI - Newcastle Upon Tyne Microsoft Power BI Training Courses
SSRS - Newcastle Upon Tyne SQL Server Reporting Services Training Courses
Report Builder Newcastle Upon Tyne Training Courses