Deck 9: Exploring Financial Tools and Functions

Question 1

Create a(n) _____ query to change the name of a supervisor in an Employee table.

A) Make-Table
B) Update
C) Self-Join
D) Target

Answer 1

B

Question 2

A join line is also called a _____ line.

A) query
B) connection
C) link
D) property

Answer 2

C

Question 3

All the fields selected in a(n) _____ query must match fields with the same data types in the target table.

A) Make-Table
B) Crosstab
C) Apply
D) Append

Answer 3

D

Question 4

To create an Update query in Query Design view, you use the Add to row in the query design grid.

Question 5

When building an action query, you do not change data until you click the _____ button.

A) Update
B) Select
C) Run
D) View

Question 6

After setting up a Delete query, you delete selected records by clicking the _____ button.

A) Delete
B) Run
C) View
D) Select

Question 7

Access provides four types of action queries: _____, Append, Delete, and Update.

A) Top Values
B) Crosstab
C) Make-Table
D) Inner Join

Question 8

If you are creating a query using fields from two related tables, the join line Identifies which fields establish a relationship between the tables.

Question 9

Delete queries delete entire records, not just selected fields within records.

Question 10

As with other action queries, the icon for an Append query includes a(n) _____ to remind you that it changes data when you run the query.

A) question mark
B) red asterisk
C) exclamation point
D) red X

Question 11

An action query, such as a Make-Table query, selects and changes all of the selected data when you run it.

Question 12

When you click the Delete button in the Query Type group, Access adds the Update row to the query design grid.

Question 13

Using an Append query, you can append a Short Text field from one table to a Number field in another table.

Question 14

If you want to increase the price of products in a particular category by 10%, use a(n) Append query.

Question 15

If you want to export records to another Access database, create a Top Values query.

Question 16

To remove retired employees from an Employee table, create a(n) _____ query.

A) Delete
B) Parameter
C) History
D) Update

Question 17

An Append query adds selected records to an existing table.

Question 18

A Make-Table query is a type of action query that creates a new table of data.

Question 19

If you want to remove records for discontinued products from a Products table, create a(n) Update query.

Question 20

A Make-Table query is a type of _____ query that creates a new table of data.

A) action
B) select
C) structured
D) create

Question 21

Which of the following could you use to export records to a new table?

A) Parameter query
B) Make-Table query
C) Update query
D) Delete query

Question 22

Which of the following are action queries? Select all the options that apply.

A) Delete query
B) Update query
C) Depend query
D) Append query

Question 23

As you add AND criteria to the query design grid, you increase the number of records selected for the resulting datasheet.

Question 24

Enter _____ criteria on different Criteria rows in the query design grid.

A) AND
B) Date/Time
C) null
D) OR

Question 25

_____ criteria are two or more criteria on different Criteria rows of the query design grid.

A) AND
B) OR
C) SHOW
D) SELECT

Question 26

Which of the following are true about action queries? Select all the options that apply.

A) Every action query starts as a Select query.
B) You run an action query by clicking the View button in Query Design View.
C) An action query changes data.
D) In the Navigation Pane, the icon for an action query includes an exclamation point.

Question 27

What happens if you delete a row from the query design grid?

A) You delete all the records that match the specified criteria.
B) You delete the field from the grid, but not from the field list.
C) You delete the criteria in the row.
D) You receive an error message and cannot continue deleting the row.

Question 28

What type of query should you create if you want to change a manager's name from "Jones" to "Ames" for all selected records?

A) Update
B) Select with self join
C) Is Null
D) Append

Question 29

When you change a select query to an Update query, Access displays the _____ row in the query design grid.

A) Update To
B) Totals
C) Calculated Field
D) Join

Question 30

You can add rows to the query grid, but you cannot delete them.

Question 31

The purpose of a Delete query is to _____.

A) delete fields from a table
B) correct errors in table records
C) delete records from a table
D) move records to a backup table

Question 32

After running a Delete query, you cannot _____.

A) run another action query
B) undo the deletions
C) view the table with the deleted records
D) save the query

Question 33

A(n) _____ query changes the values in a field.

A) Make-Table
B) Append
C) Update
D) Change Value

Question 34

