MS Access Tutorial in english urdu hindi

Introduction to Ms Access:

Ms Access is the member of Ms Office suite or we can say Ms Access is the program in Ms Office family which is used to create and manage the databases. In Ms Access we can create both Simple and Relational Databases. Ms Access 2007 and later versions such as Ms Access 2010,2013 have file extension ".accdb" , while the version before Ms Access 2007 (Previous / Older Versions) have file extension ".mdb". exefile of microsoft Access is msaccess.exe. Access is a RDBMS(Relational Database Management System) application.

What is Database Management System(DBMS)?

Any application / program / software which have capability to create and handle databases.
A DBMS application mostly stored data in files, Commonly simple DBMS application lacks the relationship feature. The relationship feature allows Database objects such as tables to connect/link with each other so that the change in one object appears throughout the database.

What is Relational Database Management System (RDBMS)?

It is Powerful type of DBMS in which relationship feature is available, means it allows  objects to relate with each other.

Terms Related with Database:

Database: (Base of Data): As the name implies Database is the base of data, in simple words we can define it as the collection of information which is organized for easy access. Also we can define Database as the Collection of tables. 

Simple Database: file based database, with lack of relationship feature.
Relational Database: DBMS with relationship feature, a RDBMS application can consist on multiple objects such as multiple tables, forms, reports etc which can be related with each other and to make their relationship, the technique called relationship is used.
Table: It is two dimensional(2D) object which contains columns and rows for storing the data.
Field: In Database terms a column name such as Id, first name, last name is called Field, in other words columns in tables are called Fields.
Row: In Database terms the information related with particular person / place or any other thing is called record, in other words we can say rows in tables are called records.
Data Item: Every piece of information / data present in the cells is called Data Items.
Cell: In Database data is stored in containers which are called Cell.


Click Here to subscribe my YouTube Channel, so that you can receive updates of my latest training videos and articles

Ms Access Tutorial Part 1 

Characteristics of Database:

1.  Add Record: Means we can add records easily in Databases. 
2. Delete Record: Means we can delete record easily in Databases. 
3. Search Record: Means we can search specific record from Database easily. 
4. Sort Record: Means we can change the order of data in data base we can sort data in Ascending Order or we can sort data in Descending Order. 
5. Update record: Means we can update any specific record easily throughout the Database. 

 Qualities of a Good Database Design:

1. Easy to maintain
2. Stores data in tables and each table stores the information related with only one particular subject or purpose, such as students information should be stored in students table and teachers information should be stored in teachers table. In a  Good Database design one table can not store information of about multiple subjects such as books table can not store all information of authors and information about the publishers. 
3.  When particular piece of information is updated in one table such as address and that change automatically appears throughout the database.
4. A well designed database should contain different types of queries to show the information you need. 
5. A Single query can allow to combine data form various tables. For example we have a Database in which there 3 tables (1) employees table (2) contacts table (3)Salary Table, and you need employee name from employees table, employee mob# from contacts table and employee basic salary from salary table, it can be done with single query. 

Access Tutorials 2013