Close

MICROSOFT

Microsoft Access is a tool to manage information that helps you store information for reference, reporting and analysis. It can help you to overcome limitations you may find when you try to manage large amounts of information in Excel or other spreadsheets.

Length : 30 Hours

Introduction about Managment System

Discuss about Database

Overview on DBMS & RDMS

Concepts &Features of DBMS

Creating Database

Discuss about Constraints

Validations(Field Level & Record Level Validations)

Creating Tables

Working with Tables

Releation between Two Tables

Queries

DML

DDL

Select Query

Crosstab Query

Make-Table Query

Update Query

Append Query

Joins

Front-End & Back-End Applications

Introduction about GUI Components

Creating Forms

How to Design the Forms & Components

How to Link Between Form & Tables

Expression Builder

Creating Form using Wizard

Creating a Report

Creating a Report using Wizard

How to Display Day Wise & Monthy Reports