Home
Why Access
Databases
Your Project
Recent Projects
About Me
Contact Me
Gems and Tips

Databases

What is a database?

A database is collection of information that can be searched in useful ways.

A simple example is an address list. Entries (records) could be found by surname. Entries (fields) may include address, phone number, vocation etc. A simple application may be to look up someone in the address book and dial his/her phone number.

Other database examples are:-

bullet

 accounts

bullet

sales records

bullet

ordering

bullet

parts inventory

bullet

job tracking

Really here your imagination is the limit. A database can be designed for just about any type of structured data management.

Database vs. Spreadsheet

Spreadsheets are very useful, and nice and simple, but a database can do much more:-

bullet

relate data from different databases to get new information (queries)

bullet

allow changing of data in a controlled manner

bullet

forms and reports make the building of a user friendly interface easy.

bullet

handle large quantities of information.

bullet

sort and filter is easier