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 |