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