MS-Access is a RDBMS (Relational Database Management System) which is used to maintain database for specific organization (Like: - School, College, Bank, Company etc.) MS-Access is an object oriented package. User can enter huge records within a file. MS-Access provides us the great feature to make relationship between multiple tables with data retrievable facility also (means add new records, delete, and modify etc.) 
 MS-Access file known as database and extension is “.MDB” or “ACCDB”.
 How to start MS-Access:-
Ø Click on start button
Ø Click on all programs
Ø Click on Microsoft office
Ø Click on Microsoft Access 2010
OR

Ø Press Windows Button + R (Run) à Type msaccessà Ok

Database: - A database is a collection of all those multiple tables which provide for maintain all records and prepared for all types of reports of an organization, institute, college, school etc.
Ex: - Student table
                    Fee table
                    Exam table
 There are six objects in MS-Access:-
Ø Table
Ø Query
Ø Form
Ø Report
Ø Macro
Ø Switchboard
 
Table object: - This is primary object of MS-Access which uses to create the structure of table according to user needs and enter large amount of information based on structure.
There are two view of table object:-

Ø Design view: - For create the structure as user needs.
Ø Datasheet: - For enter the records according to structure.

 How to create Table in MS-Access:-
Process:-
Ø Open MS-Access
Ø Click on blank database
Ø Enter any name
Ø Click on create button
Ø Click on view icon and select design view
Ø Enter your table name and ok

Ø Define the structure as you need

Field Name	Data type
Roll	Auto No
Name	Text
Add	Text
Course	Text
Fee	Currency
D_O_B	Date/Time
Remark	Memo
Picture	Ole object
Link	Hyperlink
Pin code	Number
Regular	Yes/no
Attachment	Attachment

Ø Click on datasheet view
Ø Click on yes
Ø Enter the records

Roll	Name	Add	Course	Fee	D_O_B	Remark	Memo

How to Insert Picture?
Process
Ø Mouse Right Click
Ø Click on insert object
Ø Then a dialog box open
Ø Click on create new
Ø Select Microsoft word document from object type
Ø Then Microsoft word will open
Ø Click on insert button
Ø Select your picture
Ø Click on close buttion

 How to Create Hyperlink?
Process
Ø Mouse Right Click
Ø Click on hyperlink
Ø Click on edit hyperlink
Ø Then a dialog box open
Ø Select your file
Ø Click on ok

 How to Attach File?
Process
Ø Mouse Right Click
Ø Click on Manage Attachment
Ø Then a dialog box open
Ø Click on add button
Ø Then a dialog box open
Ø Select your file
Ø Click on open

Ø Click on ok