Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

1. A query can contain ____ of the fields in the table. A) one B) some C) all D)

ID: 2696495 • Letter: 1

Question

1. A query can contain ____ of the fields in the table. A) one
B) some
C) all
D) all of the above
2. To rename a field, edit the field name in the ____ and press the Tab key. A) design grid
B) datasheet selector
C) Tools group
3. ____________________ protects the data in the tables to make sure that data is not accidentally deleted or changed, resulting in inconsistent data. A) Referential integrity
B) relationship
C) field list
4. A field selector appears at the top of each column in a table and contains the field name. A) True
B) False
5. You can also resize a control precisely by watching the lower-left corner of the ____ to see the width of the control in characters as you drag it. A) Control Dialog box
B) Ribbon
C) task bar
D) status bar
6. A ____________________ is a database object that displays data from one or more tables or queries in a format that has a similar appearance to a paper form. A) datasheet selector
B) field list
C) form
7. When you open a query object, you ____ the query. A) save
B) run
C) move
8. The Split Form tool creates a form using all the fields in the selected table or query and splits the window into four panes. A) True
B) False
9. A query is a database object that lets you ask the database about the data it contains. A) True
B) False
10. An ____ control is not connected to a record source and is used to display information, lines, rectangles, and pictures A) bound
B) unbound
C) either a. or b.
D) neither a. nor b.
11. You can move a field in the design grid by clicking the bar above the field, and then dragging the field to the new location. A) True
B) False
12. To create a ____________________ between two tables, you must design the tables so they contain a matching field. A) Referential integrity
B) relationship
C) Datasheet selector
13. Eric notices that Access named the first expression in his query A query can contain ____ of the fields in the table. A) one
B) some
C) all
D) all of the above
A query can contain ____ of the fields in the table. 2. To rename a field, edit the field name in the ____ and press the Tab key. A) design grid
B) datasheet selector
C) Tools group
2. To rename a field, edit the field name in the ____ and press the Tab key. A) design grid
B) datasheet selector
C) Tools group
To rename a field, edit the field name in the ____ and press the Tab key. 3. ____________________ protects the data in the tables to make sure that data is not accidentally deleted or changed, resulting in inconsistent data. A) Referential integrity
B) relationship
C) field list
3. ____________________ protects the data in the tables to make sure that data is not accidentally deleted or changed, resulting in inconsistent data. A) Referential integrity
B) relationship
C) field list
____________________ protects the data in the tables to make sure that data is not accidentally deleted or changed, resulting in inconsistent data. 4. A field selector appears at the top of each column in a table and contains the field name. A) True
B) False
4. A field selector appears at the top of each column in a table and contains the field name. A) True
B) False
A field selector appears at the top of each column in a table and contains the field name. 5. You can also resize a control precisely by watching the lower-left corner of the ____ to see the width of the control in characters as you drag it. A) Control Dialog box
B) Ribbon
C) task bar
D) status bar
5. You can also resize a control precisely by watching the lower-left corner of the ____ to see the width of the control in characters as you drag it. A) Control Dialog box
B) Ribbon
C) task bar
D) status bar
You can also resize a control precisely by watching the lower-left corner of the ____ to see the width of the control in characters as you drag it. 6. A ____________________ is a database object that displays data from one or more tables or queries in a format that has a similar appearance to a paper form. A) datasheet selector
B) field list
C) form
6. A ____________________ is a database object that displays data from one or more tables or queries in a format that has a similar appearance to a paper form. A) datasheet selector
B) field list
C) form
A ____________________ is a database object that displays data from one or more tables or queries in a format that has a similar appearance to a paper form. 7. When you open a query object, you ____ the query. A) save
B) run
C) move
7. When you open a query object, you ____ the query. A) save
B) run
C) move
When you open a query object, you ____ the query. 8. The Split Form tool creates a form using all the fields in the selected table or query and splits the window into four panes. A) True
B) False
8. The Split Form tool creates a form using all the fields in the selected table or query and splits the window into four panes. A) True
B) False
The Split Form tool creates a form using all the fields in the selected table or query and splits the window into four panes. 9. A query is a database object that lets you ask the database about the data it contains. A) True
B) False
9. A query is a database object that lets you ask the database about the data it contains. A) True
B) False
A query is a database object that lets you ask the database about the data it contains. 10. An ____ control is not connected to a record source and is used to display information, lines, rectangles, and pictures A) bound
B) unbound
C) either a. or b.
D) neither a. nor b.
10. An ____ control is not connected to a record source and is used to display information, lines, rectangles, and pictures A) bound
B) unbound
C) either a. or b.
D) neither a. nor b.
An ____ control is not connected to a record source and is used to display information, lines, rectangles, and pictures 11. You can move a field in the design grid by clicking the bar above the field, and then dragging the field to the new location. A) True
B) False
11. You can move a field in the design grid by clicking the bar above the field, and then dragging the field to the new location. A) True
B) False
You can move a field in the design grid by clicking the bar above the field, and then dragging the field to the new location. 12. To create a ____________________ between two tables, you must design the tables so they contain a matching field. A) Referential integrity
B) relationship
C) Datasheet selector
12. To create a ____________________ between two tables, you must design the tables so they contain a matching field. A) Referential integrity
B) relationship
C) Datasheet selector
To create a ____________________ between two tables, you must design the tables so they contain a matching field. 13. Eric notices that Access named the first expression in his query 13. Eric notices that Access named the first expression in his query Eric notices that Access named the first expression in his query

Explanation / Answer

1.

A query can contain ____ of the fields in the table.

B) some

2.

To rename a field, edit the field name in the ____ and press the Tab key.

A. Design Grid

3.

____________________ protects the data in the tables to make sure that data is not accidentally deleted or changed, resulting in inconsistent data.

A) Referential integrity

4.

A field selector appears at the top of each column in a table and contains the field name.

B) False

5.

You can also resize a control precisely by watching the lower-left corner of the ____ to see the width of the control in characters as you drag it.

A) Control Dialog box

6.

A ____________________ is a database object that displays data from one or more tables or queries in a format that has a similar appearance to a paper form.

C) form

7.

When you open a query object, you ____ the query.

B) run

8.

The Split Form tool creates a form using all the fields in the selected table or query and splits the window into four panes.

B) False

9.

A query is a database object that lets you ask the database about the data it contains.

A) True

10.

An ____ control is not connected to a record source and is used to display information, lines, rectangles, and pictures

A) bound

11.

You can move a field in the design grid by clicking the bar above the field, and then dragging the field to the new location.

A) True

12.

To create a ____________________ between two tables, you must design the tables so they contain a matching field.

B) relationship

13.

Eric notices that Access named the first expression in his query