A query that creates a new table or changes data in an existing table
What is Action Query
100
A list of characteristics-properties-for fields or controls on a form or report in which you can make precise changes to each property associated with the field or control
What is a Property Sheet
100
A join that displays when each row from one table is combined with each row in a related table, usually created unintentionally when you do not create a join line between relates tables.
What is Cross Join
100
An object on a form or report that displays data, performs actions, and lets you view and work with information
What is Control
200
Counts the average value for a column, ignoring null values.
What is the Average
200
An action query that removes records from an existing table in the same database.
What is Delete Query
200
Determines picture size
What is a Picture Size Mode Property
200
A join that allows only the records where the common field exists in both related tables to be displayed in query result
What is Inner Join
200
A predesigned set of colors, fonts, lines, and fill effects that look good together and that can be applied to your entire document or to specific items
What is a Theme
300
Counts the number of items in a column, ignoring null values
What is the Count
300
An action query that creates a new table by extracting data from one or more tables.
What is Make Table Query
300
Determines placement of background picture
What is the Picture Alignment Property
300
A join that is used to combine rows from two data sources based on field values that are not equal
What is Unequal Join
300
A combination of functions, field values, constants, and operators that produce a result
What is an Expression
400
Measures how widely values are dipersed from the mean value
What is Standard Deviation
400
A query that calculates subtotals across groups of records
What is Totals Query
400
Enables addition of descriptive text for a control
What is the Status Bar Text Property
400
A join that is typically used to display records from both tables, regardless of whether there are matching records.
What is Outer Join
400
Data that does not change
What is Static Data
500
Measures the statistical variance of all values in the column.
What is Variance
500
A query that prompts you for criteria before running the query
What is Parameter Query
500
Enables addition of descriptive text for a control
What is the Status Bar Text Property
500
A relationship that helps a query return only the records from each table you want to see, based on how those tables are related to other tables in a query
What is Join
500
The action of moving your mouse pointer over something on your screen