Page 22 - ModularV1.1 _c8_flipbook
P. 22
03 INTRODUCTION TO
MS ACCESS 2010
Your Aim
to learn about:
l MS Access 2010 l Features of MS Access 2010
l Components of MS Access 2010 l Creating a Database
l Types of Views in MS Access l Adding Fields to a Table
l Data Types in MS Access 2010 l Rules for Writing a Field Name in MS Access
l Setting a Primary Key
In the previous chapter, you have learnt about the basics of data and database. In this chapter,
you will learn about MS Access.
MS ACCESS 2010
MS Access 2010 is an easy-to-use Relational Database Management System
developed by Microsoft. It is a part of MS Office Suite. It provides handy tools
and graphical user interface (GUI) to maintain and manipulate the records more
efficiently. It prevents the duplication of data and allows you to add, delete, modify MS Access 2010
and update the records by establishing a relationship between the tables. Some
other examples of relational database management systems are Oracle, MySQL and LibreOffice Base.
To start MS Access 2010, click on Start → All Programs → Microsoft Office → Microsoft
Access 2010. This will open the MS Access window.
FEATURES OF MS ACCESS 2010
Some of the important features of MS Access are:
It is easy-to-use and ideal application for individual users and smaller teams.
It allows to import and export to other Microsoft Office and other applications.
It provides templates for regular users to create and publish database.
It reduces data redundancy.
It allows to generate and format printable reports.
It helps to search and access data efficiently.
It allows to create forms for modifying and inserting records into your databases.
It combines data from multiple tables and places specific conditions on the data retrieved.
20 Modular (Ver. 1.1)-VIII

