Data Base

1. Write the draw backs of using file systems to store data and purpose of using Database System?

File processing system is good when there is only limited number of files and data in are very less. As the data and files in the system grow, handling them becomes difficult. Following are the draw backs of using file systems to store data:

* Data redundancy

* Limited user access

* Lack of storage and access standards

* Lack of transaction

* Data isolation

* Security

* Integrity

A database is an organized collection of data. Database is a collection of records stored in a computer in a systematic way, such that a computer program can consult it to answer questions. For better retrieval and sorting, each record is usually organized as a set of data elements (facts)

2. Define Database Management System?

A database management system (DBMS) is a collection of programs that enables you to store, modify, and extract information from a database. There are many different types of database management systems, ranging from small systems that run on personal computers to huge systems that run on mainframes.

3. Briefly explain Microsoft Office Access?

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. Microsoft Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases, Software developers, data architects and power users can use Microsoft Access to develop application software. Like other Microsoft Office applications, Access is supported by Visual Basic for Applications (VBA), an object-based programming language that can reference a variety of objects including DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components. Visual objects used in forms and reports...