Microsoft Access

• Software is a set of instruction to perform a particular task

• Database is collection of tables.

• Table is a collection of columns which stores information in the form of rows. which refers to a records.

• RDBMS or DBMS (Relational Database Management System or Database Management System) is a software which is use to manage data.

• Operations like Adding new records and modifying old records and delete the old records are performed in Database

• Various Databases are like Oracle, Microsoft, MySql.

• Microsoft Access is a graphical tool to create database and manage tables in a database.

• Simplest Example of a Database operations is a mobile phone Contacts

Mobile-> Database

Contacts-> table

Records  of our friends

firstname

lastname

middlename

mobileno

homeno

email

dob

address

All the above  are the columns of a contact table

Task we can perform on the table Data

• Add new rows

• Modify Existing Rows or data

• Delete Existing Rows or data

How to create a Database and tables in Microsoft Access

Start -> All Programs ->  Microsoft  Office ->  Access

Case Study:

I want to store information about the details of a school.

Information we need to store in a school database.

• Students

• Staff

• Class

• Exam

• Subject

• Database Name : SchoolDB

• Tables in a SchoolDB Database

1. Table Name: Students

2. Table Name: Staff

3. Table Name: Class

4. Table Name: Exam

5. Table Name: Subject

• Columns in Students Table:

RollNo.

FirstName

LastName

MiddleName

MobileNo.

HomeNo

FatherName

Mothers Name

Email

DOB

Age

Address

ClassName

LastClassScore

LastSchoolName

FeePaid

Section

• Columns in Staff Table:

FirstName

LastName

MiddleName

MobileNo.

HomeNo

Email

Address

Qualification

Post

Exp

Salary

LastSchoolName

Columns in Class Table:

ClassID

Classname

fee

• Columns for Exam Table

ClassID

SubjectID

Rollno

Marks

Columns for Subject Table

SubjectID

SubjectName

ClassID