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 |