ArticlesBase.com - Free Articles Directory
Free Online Articles Directory
25.07.2008 Sign In Register Hello Guest
Email:
Password:
Remember Me 
forgot your password?


How is Ms Access Database Useful?

Author: Neha Gupta Author Ranking Blue | Posted: 12-02-2008 | Comments: 0 | Views: 190 | Rating:  (316) Article Popularity - Bronze (?) Got a Question? Ask.
Sign Up Now!

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.

Rate this Article: Current: 0 / 5 stars - 0 vote(s).

Article Source: http://www.articlesbase.com/databases-articles/how-is-ms-access-database-useful-330878.html

Print this Article Print article   Email to a Friend Send to friend   Publish this Article on your Website Publish this Article   Send Author Feedback Author feedback  
About the Author:
Submitting articles has become one of the most popular means of generating quality backlinks and targeted traffic to your website. Join us today - It's Free!

Article Comments

Comment on this article Comment on this article
Your Name
Your Email:
Comment Body
Enter Validation Code: Captcha


Got a Question? Ask.

Ask the community a question about this article:

Q&A Powered by:
Powered by Yedda 

Latest Databases Articles

Database Management Services
By: Smit Mathur | 24/07/2008
Undoubtedly a comprehensive term, Database Management Services comprise of inclusive range of activities entailing handling database, keeping it up 24 by 7 on an optimum server and ensuring dynamism and accessibility with state-of-the-art upkeep of the database.

Eliminating the Standard Textbook With Xml Content Servers
By: 10x Marketing | 18/07/2008
The Internet, the accessibility to computers and changes in the publishing industry, new resources for accessing information at universities is in high demand. With the aid of XML content servers , students and professors are finally getting access to great information at an affordable price.

How to Effectively Convert Document Into Another Format
By: Aditya patel | 10/07/2008
An effective document conversion service is very important part in a successful advance marketing business. You should focus on improving conversions at all levels of the business.

The Wide Area Network and Client Server Applications
By: Kh Atiar Rahman | 22/06/2008
Infrastructure servers provide support for wide area network (WAN) communications. This support typically includes support for a subset of IBM System Network Architecture (SNA), asynchronous protocols, X.25, ISDN, TCP/IP, OSI, and LAN-to-LAN NetBIOS communication protocols. In the Novell NetWare implementation, Gateway Communications provides a leading communications product. In the LAN Server and LAN Manager environments, OS/2 communications server products are available from IBM and DCA. In th

Geolocation in a Nutshell
By: Christopher Parker | 19/06/2008
Learn about Geolocation, pros, cons, and how it effects your internet experience.

Databases and Maintaining Their Uptime
By: Stephen J. Richards | 19/06/2008
Databases provide a convenient means of storing vast amounts of information, allowing the information to be sorted, searched, viewed, and manipulated according to the business needs and goals. A computer database relies upon software to organize the storage of data.

Migrating From Microsoft Access to Mysql
By: Intelligent Converters | 16/06/2008
This article discovers common techniques of migrating MS Access data to MySQL server and possible issues during the conversion process.

Decode Function
By: sailaja | 06/06/2008
DECODE Function helps a lot in projects.

More from Neha Gupta

Recover Data From Corrupt Access Database
By: Neha Gupta | 09/08/2007 | Data Recovery
Recover data from corrupt access database by following some simple steps. Access recovery software helps you to recover data from corrupt access database files if you are unable to recover with these measures..

Paradox Database Repair
By: Neha Gupta | 05/05/2007 | Data Recovery
What is paradox database? What is it used for and what if the paradox database gets corrupt or you cannot access the paradox database file. Paradox recovery software can solve your problems. Read to know more…

Word Recovery Software - Recover your Word Data
By: Neha Gupta | 03/05/2007 | Data Recovery
I deleted my MS Word files and then realized the importance of those files. Searched on internet and found word recovery software to recover the deleted .doc files.

Zip File Recovery
By: Neha Gupta | 23/04/2007 | Data Recovery
What is WinZip? Why is WinZip used? How the WinZip software proves helpful while transferring data? All these questions are answered in the following article.

Types of Backups
By: Neha Gupta | 20/04/2007 | Data Recovery
There are five types of backups offered by windows backup utility. These different backup types prove helpful to different individual according to the requirement. Backups can get corrupt, damage, inaccessible due to virus attacks, file deletion etc. The MS backup recovery software helps to recover the lost, inaccessible backups corrupted due to different reasons.

Tape Data Recovery Software
By: Neha Gupta | 18/04/2007 | Data Recovery
Tapes are used to store large amount of data, but the tape media can get corrupt due to unknown reasons. The inaccessible data is then recovered through Physical and Logical data recovery techniques.

How to Create Backups
By: Neha Gupta | 17/03/2007 | Data Recovery
Heard from many people about backing up data but don’t know how to do it. Read the article to know the steps of creating backups of your important data, files and folders and protect data from getting corrupt.

Why My Office Files Do not Open?
By: Neha Gupta | 12/03/2007 | Data Recovery
Have you ever wondered why is your office file not working or is not opening up with its respective program. Read on to know why all this happens and how can you correct this on your own.

Article Categories






Give Feedback

Sign up for our email newsletter

Receive updates, enter your email below