Below are an example of the types of courses that we can run for the software you have chosen.
We run courses for Microsoft Office 2010, 2013 and 2016, and specialise in 'bespoke offerings' which means we can cater a course around what suits you and your business. All our courses are run 'In House' at your offices which makes it as simple and straight forward for your team as possible.
Microsoft Access Level 1 Training Course
Duration : 1 day
Objectives
This course provides an introduction to the basic concepts of Microsoft Access. On completion of this course, the delegate will be able to use an existing Access Database effectively and be able to create and modify simple Tables, Queries, Forms and Reports. This course provides a foundation for the Access Level 2 course which is recommended for anyone planning to design and create any but the simplest database.
Designed for
This course is suitable for delegates who wish to learn to use databases effectively and to create simple databases for single-user use. No previous knowledge of Access is assumed, but delegates should be familiar with using one or more of the other programs in the Microsoft Office suite.
Description
The course covers the essential skills required to create and manage a simple database, and introduces the concepts of good database design. It deals with creating and using Tables and their Relationships, Queries, Forms and Reports and shows how these can be combined into a simple but effective application. It also discusses some of the issues involved with managing databases.
Topics
- Overview of Relational Databases
- Introduction to Microsoft Access
- Creating a Database
- Creating Tables and Modifying Table Design
- Working with Tables
- Select Queries
- Creating and Using Forms
- Creating and Using Reports
- Database Management
Microsoft Access Level 2 Training Course
Duration : 1 day
Objectives
This course provides the necessary knowledge to design and build a straightforward but functional database. On completion of the course, delegates will understand how to create a normalised relational design and be able to create and amend queries, forms and reports that go beyond the simple objects created by the Access Wizards. The material covered in this course provides a foundation for the Access Level 3 course.
Designed for
This course is suitable for delegates who are familiar with using a Microsoft Access database but wish to extend their ability to design and build straightforward databases. An understanding of the material covered in the Level 1 course is an essential prerequisite for this course.
Description
The course covers the key features of a normalised database design and the essential skills required to create and manage a simple database. It emphasises good design practices that lead to flexible and adaptable databases and deals with creating and amending Tables and their Relationships, Queries, Forms and Reports, showing how these can be combined into a simple but effective application.
Topics
- Relational Database Design
- Modifying Table Design
- Using Lookup Fields
- Modifying Queries
- Outer Joins
- Calculated Fields
- Query Wizards
- Simple Parameter Queries
- Modifying Form Design
- Controls and the Property Sheet
- Managing Controls
- Modifying Report Design
- Sorting and Grouping
- Database Management
- Object Dependencies
- Importing and Exporting Data
Microsoft Access Level 3 Training Course
Duration : 1 day
Objectives
This course builds on the Level 1 and Level 2 courses to provide the necessary skills to build complete database solutions. On completion of the course, delegates will understand how to exploit the key components of Access to create databases with a high degree of control and automation.
Designed for
This course is suitable for delegates who are familiar with designing and building Tables, Queries, Forms and Reports but wish to create more sophisticated and automated solutions. An understanding of the material covered in the Level 1 and Level 2 courses is an essential prerequisite for this course.
Description
The course covers some more advanced aspects of Table and Form design as well as Parameter and Action Queries, SQL and multi-column Reports. It also deals with Linked databases, Start Up options and a number of features that facilitate the management of more advanced databases. It introduces the concepts of macros and their use for automating and controlling many processes.
Topics
- Table Validation Rules
- Input Masks
- Using Subreports
- The Tab Control
- Parameter Queries
- Action Queries
- Self Joins
- UNION Queries
- SQL and SubQueries
- Using Subforms
- Calculated Controls
- Multi Column Reports
- Linking to other Databases
- Analysing and Documenting
- Start Up Options
- Introduction to Macros
- Event Driven Macros
- Validation and Calculation Macros