Our Intermediate Microsoft Access Course is an in-depth training program to gain professional knowledge, which is much needed in any office where databases are important. The online training is delivered via a user-friendly state-of-the-art system using the latest technology in interactive training. The training is through a virtual tutor who follows your progress and shows you the correct way to perform a task.
As a Microsoft Certified Academy, this course includes CPD Accredited Certification in Microsoft Access Intermediate Level.
To learn the most efficient way to use Access; to gain a CPD Accredited Certificate at the Proficient (Intermediate) level.
You can add Beginner and/or Advanced units for a discounted fee. The training is delivered online using a virtual tutor function. The virtual tutor instructs, corrects, and provides examples to simulate having a personal IT trainer. This is a very effective and up-to-date method of delivering interactive online training.
Intermediate Microsoft Access Course
Objects and their datasheets
- Managing objects
- Formatting/reorganising a datasheet
- Filtering records by the value in a field
- Filtering by a range of field values
- Inserting a Total row into a datasheet
Database creation and protection
- Creating a database
- Converting a database
- Protecting a database
More about data
- Creating a table
- Primary key
- Importing data from another application
- Exporting data
- Creating a form
- Object dependencies
- Selecting the records to print in a report
From question to query
- Creating a Select query
- Using the query design grid
- Setting a selection criterion in a query
- Setting criteria on multiple fields
- Setting multiple criteria on the same field
- Sorting the records in a query
- Delete query
- Make Table query
- Update query
Dates and Duration
Please email or telephone to arrange a start date with induction.
You should take your assessment within six months to obtain a CPD Accredited Microsoft Certificate (included in the price). You have access to the training program for one year.
- CPD Accredited Microsoft Certificate
- Accredited qualification to boost your CV and job options
- Being prepared for any assessment at a job interview
- Confidence in the use of Access effectively at work
- Work quickly because of this additional knowledge
- The flexible training schedule can be taken anywhere online
- User-friendly system to make you professionally effective with this software
- Access to the training program for one year.
CPD Accredited Microsoft Access Certificate- Intermediate Level