ACCESS TRAINING COURSES THORNTON-CLEVELEYS
About Enable Technology Thornton-cleveleys Access Training Courses
Enable Technology Access courses are short, skill focused and hands on. The course will always be taught by a Microsoft Certified Professional (MCP). All candidates receive comprehensive Access training materials and practice files which are theirs to refer to after the course. Anyone attending the course can contact the Tutor for as long as they like after the Access course. The ongoing support by a Microsoft expert is an important part of the service we offer.
Enable Technology training courses are delivered as instructor led courses. Enable Technology can provide Access courses onsite at your location. We will bring the necessary laptops with the required software installed. The Access course could also be scheduled at a socially distanced site near you in Thornton-cleveleys. The Access syllabus can be modified to accommodate your specific training needs.
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.
We have two decades of delivering technical training predominantly in the West Midlands. Our clients include: Aston University, Yell Group PLC, Lloyds TSB Bank PLC, Fujistu PLC, Norfolk Police Constabulary, Birmingham City Council, Unipart Group and Wolverhampton City Council.
Microsoft Access
- 2 day course
- Location: Thornton-cleveleys
- 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 ... Creating and Using Reports
- See Training Course Details...
Calculations in Queries
Aggregation Queries
Importing and Exporting Records
Creating Queries
Sorting and Filtering
Adding Transactional Records
Modifying Table Structures
Setting Table Relationships
Macro Techniques
Navigation Pane Protection
Database Security
Creating a Lookup Database
Creating a Relational Database
Data Validation
DIY Forms
Creating and Using Macros
Getting to Know Access
Adding Records to a Table
Using a Navigation Form
Database Wellness
Microsoft Access Programming Using VBA
- 3 day course
- Location: Thornton-cleveleys
- 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 ... Specifying a Recordset Cursor Type
- See Training Course Details...
Working with the Application Object
Understanding VBA's Error Trapping Options
Determining the Value of Expressions
Working with Variable Scope
Understanding Control-of-Flow Structures
Understanding Modules
Working with Properties
Understanding Errors
Understanding Recordset Cursor Properties - Optional
Working with Methods
Using the With Statement
Trapping Errors with the On Error Statement
Calling Procedures
Declaring and Creating Object Variables
Working with Boolean Expressions
Understanding the Order of Events
Using the Object Browser
Understanding Expressions and Statements
Email us about this courses
Other Thornton-cleveleys Enable Technology Training Courses
Excel Power Pivot - Thornton-cleveleys Excel Training Courses
TSQL - Thornton-cleveleys SQL Training Courses
JQuery Mobile - Thornton-cleveleys JavaScript Training Courses
Power Query - Thornton-cleveleys Excel Training Courses
JavaScript - Thornton-cleveleys JavaScript Training Courses
JQuery Thornton-cleveleys Training Courses