Java Games: Flashcards, matching, concentration, and word search.

Chapter 2

AB
Aggregate FunctionsCalculations such as MIN, MAX, AVG, and SUM that are performed on a group of records.
AND ConditionA condition in which only records where all of the values are present in the selected fields.
Ascending OrderA sorting order that arranges text in alphabetical order (A to Z) or numbers from the lowest to highest number.
Between...And OperatorA comparison operator that looks for values within a range.
Calculated FieldA field that stores the value of a mathematical operation form, or report other than that listed as the field name.
Comparison OperatorsSymbols that evaluate each value to determine if it is the same (=), greater than (>), less than (<), or in between a range of values as specified by the criteria.
Compound CriteriaMultiple conditions in a query or filter.
CriteriaConditions in a query that identify the specific records for which you are looking.
Crosstab QueryA query that uses an aggregate function for data that can be grouped by two types of information and displays the data in a compact, spreadsheet-like format.
Data SourceThe table or tables from which a form, query, or report retrieves its data.
Descending OrderA sorting order that arranges text in reverse alphabetical order (Z to A) or numbers from the highest to lowest number.
Design GridThe lower area of the Query window that displays the design of the query.
Expression1. A combination of functions, field values, constants, and operators that produce a result. 2. The formula that will perform a calculation.
Field ListA list of the field names in a table.
Foreign KeyThe field that is included in the related table so the field can be joined with the primary key in another table for the purpose of creating a relationship.
Innermost Sort FieldWhen sorting on multiple fields in Datasheet view, the field that will be used for the second level of sorting.
Is Not NullA criteria that searches for fields that are empty.
Is NullWill exclude records where the specified field is empty.
Join LineIn the Relationship window, the line joining two tables that visually indicates the related field and the type of relationship.
Logical OperatorsOperators that combine criteria using AND and OR. With two criteria,AND requires that both conditions be met and OR requires that either condition be met
Message BarThe area directly below the Ribbon that displays information such as security alerts when there is potentially unsafe, active content in an Office 2010 document that you open.
One-to-Many-RelationshipA relationship between two tables where one record in the first corresponds to many records in the second table- the most common type of relationship in Access.
OR ConditionA condition in which records that match at least one of the specified values are displayed.
Outermost Sort FieldWhen sorting on multiple fields in Datasheet view, the field that will be used for the first level of sorting.
Property SheetA list of characteristics- properties- for fields or controls on a form or report in which you can make precise changes to eah property associated with the field or control.
Referential IntegrityA set of rules that Access uses to ensure that the data between related tables is valid.
RelationshipAn association that you establish between two tables based on common fields.
RunThe process in which Access searches the records in the table included in the query design, finds the records that match the specified criteria, and then displays the records in a datasheet; only the fields that have been included in the query design display.
Select QueryA type of Access query that retrieves data from one or more tables or queries, displaying the selected data in a datasheet; also known as a simple select query.
SortingThe process of arranging data in a specific order based on the value in each field.
SubdatasheetA format for displaying related records when you click the plus sign next to a record in a table on the one side of a relationship.
SubsetA portion of the total records available.
Table AreaThe upper area of the Query window that displays field list for the tables that are used in the query.
Text StringA sequence of characters.
Trust CenterAn area of the Access program where you can view the security and privacy settings for your Access installation.
Wildcard CharacterIn a query, a character that serves as a placeholder for one or more unknown characters in your criteria; an asterisk (*) represents one or more unknow characters, and a question mark (?) represents a single unknown character.


Computer Applications Instructor
Renton Technical College
Renton, WA

This activity was created by a Quia Web subscriber.
Learn more about Quia
Create your own activities