Why learn MS Access?

A spreadsheet is easy to maintain Delete you can sort filter and format data quite easily and quickly. But spreadsheets are not to deal with big amount of data. Microsoft Access is a relational database management system that helps to manage large datasets in a relational design. It helps to avoid data duplication. It helps to avoid data duplication. It’s the most widely used database used by beginners in the world.

This course includes

  • 5 hours plus on-demand videos

  • Downloadable resourceswn

  • Twelve months unlimited access

  • Certificate of Completion - 8 CPD credits

What you 'll learn

  • Strong understanding of the basics of MS Access.

  • How to create a database.

  • Create tables and organize your data.

  • Use MS Access queries to retrieve and manipulate data.

  • Create relationships to organize data and avoid data duplication.

  • Who should attend

    Anybody who want to learn basics of a database.

  • Prerequisites

    None. Basic knowledge of Microsoft Excel is an asset.

  • Requirements

    Microsoft Access 2016 or later. Microsoft Access 365 is preferred.

Course curriculum

  • 1

    MS Access - Introduction

    • What is MS Access

    • How to create a database in MS Access
  • 2

    Tables

    • MS Access Tables

    • How to create a table?

    • Table properties

    • Primary Key in Access Table

    • Data Entry in Access Table

    • Import data into MS Access
  • 3

    Queries

    • What is MS Access Query

    • How to create a query?

    • Query Design

    • How to add criteria in a query?

    • Date criteria in a query.

    • IN operator in a query.

    • Calculated field in a query

    • Manipulating fields

    • Grouping data in a query

    • IIF and SWITCH function

    • Creating a parameter query

    • Relationships

    • Multi Tables query
  • 4

    Forms

    • What is an Access form

    • Creating a basic form

    • Form design - Creating a form from scratch

    • Adding controls to a form.

    • Combo Box and use of wild card

    • How to add a subform

    • How to clear controls on a form

    • Display image in a form and Dlookup function
  • 5

    Reports

    • Access Reports

    • How to create report instantly

    • How to create a report from scratch

    • How to add sub totals in Access Report.

    • How to add a calculated field in MS Access Report

    • Print your report

    • Conditional Formatting in MS Access Report
  • 6

    Macros

    • Macros in MS Access

    • Automate Report Sharing

    • Pack your application