Which of the following are ways to add records to an existing table? Select all the options that apply.

A) Enter records in Query Design View.
B) Import records from an Excel workbook.
C) Enter records directly in the datasheet.
D) Run an Append query to add records from another table.

Question 35

Which action query would you use if you wanted to add records from one table to a backup table?

A) Append query
B) Delete query
C) Backup query
D) Update query

Question 36

When you create a table with a Make-Table query, you can store the new table _____.

A) in the current database or another Access database
B) in the current database only
C) in another Access database only
D) in any Excel workbook

Question 37

A Make-Table query is a type of _____.

A) select query
B) parameters query
C) action query
D) crosstab query

Question 38

AND criteria means that all criteria must be true to select a record.

Question 39

You enter _____ criteria on the same row of the query design grid.

A) NOT
B) AND
C) TEXT
D) OR

Question 40

The fields and data types in an Append query must _____.

A) be identical
B) be different from the fields and data types in the target table
C) be different from one another
D) match the fields and data types in the target table

Question 41

A(n) self join selects all the records from the "one" table regardless of whether there is a related record in the "many" table.

Question 42

To enter data in a table, open it in Table Datasheet view.

Question 43

Which of the following statements describe OR criteria? Select all the options that apply.

A) You enter OR criteria on different rows of the query design grid.
B) You use OR criteria when any one criterion must be true to select a record.
C) As you add OR criteria to a query, you increase the number of records in the resulting datasheet.
D) You use OR criteria when all of the criteria must be true to select a record.

Question 44

Which of the following join types can you create by double-clicking a join line in Query Design View? Select all the options that apply.

A) right outer
B) left outer
C) inner
D) upper

Question 45

What kind of criteria would you use to find records with OrderDate values in May or June?

A) IS NULL
B) PLUS
C) AND
D) OR

Question 46

To select records in the Sales table that have no related records in the Customers table, create a(n) _____ join.

A) right inner
B) orphan outer
C) select inner
D) right outer

Question 47

In a database with a Products table and Orders table, you want to see which products have not been ordered. What type of query should you create?

A) Select query with a self join.
B) Update query.
C) Select query with an outer join.
D) Append query.

Question 48

If you want to find records in the table on the "one" side of a one-to-many relationship that do not have related records in the "many" side, which join do you use?

A) inner
B) self
C) left outer
D) cascade updates

Question 49

If you set the _____ property for a field that is often used for sorting, you improve database performance.

A) Sort
B) Indexed
C) Duplicates
D) Validation

Question 50

_____ criteria are two or more criteria on the same Criteria row of the query design grid.

A) AND
B) OR
C) Comparison
D) Date/Time

Question 51

Table Design view shows how each table relates to other tables in the database.

Question 52

The upper pane of _____ view shows field names and data types.

A) Table Datasheet
B) Query Design
C) Table Tools
D) Table Design

Question 53

The outer join is the default join operation in Access.

Question 54

When you add a field to a table in Table Design view, entering the field name is optional.

Question 55

In a datasheet, which mode do you use for changing the value of a field?

A) Update mode
B) Navigation mode
C) Edit mode
D) Modify mode

Question 56

To select records from the Customers table that have no related records in the Sales table, create a(n) _____ join.

A) inner
B) outer
C) self
D) referential

Question 57

_____ view is a spreadsheet-like view of the data in a table.

A) Design
B) Layout
C) Form
D) Datasheet

Question 58

Which of the following is a difference between Table Design view and Table Datasheet view?

A) Table Datasheet view does not display data.
B) Table Design view displays table relationships.
C) Table Design view does not display data.
D) Table Datasheet view does not allow changes.

Question 59

To view all the indexes in a table at the same time, use the Indexes button in Table Design view.

Question 60

How do you specify an outer join between two tables?

A) In the Relationships window, click the Modify Join button.
B) In Query Design View, double-click the join line.
C) Add the "outer" criterion to the query design grid.
D) Change the order of the fields in the query design grid.

Question 61

If you want to add records from one table to a backup table, create a(n) Append query.

Question 62

If you often sort on a field, you should set its_____ property to Yes.

A) Required
B) Caption
C) Bound Column
D) Indexed