Tuesday, March 18, 2008

How is Ms Access Database Useful?

It’s a computer world and data is saved electronically in the form of files to avoid heaps of papers and files. File system is a method for storing and organizing computer files and data they contain to make it easy to search and access them. File system provides access to data which is saved on a data storage device like hard disk where it maintains physical location of the file for easy accessibility.

For example, if you want to store the wedding anniversaries and birthdates of your relatives and friends, you can store them in file and this file will be saved at some location of your hard drive so that you can easily retrieve the information stored in this file. But when data becomes more to handle and it creates problems in accessing those files, the file system saving process also becomes poor in terms of accessibility and retrieval. In such cases traditional file system is in-efficient and in-convenient to use.

To store huge amount of data, businesses, corporate, organizations are now using Data Base Management Systems (DBMS). It contains information about a particular enterprise. It is a collection of interrelated data, set of programs to access data , and an environment that is both convenient and efficient to use. Today, DBMS are used in each and every field like banking, airlines, sales, human resources, on-line retailing, and manufacturing.

Previously, database application were built directly on top of file systems but data storage using file system resulted in to certain drawbacks, like

• Data redundancy and inconsistency

• Multiple file formats, duplication of information in different file formats.

• Difficulty in accessing data.

• Need to write a new program to carry out each new task.

• Integrity problems

• Atomicity of updates

• Concurrent access by multiple users

• Security problems

Database systems offer solutions to all the above problems. There are number of databases available in the market like MS Access, DB2, My SQL, FileMaker Pro, SQL Server, Oracle and many more. . Amongst all, Microsoft Access is the widely used database to store and retrieve information in organizations. Microsoft Access provides users with one of the simplest and most flexible RDBMS solutions in the market today. Database solutions for MS Access has been designed to help & assist Microsoft Access 97, 2000, 2002 (XP), 2003 and 2007 database users and developers of database applications to find answers of some frequently asked questions. It includes facilities to add, modify or delete data from the database, ask questions (or queries) about data stored in the database and produce reports summarizing selected contents. For example, organizations, corporates maintain database of their employees such as emp_id, emp_name, designation, salary, address, date_of_joining, highest qualification using MS Access database. Information like what’s the name of an employee and designation whose emp_id is 56 can be easily retrieved from MS Access database.

MS Access database is widely used in every field whether banking, human resources, manufacturing, payroll systems, airlines etc. When a Microsoft Access database shows an error while trying to open it then it might be possible that that particular database file is corrupt. Access database gets corrupted due to bad sectors in storage device, hardware malfunction, improper system shutdown, virus attacks etc. If a database gets corrupted then business can go down forever. There should be some access recovery software or tool which can repair the corrupt .mdb files. One such access database repair softwareavailable over internet is on the site http://www.accessdatabaserepair.net, the Kernel Recovery for Access software listed repairs corrupt access database file of MS Access 95, 97, 2000, XP and 2003. As the access repair software is available for free download to repair access file and recover data from them.

1 comment:

  1. Very nice information provided in this. while searching over the internet, i also found an access repair tool which also repairs corrupted ms-access databases. You can the detailed features from here :