M.S Access 2010

INTRODUCTION 

While data is considered as raw facts, information is interpreted as prepared outcome, or we can say information is prepared after processing of data in desired direction. data can be agreed as a source of information also. A database is a place where data is put in a collective way. It helps us to manage and access large amount of information in a quick and efficient way. Database can be used after its maintenance. Adding, updating, sorting, editing, deleting data are the essential functions of a database.

A computerized record keeping system is a collection of programs that enables you to store, modify, and extract information from a database known as DMBS (database management system).

TYPES OF DBMS

There are 3 types of DBMS.

Hierarhical Database : A DBMS is said to hierarhical DBMS, when the data is organized like a tree structure. that means, it simply represents the data using parent-child relationship.

Network DBMS : A DBMS is said to be network DBMS, when it organizes the data in a network structure. As you all are aware that a network may have as many connections as it can.

Relational DBMS : A Database management system is said to be relational if it is based on relational model. this was introduced by E.F. codd 1969.

STRUCTURE OF RELATIONAL DATABASE

A relational database contains a specific structure to store data. let us learn about some basic terms related to relational database which will enhance our knowledge about functioning RDBMS.

• TABLES

Tables are the building blocks of a relational database. they store the complete data in a structured manner, i.e., in the form of rows and columns. Every table has a finite number of columns and rows.

ELEMENT OF A TABLE 

FIELDS : All the columns in a table are called fields. A field describes a particular attribute all the records in a table.

RECORDS : The rows in a table are called records. A records contains the values for all the fields that belong to a single person or entity. 

DATA : A set of characters that represents a valid value is known as data.

• QUERIES

A relational database stores vast amount of data, but queries help us to retrieve the filtered data based upon some conditions.

• FORMS

Forms are the user friendly interfaces that facilitate the process of entering data in tables and queries. A form has an attractive interface that accepts data from the user.

• REPORTS

Reports are used to display selected data in a printable format. reports collect the summarized data from one or more tables/ queries and organize it in a printable form.

INTRODUCTION TO MS ACCESS 2010 

MS Access 2010 is the important part of MS office 2010 which is used to manage relational database through a collection of programs i.e. MS Access is a RDBMS application software. It is used to organize and manipulate data. It has data in a unit referred as table. It provides facility to create relationship between these table on common fields.

SPECIALITIES OF MS ACCESS

Consider the following specialities of MS Access which makes it a unique RDBMS.

• A large information is broken into smaller parts so that it can be easy to access the information.
• Access provides the sharing of data. various users can access the information according to their needs from the same database.
• Access provides a great security towards data and maintains integrity. so that the data can be consistent and reliable.
•   User can get the required information from a database using queries.
• You can get your outcome in form of lucrative reports. these reports present the data in a meaningful and summarised manner.

COMPONENTS OF MS ACCESS 2010

Before learning about various functions of MS Access, let us get familiar with the various components of MS Access window :

CREATING DATABASE IN MS ACCESS

You can start MS Access through following steps :

1. Click start button showing on your desktop.
2. Go to All Programs.
3. Click on MS OFFICE button.
4. Click on MS ACCESS 2010.
5. Click on file tab of backstage view.
6. Select New option.
7. Click on Blank Database.

Start to do your work. 

CLOSING DATABASE

1. You can close the current database by clicking on the Close Database option of the file tab.
2. Click on File > Exit option to close MS Access.

SUMMARY

• Raw facts can be said as data while prepared outcome is referred as information.
• Database is the collection of data. It can be manipulated through computer by database management system (DBMS).
• DBMS is of three types; as HDBMS, NDBMS, and RDBMS. RDBMS works on relational model and is the most popular type of DBMS.
• MS Access is a popular RDBMS application software and component of MS Office.
• Database can be created in MS Access  from scratch, i.e., as a new way or it can be created with the help of preinstalled templates.
• These templates are also referred as sample templates. These have fields relevant to their domain.