click below
click below
Normal Size Small Size show me how
Access vocab review
Access
| Database | Definition |
|---|---|
| Field | A piece of data stored about each record in a table. |
| Record | The stored info about one particular instance, such as one persons data in an address book. |
| Form | A view of the table or query’s data, designed for look up or input of data. |
| Object | An item an access database such as a table, query , form, or report. |
| Primary key | A field (or group of fields) identifies a given entity in a table. |
| Table | A collection of records that share the same fields. |
| Report | A printable layout of the data from a table or query. |
| Database management system | A computer program that includes both the store database and the tools required to use the database. |
| Query | A speculation that describes how a set of records should be sorted, calculated or presented. |
| Relational database | A database that uses more than one table. Tables are linked together by common data items, such as ID number, known as keys. |
| Datasheet view | The spreadsheet – like view of the table in which each record is a row and each field is a column |