Access Quiz Answers
Unlock all answers in this set
Unlock answersquestion
the basic part of a database that you work with; for example, tables, queries, forms, and reports.
answer
data type
question
the collection of related information that displays one record at a time uses this type of layout.
answer
record
question
a form that displays one record at a time uses this type of layout
answer
single form
question
a data type that automatically assigns a unique, numeric value to a field.
answer
autonumber
question
a database object used to enter new records, delete records, or update existing records
answer
form
question
the conditions used in a query to select the records that you are looking for
answer
criteria
question
this specifies the kind of information that field will hold; for example, text or numbers
answer
data type
question
a set of fields that can be added with a single click. for example, the Address data type inserts five fields for storing postal addresses
answer
quick start
question
an access field property that prevents a field in a table from having two of the same values
answer
unique
question
a database that consists of two or more tables that are related by sharing a field common to both tables
answer
relational database
question
a structural collection of related information about people, events, and things
answer
database
question
the computer software that allows people to interact with a database
answer
database management system
question
an access view that displays records in rows and fields in columns
answer
datasheet
question
each individual characteristics in a record that diplays as a single column in a datasheet
answer
field
question
a database object that displays a subset of data in response to a specific question
answer
query
question
a database object used to display the result of a query or the contents of a table on the screen or in printed form
answer
report
question
the blank row at the end of a datasheet used to add records to a table
answer
append
question
an access field that limits the number of characters that can be typed into text or number field
answer
field size
question
a rule that keeps related values synchronized
answer
referential integrity
question
an access view that displays tools to modify the format of a report or form while being able to view the data that it is intended to display
answer
layout
question
A wizard that quickly adds fields to a new query
answer
Simple Query
question
A technology that displays Quick Info, ToolTips, and AutoComplete as you type expressions
answer
IntelliSense
question
Equal to and greater than are examples of this type of operatpr
answer
Comparison
question
This dialog box is used to add tables to an existing query
answer
Show Table
question
In the query design grid, two criteria placed in the same row use this logical operator
answer
And
question
When two criteria are placed in different rows in the query design grid, this logical operator will be applied.
answer
Or
question
This wildcard charater can represent any combination of characters.
answer
Asterisk *
question
This wildcard character can represent any single character
answer
Question mark ?
question
When using a field name in a calculated field, the field's name must start and end with this character
answer
Square bracket
question
To add summary statistics to a query, this row must be added to the query.
answer
Total
question
In a query, criteria is added in this view
answer
Design
question
In a query, results are displayed in this view
answer
Datasheet
question
An IntelliSense menu of commands that match the characters you are typing
answer
AutoComplete
question
An IntelliSense box that explains the purpose of the selected AutoComplete
answer
Quick Info
question
In query criteria, dates are surrounded by this character.
answer
3
question
An operator that finds all bumbers ort dates between and including two values
answer
Between... And
question
A combination of fields, mathematical operators, and pre-built functions that calculates values
answer
Expression
question
A data type used to store values that can have one of two possible values
answer
Yes/No
question
The operator that is placed at the beginning of criteria that use wildcards
answer
Like
question
A calculation for a group of data such as a total, an average, or a count
answer
Summary Statistics
question
The arrangement of data and labels in a form or report
answer
Layout
question
A tool used to create a form where the desired fields are selected before they added to the form
answer
Form Wizard
question
An Access feature that adds fields to the form when you double-click them in the Field List
answer
Blank Form tool
question
A small picture that can be added to a form header, typically to the left of the title
answer
Logo
question
A form control that displays the name of a form by default; the actual text can be edited later.
answer
Title
question
Cells arranged in rows and columns into which controls are placed
answer
Contol grid
question
A set of special characters that control what can and cannot be entered in a field.
answer
Input mask
question
A type of form that has a subform that displays related records from another table
answer
One-to-many form
question
This name is often applied to the form that has a subform
answer
Main Form
question
By default, subforms display in this view.
answer
Datasheet
question
An Access view used to format a form or report while viewing a sample of the data
answer
Layout View
question
A layout that places labels in the first column and data in the second column
answer
Columnar
question
An Access view used to enter data in a form
answer
Form view
question
Objects on a form or report that describe each field.
answer
Labels
question
Objects on a form or report that displays the data from fields
answer
Text boxes
question
This property sheet tab contains the input mask that is replaced as you type data into the field
answer
Placeholder character
question
The symbol in an input mask that is replaced as you type data into the field
answer
Placeholder character
question
Formatting that evaluated the values in a field and formats that data accroding to the rules you specify; for example, only values over 1000 will have bold applied
answer
Conditionial formatting
question
A form contained within another form that displays records related to the other form
answer
Subform
question
When you want to build a form for a subset of data, you can base the form on this
answer
Query
question
Cells arranged in rows and columns into which controls are placed
answer
Layout
question
To combine two or more cells in a tabular layout
answer
Merge
question
This is used when you want to build a report by adding fields one at a time or arrange them in different layout
answer
Blank Report tool
question
A small picture that can be added to a reprot header, typically to the left of the title
answer
Logo
question
To display a subset of records on a report that match a given criterion
answer
Filter
question
The amount of space between a control's border and other controls on the form or report
answer
Padding
question
An Area at the beginning of a report that contians labels, text boxes, and other controls.
answer
Report Header
question
An area on the top of each page that contians labels, text boxes, and other controls.
answer
Page Header
question
An area at the bottom of each page that contians labels, text boxes, and other controls.
answer
Page footer
question
An area at the end of a report that contians labels, text boxes, and other controls.
answer
Report footer
question
A tool that can create a report with a single click
answer
Report tool
question
A page orientation where the page is wider than it is tall
answer
Landscape
question
This can be removed from a report to prevent printing blank pages
answer
Extra Space
question
This pane is used to add fields to a report in Layout view
answer
Field list
question
This pane is used to grtoup and sort reports
answer
Group, Sort, and Total Pane
question
A report formatted so that the data can be printed on a sheet of labels
answer
Label report
question
This view is used when you want the most control over your report layout
answer
Design View
question
This property is changed when you need to add page breaks before report headers
answer
Force New Page
question
A text box that displays the result of an expression
answer
Calculated control
question
When no alternating row color is desired, select this value
answer
No Color
