click below
click below
Normal Size Small Size show me how
Access Vocab
BIM 2015
| Term | Definition |
|---|---|
| Alphanumeric data | data that contains numbers, texts , or a combination of both . |
| AutoNumber | a data type that automatically adds a unique field value to each record. |
| Condition | specifies which data to display in a query result |
| Data Type | the property of a field that determines the type of data that you can enter into the field |
| DataBase | A collection of objects that work together to store , retrieve , display , and summarize data |
| Datasheet | Displays the data for a table or query in rows and columns |
| Datasheet selector | the box in the upper left corner of a datasheet that , when clicked , selects all fields in the datasheet |
| Design View | The view of a table that lets you add , delete , and , and rearrange fields . |
| Detail Query | query that shows every field in every record |
| Field | A single characteristic in a table's design that appears in a datasheet as a column |
| Field Name | the name of a column in a database table |
| Field Property | an additional description of a field beyond the data type, such as the number of characters the field can store |
| Filter | a temporary rearrangement of the records in a table , query , form , or report based on one or more specified conditions |
| Multitable Query | a query that is based on the data in two or more tables |
| Query | a database object that lets you search the database for data it contains. |
| Record | the collection of field values for a complete set of data |
| Record Selector | The box to the left of a record in a database that selects the entire record |
| Primary Key | The field in a database table that contains a unique value for each record |