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 |