Microsoft Access Masterclass | Best Practice Training

Course Introduction

Microsoft Access is an information management tool that allows the users to analyse and manage a large amount of data more efficiently than any other spreadsheet application. It is the database application in the Microsoft Office that help professionals to store information for referencing, reporting and analysis. The Microsoft Access Masterclass training course provides essential knowledge and skills required to enter, store, and retrieve data for referencing and creating reports. The course enables the delegates to create complex queries, make forms and build a database with a good relational structure. During the one day course, the delegates will learn how to create basic to advanced reports, design Access databases, manage interfaces with Access Forms and automate tasks with Macros and VBA.

Design advanced queries, forms and reports
Learn how to save your all data in one place
Use conditional formatting and advanced report techniques
Learn how Access can work with Other Microsoft Office programs
Course delivered by Certified and experienced Microsoft Trainers

What’s included

BPT offers more benefits. Here is what's included with this course:

Tutor Support

Certificate

Refreshment

Prerequisites

No formal prerequisites are required for attending the Microsoft Access Masterclass training course. However, the candidates should have basic knowledge of working with Window operating system and Microsoft Office 2010.

Delegates will learn how to

Get to know about the database and its related terminology
Learn how to create databases with objects
Work effectively with reports, data, queries and forms
Learn how to automate the processes using macros
Understand advanced Query techniques and forms
Learn to organise the database to maintain efficiency and performance
Customise reports for organising the information displayed to have specific print layouts
Discover the method to join tables for retrieving data from unrelated tables
Learn how advanced queries can be used to manipulate the data
Learn to plan and validate the data entered into the database

Target Audience

The Microsoft Access Masterclass training course is designed for anyone who wants to improve their knowledge and skill set with Access. These include:

Data Administrators
Data Analysts
Data Architects
Programmers

Course Information

Microsoft Access is a database management program that allows the users to create databases and tables, build reports and structures and insert the queries into the tables to achieve the desired results. The course familiarizes delegates to the various concepts and terminologies related to MS Access, identify how to automate the processes using macros, manipulate the data using advanced queries and customise reports for organising the information displayed to have specific print layouts. During the course, the candidates will learn how to design and build a database, how menus and ribbons work, constructing tables and table relationships, create subtotals and do calculations, how Macros can be used to automate tasks, create queries to search and interrogate their data and how Access can work with other Microsoft Office programs.

Fundamentals of MS Access

Basic queries
- Purpose and users of database
- Output type
Methods for designing Database
- Top-Down
- Bottom-Up
Collect Information
- Data mapping
- Sample data map
Normalisation
- 1stNF
- 2ndNF
- 3rdNF
Naming Conventions
Table Relationships
- Different types of relationships
Normalisation of Data

Introduction to User Interface

Access Ribbon
Quick Access Toolbar
Object Navigation Pane
Work Surface
Access Options Dialog Box
Create a database using Wizard

Generate Reports

Build a report
Add controls to a report
Improve an appearance of a report
Preparing a report for print
Organise report information
Format reports

Tables

Creating an access database
Create a new database
Different data types
Determine data types
Create a table in design view

Handling Queries

Building simple queries
Learn Dynaset
Enter criteria: exact match and range operators
Understand difference between AND versus OR
Use of wildcards
Learn about use of keywords
Sort and hide fields
Create multi-table queries
Additional tips

Forms

Forms
Alter a form
Add data records in form view
Form record navigation
View of layout
Designing of a view
One-Click Forms

Advanced Query Techniques

Create query join
Create Find Unmatched and Find Duplicate Queries
Create Parameter Queries
Use Like keyword in Parameter Queries
Create a top X query
Review calculated query fields
Summarise query data with totals
Insert WHERE statements in Summary queries
Create a crosstab query Form Wizard

Share Data with other Applications

Export table and queries to excel
Import data from .txt file
Import data from excel
Export data to a .txt file
Link external sources
Use of word merge

Maintain a Database

Backup a Database
Recover a Database
Compact a Database
Repair a Database
Save a Database as a Template
Encrypt a Database
Configure Database Options
Set a Form as The Startup Form
Use Database Tools

Delivery methods for this course

Classroom Training

Online Training

Virtual Training

Onsite Training

Microsoft Access Masterclass Classroom Schedules

Course Name	Duration		Dates	Price
Microsoft Access Masterclass	https://www.bestpracticetraining.com/training-courses/microsoft-office-training/microsoft-access-masterclass#event6100946	Scheduled	1 Day	Southampton	27-11-2020	28-11-2020	£1094	Book Now Enquire
Microsoft Access Masterclass	https://www.bestpracticetraining.com/training-courses/microsoft-office-training/microsoft-access-masterclass#event6098694	Scheduled	1 Day	London	23-10-2020	24-10-2020	£1094	Book Now Enquire
Microsoft Access Masterclass	https://www.bestpracticetraining.com/training-courses/microsoft-office-training/microsoft-access-masterclass#event6100950	Scheduled	1 Day	London	27-11-2020	28-11-2020	£1094	Book Now Enquire
Microsoft Access Masterclass	https://www.bestpracticetraining.com/training-courses/microsoft-office-training/microsoft-access-masterclass#event6108965	Scheduled	1 Day	London	11-12-2020	12-12-2020	£1094	Book Now Enquire
Microsoft Access Masterclass	https://www.bestpracticetraining.com/training-courses/microsoft-office-training/microsoft-access-masterclass#event6098695	Scheduled	1 Day	Bristol	16-10-2020	17-10-2020	£1094	Book Now Enquire
Microsoft Access Masterclass	https://www.bestpracticetraining.com/training-courses/microsoft-office-training/microsoft-access-masterclass#event6098699	Scheduled	1 Day	Manchester	30-10-2020	31-10-2020	£1094	Book Now Enquire
Microsoft Access Masterclass	https://www.bestpracticetraining.com/training-courses/microsoft-office-training/microsoft-access-masterclass#event6108968	Scheduled	1 Day	Manchester	18-12-2020	19-12-2020	£1094	Book Now Enquire
Microsoft Access Masterclass	https://www.bestpracticetraining.com/training-courses/microsoft-office-training/microsoft-access-masterclass#event6098703	Scheduled	1 Day	Reading	09-10-2020	10-10-2020	£1094	Book Now Enquire
Microsoft Access Masterclass	https://www.bestpracticetraining.com/training-courses/microsoft-office-training/microsoft-access-masterclass#event6098700	Scheduled	1 Day	Birmingham	02-10-2020	03-10-2020	£1094	Book Now Enquire
Microsoft Access Masterclass	https://www.bestpracticetraining.com/training-courses/microsoft-office-training/microsoft-access-masterclass#event6108962	Scheduled	1 Day	Birmingham	04-12-2020	05-12-2020	£1094	Book Now Enquire

Design advanced queries, forms and reports

Learn how to save your all data in one place

Use conditional formatting and advanced report techniques

Learn how Access can work with Other Microsoft Office programs

Course delivered by Certified and experienced Microsoft Trainers