click below
click below
Normal Size Small Size show me how
Access Vocab Les3
Access Vocabulary Terms Lesson 3
Question | Answer |
---|---|
Query | database object that lets you aks the database about the data it contains |
Condition (Criterion) | a way of telling the query which data you are interested in seeing |
Simple Query Wizard | asks you what data you want to seee by letting you select options in dialog boxes |
Sort | when you view field values in ascending or descending order from A to Z or smallest to largest |
Filter | temporarily displays records in a datasheet based on the condition that you specify |
Filter By Selction | you select a field value in a datasheet and click the Selection button in Sort & Filter group on the Home tab |
Filter By Form | click Advance button in the Sort & Filter group in the Home tab; displays records that have more values based on values stored in one or more fields |
AutoFilter | a menu that opens when you click the arrow on the right side of a field selector |
Relationship | database management system that lets you connect the data in the tables |
Common Field | field that appears in both tables, has the same data types and contains the same values |
One-To-Many Relationship | one record in the first table records the second table |
Foreign Key | common field in the related table |
Referential Integrity | protects the data in tables to make sure data is not accidentally deleted or changed |
Subdata Sheet | contains the related records in orders talbe |
Multable Queries | a queries that are based on more than one table |
And Operator | selects records that match all of two or more conditions in query |
Or Operator | selects records that match at least one of two or more conditions in a query |
Total Row | counts number of values in a column |
Calculated Field | a field displays a value that is calculated using other fields in the query |
Expression | the calculation in a calculated field |