Microsoft Access Level 2 - OnlineInsight IT Training
Microsoft Access Level 2 - Online
All available course dates
*We now offer Online IT training remotely to businesses in the UK and in Europe. This course is delivered remotely as a real time face-to-face communication with the trainer. You will be able to see the trainer and the trainer will be able to see you and your screen. All secure and private. No videos, animations or modules to complete online. This is proper hands-on instructor led training for your staff. Just like in a classroom, plus, all the benefits of private training. A Remote solution for effective Virtual training, delivered using either Microsoft Teams or Zoom, which are both free to download. Online IT training can be 1-to-1 or for a group of up to 6 people, plus a Per Hour option.
Benefits of Microsoft Access Level 2 Course
This Access Level 2 course is designed for those who wish to gain intermediate-level skills, or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Microsoft Access with other programs.
During this one day course, participants will learn how to design a relational database, explore table relationships and organising a database. It also covers sharing data and advanced reporting. Our Microsoft Access Level 2 course takes you from beginner level to more advanced topics and therefore prepares you for our Access Level 3 course. Our trainers are highly skilled with many years’ experience with the Microsoft suite of products.
So if you’re in the business of managing data, then our Microsoft Access Level 2 course will give you the power to handle the creation, manipulation and analysis of your organisation’s data. Please take a look through our course details for more information.
Suitability - Who should attend?
To ensure your success on this Level 2 course you would have completed the Microsoft Access Level 1.
Outcome / Qualification etc.
Each trainee will receive a Certificate of Attendance, signed by the trainer. You will also receive copies of the Evaluation Forms completed by the trainee(s) for your records.
Training Course Content
Designing a Relational Database
- Relational Database Design
- Create a Table
- Create Table Relationships
- Create Query Joins
- Join Tables That Have No Common Fields
- Relate Data within a Table
- Work with Subdatasheets
- Create Subqueries
Organizing a Database for Efficiency
- Data Normalization
- Create a Junction Table
- Improve Table Structure
Sharing Data Across Applications
- Import Data into Access
- Export Data to Text File Formats
- Export Access Data to Excel
- Create a Mail Merge
- Organize Report Information
- Format Reports
- Include Control Formatting in a Report
- Add a Calculated Field to a Report
- Add a Subreport to an Existing Report
Why choose Insight IT Training
Founded in 1998 and trained staff at more than 2,840 companies throughout the UK.
Rated excellent by more than 90% of customers and more than 60% repeat purchases.
17 specialist trainers for IT and Business Skills training, each with more than seven years of corporate training experience.
All the prices quoted are a total fixed cost and are the same for any location in the UK. Each person will receive a Certificate of Attendance, free ongoing post training support (if needed), and a comprehensive and user-friendly reference manual in pdf format.
Insight IT Training delivers standard Access courses at Introductory, Intermediate, Advanced and VBA levels, either Online, in-house or on-site at your office.
These courses can also be tailored - in content, format and duration - to meet your exact needs.
Get Inspired! Watch the Video
Insight IT Training - Customised IT and Business Skills Training, Tailored to Your Company
*We now offer Online IT training remotely to businesses in the UK and in Europe. This course is delivered remotely as a real time face-to-face communication with the trainer. You will be able to see the trainer and the trainer...
Find out more about this Microsoft Access Level 2 - Online course - simply fill out your details:
There are no reviews available yet.