Why learn MS Access?

A spreadsheet is easy to maintain.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’s the most widely used database by beginners in the world.

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.

Included in this course :

  • 6 hours of on-demand videos

  • Two downloadable resoures

  • Unlimited access for twelve months

  • Certificate of Completion

  • 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

Buy now

One year subscription