Course Details
Course Duration – One day
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.
To ensure your success on this Level 2 course you would have completed Microsoft Access Level 1.
Course Content
Designing a Relational Database
- Relational Database Design
- Create a Table
- Create Table Relationships
Joining Tables
- 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
Advanced Reporting
- 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