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

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

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

Answer 2

A

Question 3

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

Answer 3

D

Question 4

A join line is also called a _____ line.

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

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

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 7

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 8

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 9

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 10

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

Question 11

An Append query adds selected records to an existing table.

Question 12

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

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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 17

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

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

Question 18

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

Question 19

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

Question 20

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

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

Question 21

_____ 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 22

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

Question 23

A Make-Table query is a type of _____.

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

Question 24

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 25

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 26

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 27

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 28

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 29

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

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

Question 30

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

Question 31

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 32

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 33

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 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

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

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

Question 36

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 37

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 38

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

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

Question 39

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 40

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 41

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

Question 42

The outer join is the default join operation in Access.

Question 43

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

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

Question 44

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

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

Question 45

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 46

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 47

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 48

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 49

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

Question 50

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

Question 51

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 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

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 54

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

Question 55

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

Question 56

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.