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
   17   18   19   20   21   22   23   24   25   26   27