Deck 21: Database Queries - Customer Database

Question 1

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

Answer 1

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 2

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.

Answer 2

B

Question 3

Data is the essential tool of a decision maker.

Answer 3

False

Question 4

Which criterion is correct for writing a parameter query?

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

Question 5

Access uses two characters as in the matching of text fields.

Question 6

How do you remove duplicate names in the query results?

Question 7

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

Question 8

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

Question 9

It is important for _ to be able to generate their own queries.

Question 10

What trains a decision maker to use information better?

Question 11

What do queries that require more than one table require?

Question 12

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

Question 13

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

Question 14

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

Question 15

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

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

Question 16

Which of the following statements is false regarding Access queries?

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

Question 17

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

Question 18

How can you copy an entire database in Access?

Question 19

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

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

Question 20

is an essential decision- making tool.