| It's a computer world and data is saved | | | | • Multiple file formats, duplication of |
| electronically in the form of files to avoid | | | | information in different file formats. |
| heaps of papers and files. File system is a | | | | |
| method for storing and organizing computer | | | | • Difficulty in accessing data. |
| files and data they contain to make it easy | | | | |
| to search and access them. File system | | | | • Need to write a new program to carry |
| provides access to data which is saved on a | | | | out each new task. |
| data storage device like hard disk where it | | | | |
| maintains physical location of the file for | | | | • Integrity problems |
| easy accessibility. | | | | |
| | | | • Atomicity of updates |
| For example, if you want to store the wedding | | | | |
| anniversaries and birthdates of your | | | | • Concurrent access by multiple users |
| relatives and friends, you can store them in | | | | |
| file and this file will be saved at some | | | | • Security problems |
| location of your hard drive so that you can | | | | |
| easily retrieve the information stored in | | | | Database systems offer solutions to all the |
| this file. But when data becomes more to | | | | above problems. There are number of databases |
| handle and it creates problems in accessing | | | | available in the market like MS Access, DB2, |
| those files, the file system saving process | | | | My SQL, FileMaker Pro, SQL Server, Oracle and |
| also becomes poor in terms of accessibility | | | | many more. . Amongst all, Microsoft Access is |
| and retrieval. In such cases traditional file | | | | the widely used database to store and |
| system is in-efficient and in-convenient to | | | | retrieve information in organizations. |
| use. | | | | Microsoft Access provides users with one of |
| | | | the simplest and most flexible RDBMS |
| To store huge amount of data, businesses, | | | | solutions in the market today. Database |
| corporate, organizations are now using Data | | | | solutions for MS Access has been designed to |
| Base Management Systems (DBMS). It contains | | | | help & assist Microsoft Access 97, 2000, 2002 |
| information about a particular enterprise. It | | | | (XP), 2003 and 2007 database users and |
| is a collection of interrelated data, set of | | | | developers of database applications to find |
| programs to access data , and an environment | | | | answers of some frequently asked questions. |
| that is both convenient and efficient to use. | | | | It includes facilities to add, modify or |
| Today, DBMS are used in each and every field | | | | delete data from the database, ask questions |
| like banking, airlines, sales, human | | | | (or queries) about data stored in the |
| resources, on-line retailing, and | | | | database and produce reports summarizing |
| manufacturing. | | | | selected contents. For example, |
| | | | organizations, corporates maintain database |
| Previously, database application were built | | | | of their employees such as emp_id, emp_name, |
| directly on top of file systems but data | | | | designation, salary, address, |
| storage using file system resulted in to | | | | date_of_joining, highest qualification using |
| certain drawbacks, like | | | | MS Access database. Information like what's |
| | | | the name of an employee and designation whose |
| • Data redundancy and inconsistency | | | | emp_id is 56 can be easily retrieved from MS |
| | | | Access database. |