click below
click below
Normal Size Small Size show me how
DBase Unit 4
Advanced Database Vocabulary Unit 4
| Question | Answer |
|---|---|
| Aggregate function | perform arithmetic operations on selected records in a database |
| AND | the logical operator you use in a query when you want a record selected only if two or more conditions are met (for example if you query "car" and "red", you would get a Red Mustang |
| Calculated field | a field that displays the result of an expression. For example, you can create a field that would calculate Discount Price – =[Price]*.80 |
| Comparison operators | used to compare records and to select all the record for which the relationship is true |
| Select query | a query in which you specify the fields and records you want to select |
| Query | a question you ask about the data in a database and Access displays the records or fields that answer that question |
| Recordset | the datasheet that is the result of a query |