Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
106 Cards in this Set
- Front
- Back
A pattern match uses ____ characters. |
Wildcard |
|
A _____ selects records with a value for the selected field that matches the pattern of the simple condition value |
Pattern match
|
|
Double-click the ____ of a field list in Design view to highlight all the fields |
Title Bar |
|
You create the selection criterion for a non matching value using the ____ logical operator |
not |
|
The _____ symbol is a concatenation operator that joins text expressions |
& (ampersand) |
|
The aggregate function _____ returns the number of non null field values in a selection of records |
count |
|
The aggregate function ____ returns the variance of the field values in a selection of records |
Var |
|
A ______ query is a select query that locates duplicate records in a table or query |
find duplicate |
|
If you want to display all students who have the same phone number, you would use a _____ query |
find duplicates |
|
SQL stands for ______ and is a standard language used in querying, updating, and managing relational databases |
Structured Query Language |
|
For the ______ property, you enter either an integer or a percentage to determine how many records display |
Top Values |
|
A _____ field lets the user select a value form a list of possible values |
look up |
|
An ______ is a predefined format used to enter and display data in a field |
input mask |
|
The capability to update field properties in objects automatically when you modify a table field property is called _______ |
property propagation |
|
An _____ exists between two objects when a change to the properties of data in one object affects the properties of data in the other object |
object dependency |
|
A table _____ rule compares one field value in a table record to another field value in the same record to verify their relative accuracy |
validation |
|
To make sure that a user enters a value in one table field that is chronologically either, for example, than the value in another field in the same record, you can set Validation Rule and Validation Text properties for the ____ instead of for an individual field |
table |
|
To open the Find and Replace dialog box, click the Find button on the _____ tab |
home |
|
The values specified for a search operation can be exact values or they can include a _____ character |
wildcard |
|
To create a form based on two tables, you must first define a ____ between the two tables |
relationship |
|
When you create a form containing data from two tables that have a one-to-many relationship, Access uses the defined relationship between the two tables to automatically join the tables through the _____ that exists in both tables |
common field |
|
Forms for tables that have a one-to-many relationship will have a ______ form and a subform |
main |
|
When creating a form based on two tables, you create a subform for data from the _____ table |
related |
|
The Access feature that can guide you through the creation of a report by asking questions is called the _______ |
Report Wizard |
|
The set of field values for the fields in a report that belong to a related table are called _____ records |
detailed |
|
In a form with a main form and a subform, there will be two sets of ____ buttons for use in selecting records from each of the tables |
Navigation |
|
When in Print Preview, you can use the _____ to toggle between a full page display and a close-up display |
The pointer full page display |
|
To print a single page of a report, first click the ____ button in the Print group on the Print Preview tab |
|
|
The ____ button lets you search for specific data in a form and display only the qualifying records |
find |
|
A _____ is a predefined set of formats that enhance a form's appearance and usability |
theme |
|
To move multiple controls on a report, hold down the ___ key to select them all so you can move them as a unit |
shift |
|
The ____ symbol appears in the upper-left corner of a form to indicate the form is in editing mode |
pencil |
|
_______ in a report or form is special formatting applied to certain field values depending on one or more conditions----similar to criteria you establish for queries |
Conditional formatting |
|
Use the ____ wildcard symbol to match any single numeric character |
# (pound sign) |
|
You can use the ____ property to enter an optional description for a field to explain its purpose or usage |
description |
|
A ____ is not required for a field, but it is a useful way to explain its purpose or usage |
Description property |
|
You create a database by first identifying all the _____ needed to produce the required information |
fields |
|
A field or collection of fields that uniquely identifies a record within a table is the ____ |
primary key |
|
If no one field can be used to make each record unique, you can use a _____ as the primary key |
Composite Key |
|
A foreign key is a field in one table that is also defined as a ____ in a different table |
primary key |
|
The characteristics of a field that determine how it is stored and displayed are called the field ____ |
properties |
|
The name that you use to save a table must be ____ within the database |
unique |
|
When you select or enter a value for a property, you ____ the property |
set |
|
If you have a Customer ID field with values like 1234AC, you should use the ____ data type |
text |
|
The ____ format is used for currency fields with no dollar signs |
standard |
|
When a primary key has been specified, Access forces you to enter a value for the primary key field in every record din the table. This is known as _____ |
entity integrity |
|
Once you click the ____ button to open the Show Table dialog box, you can choose a table to add to the Relationships window, as shown in the accompanying figure |
Show table |
|
You can quickly insert the value from the same field in the previous record using the ____ keyboard shortcut |
ctrl + |
|
When you want to import data from an Excel worksheet into an Access table, any ____ property values set for the fields in the table are not considered in the import process |
Caption |
|
You use the ____ tab if you want to import data from an Excel worksheet |
External data |
|
The ____ allows you to add a group of related fields to a table at the same time, rather than adding each field to the table individually |
Data type gallery |
|
When you change a field's property in Design view, you can ____ or update the corresponding property on forms and reports that include the field you have modified |
propagate |
|
In the ____ you include the fields and record selection criteria for the information you want to see |
design grid |
|
The default query name is____ |
query 1 |
|
When you create a query, you tell Access what ___ should be used to select the data |
criteria |
|
It is a good idea to build specialized and complicated queries by using the ______ |
Query Wizard |
|
To include a field in a query, you can click and ____ the field from the field list to the design grid |
drag |
|
The results of a query can be seen at any time by pressing the _____ button |
View or run |
|
You can tell if a field will appear in the query data sheet if there is a check mark in the fields ____ check box in the design grid |
show |
|
When the sort field is ___, records with the same sort field value are grouped together, but they are not in a specific order within the group |
Nonunique |
|
If multiple records can have the same value in the field specified as the sort field, the sort field is ____- |
nonunqiue |
|
When you specify a sort using two or more nonadjacent sort fields, you must specify the sort fields in ____ view |
design |
|
A query operator that asks Access to match the values of a database field to the selection criteria is known as a _______ |
comparison opertator |
|
A condition usually consists of an operator, often a comparison operator, and a _____ |
value |
|
To define a condition for a field, you place the condition in the field's _____ box in the design grid |
Criteria |
|
The condition that requires a value in a specified field to be identical to the specified condition is called an _____ |
exact match |
|
A _____ is a predefined set of formats including colors, fonts and other effects that enhance an object's appearance and usability |
theme |
|
Specifying multiple conditions in query requires the use of ____ to combine two or more conditions |
logic operators |
|
In complex expressions, you can enclose calculations in _____ to indicate which ones should be performed first |
parenthesis |
|
A ____ field displays the results of an expression |
calculated |
|
A set of data such as first name, last name, address, etc. for a specific person is a _____ |
record |
|
The content of a field is the _____ |
field value |
|
A group of related tables is called a ____ database |
relational |
|
Data in one or more tables can be related to each other by means of a _____ field |
common |
|
In a given table, a field is defined as a ____ when its values uniquely identify each record in the table |
primary key |
|
A relational DBMS provides protection of ____ through security, control and recovery facilities |
databases |
|
Access has a built-in _____ language that allows you to ask questions and obtain answers about your data |
query |
|
You can search for a ____ and download it from Office.com |
template |
|
Give fields descriptive ____ so that you can easily identify them when you view or edit records |
names |
|
The _____ determines what field values you can enter for the field |
data type |
|
A table's ____ includes the field names and characteristics of the fields themselves, plus any layout changes to the datasheet |
design |
|
To close an open database without exiting the Access program, click the File tab to display Backstage view, and then click ______ |
close database |
|
To view field or records that are not visible on you display, you can use the vertical or horizontal _____ |
scroll bars |
|
When you create a ____ you tell Access which fields you need and what criteria Access should use to select the records that will answer you quetsion |
query |
|
You use a ____ to enter, edit, and view records in a database |
form |
|
Each object in the Navigation Pane has a unique ____ to indicate the type of object |
icon |
|
A form's ____ property specifies the table or query that provides the fields for the form.
|
Record Source
|
|
To create a _____ form, you can modify and existing form or design and create a form from scratch.
|
Custom
|
|
A ____ is a control that provides the features of a text box and a list.
|
Combo Box
|
|
In addition to printing the Relationships window, you can use the ______ to create detailed documentation of all, or selected, objects in a database.
|
Documenter
|
|
The ____ tool creates a form in a data sheet format that contains all the fields in the source table or query.
|
Datasheet
|
|
The ____ took creates a customizable form that displays multiple records from a source table or query in a data sheet format.
|
Multiple Items
|
|
The ____ tool creates a customizable form that displays the data in a form in both Form view and Datasheet view at the same time.
|
Split Form
|
|
A _____ is a set of controls grouped together in a form or report, so that you can manipulate the set as a single control.
|
Control Layout
|
|
The _____ property for a control automatically resizes the control and places the control in the same relative position on the screen as the screen size and resolution change.
|
Anchor
|
|
A ____ is a separate form contained within another form.
|
Subform
|
|
A ____ form is a form that has a table or query as its record source.
|
Bound
|
|
If you want a label to display different text on the form, you need to change the label's _____ property value.
|
Caption
|
|
_____ handles let you resize a control.
|
Sizing
|
|
The handle in a control's upper-left corner is its _____, which you use to move the control.
|
Move Handle
|
|
A ____ Wizard asks a series of questions and then uses your answers to create a control in a form or report.
|
Control
|
|
You can remove a section by setting its height to ______.
|
Zero
|
|
The _____ property determines if Access displays a control or section.
|
Visible
|
|
To calculate the total of an expression, you use the ____ function.
|
Sum
|
|
The _____ property specifies whether users can use the Tab key to move to a control on a form.
|
Tab Stop
|
|
The ______ button allows you to change the background color of a control, section, or object.
|
Background Color
|