Deck 22: Database Queries - Inventory Database

Question 1

Give an example of a computation.

Answer 1

Computations can be applied to numeric fields and date fields. Assume that the decision maker wants to know the number of points needed for an "A" grade for each project. An "A" would be calculated as 90 percent of the total possible points.

Question 2

A _ is a wildcard match for a single character.

Answer 2

question mark

Question 3

Why is it important for decision makers to be able to generate their own queries?

Answer 3

The decision maker who can create a query gains immediate access to the power of a database. The decision maker may not know exactly which records in the database are needed until a query is generated, its results are seen, and more queries are created in an iterative process until the desired results are generated. An intuitive understanding of the database cannot occur unless the decision maker gains a hands- on understanding of the data values and relationships in the database.

Question 4

Which criterion is correct for writing a parameter query?

A)<(price should be below)
B)price is C)<[price should be below]
D)

Question 5

Typing <75 or >100 in the Criteria row is the correct use of the OR query in QBE.

Question 6

Sometimes a decision maker will know which constrains a query but not know the value of the constraint.

Question 7

Which of the following is an incorrect use of wildcard characters?

A)Like "*Management*"
B)Like "*Management"
C)Like "#i*"
D)Like "?i*"

Question 8

The is a wildcard that matches any value or string of values, even a null value.

Question 9

Constraints on fields containing text can be difficult to create because what constitutes a match might be ambiguous.

Question 10

Without the between the tables, the query does not restrict itself to records that match.

Question 11

What do managers use queries for?

Question 12

The correct method of writing a query so that the results produce the prices that are greater than or equal to $50 but less than or equal to $75 is:

A)>=50 Or <=75.
B)>$50 And <$75.
C)>=50 And <=75.
D)>=$50 And <=$75.

Question 13

Data is the essential tool of a decision maker.

Question 14

Give an example of why a decision maker would use a parameter query.

Question 15

Which of the following statements is false regarding Access queries?

A)The top row is where the table name is displayed.
B)The last row is for "or" criteria to be typed.
C)QBE is a format where a user can specify what is desired without having to write computer code to retrieve records from the database.
D)The third row provides an option of sorting the results.

Question 16

Which of the following is not a method for creating a query?

A)double- clicking Create query by using wizard
B)double- clicking Create query in design view
C)clicking the New button on the toolbar
D)double- clicking Create query in table view

Question 17

What is data field concatenation?

Question 18

To see the results of a query, choose View, then choose Datasheet View.

Question 19

When using in a query in which there is no matching value between the tables, the records with no match are not displayed in the query results.

Question 20

Action queries let the user provide a value as the query runs.