Database

A database is a tool for organising structured collection of informations. Database can store informations about employees, clients, orders or inventory. A database allows its contents to be easily accessed, updated, stored and retrieved. Many databases start as a list in a word-processing program or spreadsheet. As the list grows bigger, redundancies and inconsistencies begin to appear in the data. The data becomes hard to understand in list form, and there are limited ways of searching or pulling subsets of data out for review. Once these problems start to appear, it's a good idea to transfer the data to a database created by a database management system.

Two examples of the database software is the well known Microsoft Access and SQL server.

Microsoft Acess 2007:-

- Microsoft Access is a Database Management System. Microsoft Access allows users to create tables, set relationships, design forms, queries and reports very easily.

- Add new data to a database, such as a new item in an inventory

- Edit existing data in the database, such as changing the current location of an item

- Share the data with others via reports, e-mail messages, an intranet , or the Internet

- Organize and view the data in different ways

- Delete information, perhaps if an item is sold or discarded





SQL server 2005 Express Edition:-

- SQL Server 2005 Express Edition is a Database Management System. SQL server is easy-to-use, lightweight, and embeddable version of SQL Server 2005.

- Simplified administration that it can automatically tune your database for optimal performance and use Microsoft Update to automatically receive the latest patches and updates, enabling a high level of security and the latest features.
- Easy to deploy your SQL Server Express databases to another computer.

- Get help fast with rich documentation, including samples and walkthroughs.

- Industry-leading data security that maintain high levels of security by encrypting data directly in the database.





refrence:-
-http://office.microsoft.com/en-us/access/HA100644501033.aspx(What is database?)
-http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx(SQL server 2005)