question

related or connected

answer

Access is a relational database program you can use to create tables that are ____ within the same database.

question

file management system and relational database management system

answer

What are two general categories of database management systems?

question

the ability to define relationships between tables

answer

Which of the following features is found in a relational database management system but not in a file management system?

question

data redundancy

answer

A relational database management system eliminates the need for

question

primary and foreign

answer

A database table can contain these two different types of keys

question

one

answer

A table should be about ____ subject(s)

question

the primary key field

answer

When a table is opened, it is sorted by

question

cannot

answer

A primary key field ___ contain the same value for different records.

question

foreign

answer

When a relationship is established between two tables, the primary key in one table is joined to the ___ key in the other table.

question

must

answer

Data in a foreign key field ___ match data in the primary key field of the related table.

question

primary

answer

In a one-to-many relationship, the table containing the "one" is referred to as the ___ table.

question

Drag the common field from the primary table to the related table.

answer

In defining a one-to many relationship between two tables, what is the next step after having placed the two tables in the relationships window?

question

the infinity symbol

answer

In the Relationships window, what symbol or character signifies the "many" side of a one-to-many relationship?

question

the primary table; the related table

answer

Choosing Cascade Update Related Fields and Cascade Delete Related Records in the Edit Relationships dialog box will cause primary key updates and deletes in ___ to be automatically executed in __.

question

Relationships window

answer

Once a relationship has been established between tables, clicking the Relationships button causes the ___ to display.

question

expand indicators

answer

The plus symbols (+) in a subdatasheet are referred to as

question

query

answer

You can extract specific information from a table or multiple tables by running a(n)

question

extract specific data from a table

answer

Queries are used to perform one of the most important database functions, which is to

question

save as a .qry file

answer

You can build a query in all the following ways except

question

CREATE

answer

Create a query design button in the queries group on the ___ tab.

question

add the relevant table(s) or queries to the work area

answer

When creating a new query with the Query Design button, the first thing you will need to do after clicking the button is to

question

type the criterion statement

answer

To establish a criterion in the query design grid, click inside the appropriate Criteria row field and then

question

Results

answer

In which group on the QUERY TOOLS DESIGN tab will you find the Run button

question

asterisk (*)

answer

Which character is used as a wildcard symbol in query design

question

quotation marks (" "); pound symbols (#)

answer

When you enter criteria statements in your query design grid, access automatically enters __ around criteria in text fields and ___ around criteria in date fields.

question

"S*"

answer

Which of the following criteria statements would return field values beginning with S and ending in anything?

question

field values that begin with S through W and end in anything

answer

What would the criteria "[S-W]*" return?

question

lowest to highest

answer

When you choose Ascending in the query design grid's Sort row field for a numeric data field,the results will be sorted

question

Object type

answer

If you have several queries in your database and would like to see them displayed together in the Navigation pane, click the Navigation pane Menu bar and then click ___ at the drop-down list.

question

Or

answer

When a field in a query contains two criteria statements, either of which can be met to return results, this is referred to as a(n)___statement.

question

And

answer

Multiple criteria all entered in the same row in the query design grid is considered a(n)___statement.

question

calculated

answer

A query field that uses a mathematical equation to determine the contents that display is called a __field.

question

forward slash (/)

answer

In creating a calculate field, what symbol do you use for division

question

brackets ([])

answer

When creating a calculated field, use __ to surround the fields names

question

colon (:)

answer

When creating a calculated field in a query, the field name should be separated form the equation by a(n)

question

column heading names

answer

In the results of a query using aggregate functions, Access automatically determines the

question

one row to display in the results datasheet for each group

answer

In the Crosstab Query Wizard, the first field you select causes

question

three

answer

What is the minimum number of fields needed to create a crosstab query

question

it is summarized by aggregate function

answer

What happens to the third field selected in the Crosstab Query Wizard

question

one table or query

answer

Crosstab queries must be built from fields contained in

question

find duplicates

answer

If you suspect that a client has been entered into your Clients table under two different client numbers, you would use a ___ query to find the problem

question

find duplicates

answer

The ____ query is useful in identifying loyal customers in an Orders table.

question

find unmatched

answer

Which of the following query types requires two tables?

question

records in one table that have no matching record in the other related table.

answer

A find unmatched query finds

question

to find customers who have never placed orders

answer

In which of the following situations would you use a find unmatched query.

Databases Ch2 ; 3 review – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards