Shared Flashcard Set

Details

Access Chpt 2
Study Guide
26
Computer Networking
Undergraduate 1
08/25/2010
Click here to study/print these flashcards.

Create your own flash cards! Sign up here.

Additional Computer Networking Flashcards

 

 

Cards

Term
To omit duplicates, you should change the ____ property from No to Yes.
 Definition
Duplicates Out
Term
Most of the time you will use ____ view to create queries.
 Definition
Design
Term
A common ____ is to exclude duplicates
 Definition
restriction
Term
If data is to be grouped by two different types of information, you can use a ____.
 Definition
crosstab query
Term
To combine criteria with OR, the criteria must go ____ in the Criteria area of the grid.
 Definition
on separate lines
Term
The comparison operators do NOT include ____.
 Definition
D: equal to
Term
Access includes a tool to help you create complex expressions called __
 Definition
Expression Builder
Term
You create a parameter by enclosing a value in a criterion like this example: ____.
 Definition
[value]
Term
Creating a ____ allows you to quantify the results, that is to choose how many records to show.
 Definition
top-values query
Term
To use text data in criteria, simply type the text in ____ below the corresponding field name.
 Definition
the Criteria row
Term
Words such as "increasing" or "low-to-high" imply ____ order.
 Definition
Ascending
Term
When using a crosstab query, one of the types of data will form the ____.
 Definition
row headings
Term
To order the records in the answer to a query, you ____ the fields.
 Definition
compound criterion
Term
If the calculation you require is to have the values in two fields added together, this is a(n) ____ calculation
 Definition
individual record
Term
If you enter a(n) ____ in brackets, Access assumes you want that particular field and does not prompt the user
Definition
field name
Term
To join tables you need to find records in the two tables that have ____.
 Definition
identical values in the matching fields
Term
____ are symbols that represent any character or combination of characters.
 Definition
Wildcards
Term
Words such as "decreasing" or "high-to-low" imply ____ order.
 Definition
Descending
Term
Results of mathematical operations are typically ____.
 Definition
NOT stored in the database
Term
When joining two tables, Access will draw a ____ between matching fields in the two tables
 Definition
join line
Term
Six query guidelines were listed in the chapter. The following was NOT one of the guidelines: ____.
 Definition
Adjust the database structure
Term
The less important sort field is called the ____.
 Definition
Minor Key or Secondary Key
Term
If you want something other than an exact match you must enter a ____.
 Definition
comparison operator
Term
A field that can be computed from other fields is called a ____.
 Definition
calculated field
Term
To use text data in criteria, simply type the text in ____ below the corresponding field name.
 Definition
the Criteria row
Term
To use text data in criteria, simply type the text in ____ below the corresponding field name.
 Definition
Supporting users have an ad free experience!