da·ta·base: A collection of data arranged for ease and speed of search and retrieval; an organized body of related information

....Ready-Made ....... Databases:

A well-designed database

• Organizes and keeps track of vital information
• Allows quick access to information
• Stores and updates data in only one place
• Prevents duplicate and inconsistent data
• Is easily navigated
• Simplifies data entry
• Stores data in the proper format
• Has enormous capacity
• Grows with you
• Is secure
• Accommodates a wealth of informational needs

A relational database is a collection of data stored in various tables that is 'related' to data in other tables
It is a tool which can store, manage and disseminate information of various kinds. The information from the separate tables can be used, retrieved and displayed together.

• Forms are used for data entry and to view data
• Queries are used to retrieve information
• Reports display information in a format determined during the design process

Spreadsheet versus Database
A spreadsheet stores data in rows and columns - it is a 'flat' storage system. It is the computer equivalent of a paper ledger. Each row is one record. As more and more data is tracked for one record, columns are added. Microsoft Excel is a spreadsheet program.

Relational databases are more versatile than spreadsheets. Because data is stored and updated in only one place, a database can eliminate duplications and inconsistent data. Data is easy to retrieve. Microsoft Access is a relational database program. Mathematical calculations can be performed in Access, and data can be imported from and exported to Excel and integrated with other Microsoft Office programs.

For more information or a project quote, contact
Kitty@SchneiderDatabaseDesign.com
Minneapolis, MN - Phone 612- 875-1452