ARTICLES

A database is used to collect and organize data. Although an electronic version such as one created in Microsoft Access may be the first that comes to mind, there are many non-automated database versions as well, such as...

www.reference.com/world-view/purpose-database-a97b31d6abd95b9e

Primary keys are used to uniquely identify a row in a database table; no two rows can have the same primary key. Identification numbers are often used as primary keys. Any field that is not necessarily unique, such as a ...

www.reference.com/world-view/purpose-primary-key-database-43cb482ed9b6e168

A database query is designed to retrieve specific results from a database. The query is formulated by the user following predefined formats. After searching through the data, information pertinent to the query is filtere...

www.reference.com/world-view/purpose-query-database-eed11ac0e0e64754

SIMILAR ARTICLES

A query retrieves data from an Access database. Even though queries for Microsoft Access are written in Structured Query Language, it is not necessary to know SQL to create an Access query. The Query by Example screen al...

www.reference.com/world-view/purpose-query-microsoft-access-4c1f22ccdb430502

A spreadsheet is used to keep track of data and do calculations, while a database is used to store information to be manipulated at a later time. Information might start out stored on a spreadsheet, but as the amount of ...

www.reference.com/world-view/difference-between-spreadsheet-database-f5ee70f205e6c521

Data integrity testing refers to a manual or automated process used by database administrators to verify the accuracy, quality and functionality of data stored in databases or data warehouses. This test is regularly done...

www.reference.com/world-view/data-integrity-testing-f55d4e557b653af7

A database system is a high-level definition of the structure and relationship between stored data, a database or databases, users and the hardware or operating system used for the storage.

www.reference.com/world-view/meaning-database-system-b6d11196cfd749b8