click below
click below
Normal Size Small Size show me how
Access 4
Vocab #4
| Question | Answer |
|---|---|
| AND operator | a logical operator that returns true only if BOTH conditions are true |
| Arithmetic operator | symbols used to perform mathematical operations |
| Calculated field | a field in a table or query that is the result of some calculation or expression |
| Comparison operator | symbols used to compare two values (=, <, >) |
| Composite key | a combination of two or more field that uniquely describe a record |
| Conditional operator | operators that test for the truth of a condition (&, or, not) |
| Expression | allow you to perform calculations using functions, field names, numbers, text and operators |
| Foreign key | a field or combination of fields that relate to the primary key from another table |
| Join lines | when defining a relationship between tables, a join line indicates where the tables are linked by data. Indicates one to one or one to many |
| NOT operator | a logical operator that reverses the results of a search condition |
| Operator | symbol used to compare two values |
| OR operator | a logical operator that combines the output of two conditions and returns true when EITHER of the conditions is true |
| Primary key | a field to uniquely identify each record used to establish relationships between tables |
| Query criterion | a search condition use in a query to retrieve or manipulate specific information |
| Query wizard | feature to help create queries. Uses predefined steps |
| Table relationships | the association between one or more tables in a database |
| Totals | a feature that lets you add a total row to a table |