What is a question you ask about the data stored in a database.
What is Query
100
a record whose matching record in either the primary or related table has been deleted.
What is orphaned Record
100
a predefined style that you can apply to a form or report.
What is Autoformat
100
a selection of records whose value form the designated field matches one of two or more simple condition values
What is a list of values match
200
an access view in which you can make design changes to a form or report while it is displaying data so that you can immediately see the effects.
What is Layout View
200
the access view you use to define or modify a table structure or the properties of the fields in a table.
Design View
200
a function that performs an authentic operation on a selected record in a database
What is Aggregate Function
200
in a form based on two tables, the form that contains data from the related table
What is Subform
300
a field or a collection of fields whose values uniquely and minimally identify each record in a database table an whose values do not change
What is Primary Key
300
a collection of related tables
What is Relational Database
300
special formatting applied to field values that meet specified conditions
What is conditional formatting
300
Assigns one value to a calculated field or control if a condition is true.
What is IIF Funtion
400
a process that rearranges the data and objects in a database to descrease its file size
What is Compacting
400
including the contents of a file in a new table or appending the contents to an existing table.
What is Import
400
a query an operator asks access to compare the value in a database field to the condition value and to select all the records for which the relationship is true.
What is Comparision Operator
400
an access tool that guides you in creating an input mask for a field.
What is Input Mask Wizard
500
a primary Key field from one table that you include as a field in a second table to form a relationship between the two tables
What is foreign key
500
The value that results from not entering a value for a field.
What is Null Value
500
in a query an operator that allows you to combine two or more conditions
What is logical operator
500
a placeholder you use when you know only part of a search value or when you want the search value to start or end with a specfic character or match a certain pattern.