# Shared Flashcard Set

## Details

IT163 Unit 3 Glossary of Terms
Terms for Unit 3- IT163
16
Computer Science
01/20/2011

## Additional Computer Science Flashcards

Term
 AND criterion
Definition
 (AC 95-96)  The results will include only those records that match each individual criterion.
Term
 Aggregate function
Definition
 (AC 117-119) - A function that performs some mathematical function against a group of records.
Term
 Calculated field
Definition
 (AC 113) A field that can be calculated from other fields.
Term
 Comparison operator
Definition
 (AC 94)  A operator such as greater than, less then, equal to, not equal to.
Term
 Compound criterion
Definition
 (AC 95-96)  When you have more than one criterion that the data for which you are searching must satisfy.
Term
 Crosstab query
Definition
 (AC 122-125) - A crosstab query is a matrix, where the column headings come from the values in a field.
Term
 Design grid
Definition
 (AC 98-103) - The design grid is a graphical tool that allows you to create a query by placing fields from the upper half of the Query window into the design grid in the lower half of the window.
Term
 Grouping
Definition
 (AC 121-122) - When you group data in a report, you tell Access that you want certain data arranged together. For example, you might want to group order records by item number, with all the orders for a particular item number listed together.
Term
 Join
Definition
 (AC 103-107)  To find records in the two tables that have identical values in matching fields.
Term
 OR criterion
Definition
 (AC 95-96)  The results will include all records that match either individual criterion.
Term
 Parameter query
Definition
 (AC 89-92)  A query that prompts for input whenever it is used. For example it may ask for name or city.
Term
 Primary sort key
Definition
 (AC 97)  Determines the order of the records as a result of a query.
Term
 Property sheet
Definition
 (AC 100) - The property sheet contains settings that control the characteristics or appearance of the selected control.
Term
 Query
Definition
 (AC 74) - A query is a question that you ask about the data in your table(s). For example, you may want to know which of your customers bought pinto beans in March. Access searches designated tables or queries and provides you with an answer.
Term
 Sort
Definition
 (AC 97-103)  The arrangement of the data in a certain order. For example, you might want to sort order records by date ordered. You also can sort items within a group.
Term
 Wildcard
Definition
 (AC 87) - A symbol that represents any character or combination of characters.
Supporting users have an ad free experience!