WorksheetsBIM I Unit 3 Vocab Quiz a
Total questions: 80
Worksheet time: 7hrs 40mins
Name
Class
Date
1.
Attachment Data Type
a)
data type which stores pictures, images and other Microsoft® Office files in a field
b)
data type which includes the Yes/No format as well as True/False and On/Off in a field; data type is used when the value can only be one of two possible answers
c)
data type which accepts only letters, numbers and a few types of punctuation
2.
AutoNumber Data Type
a)
data type which inserts a unique value to each record in a table
b)
data type which stores pictures, images and other Microsoft® Office files in a field
c)
data type which includes the Yes/No format as well as True/False and On/Off in a field; data type is used when the value can only be one of two possible answers
d)
data type which accepts only letters, numbers and a few types of punctuation
e)
None
3.
Backing Up a Database
a)
process of making a copy of the database file to protect the database against loss or damage
b)
data type which inserts a unique value to each record in a table
c)
data type which stores pictures, images and other Microsoft® Office files in a field
d)
None
e)
None
4.
Currency Data Type
a)
data type which is used when monetary values are entered
b)
process of making a copy of the database file to protect the database against loss or damage
c)
data type which inserts a unique value to each record in a table
d)
None
e)
None
5.
Data Type
a)
field property which controls the type of data a field stores
b)
data type which is used when monetary values are entered
c)
process of making a copy of the database file to protect the database against loss or damage
d)
data type which inserts a unique value to each record in a table
e)
None
6.
Database Design
a)
process of determining fields, tables and relationships needed to satisfy the data and processing requirements
b)
field property which controls the type of data a field stores
c)
data type which is used when monetary values are entered
d)
None
e)
None
7.
Database
a)
collection of objects which work together to store, retrieve, display and summarize information and automate various tasks
b)
process of determining fields, tables and relationships needed to satisfy the data and processing requirements
c)
field property which controls the type of data a field stores
d)
data type which is used when monetary values are entered
e)
None
8.
Date and Time Data Type
a)
data type which is used when a date or time is entered into a field
b)
collection of objects which work together to store, retrieve, display and summarize information and automate various tasks
c)
process of determining fields, tables and relationships needed to satisfy the data and processing requirements
d)
field property which controls the type of data a field stores
e)
None
9.
Field Size
a)
property which determines the number of characters allowed in a field for the text, number and AutoNumber data types
b)
data type which is used when a date or time is entered into a field
c)
collection of objects which work together to store, retrieve, display and summarize information and automate various tasks
d)
None
e)
None
10.
Field
a)
single piece of information related to the person, place, object, event or idea it describes and are the columns of the table
b)
property which determines the number of characters allowed in a field for the text, number and AutoNumber data types
c)
data type which is used when a date or time is entered into a field
d)
collection of objects which work together to store, retrieve, display and summarize information and automate various tasks
e)
None
11.
Filter By Selection
a)
allows the user to select all or part of a field value and then display only those records which contain the selected value in the field
b)
single piece of information related to the person, place, object, event or idea it describes and are the columns of the table
c)
property which determines the number of characters allowed in a field for the text, number and AutoNumber data types
d)
data type which is used when a date or time is entered into a field
e)
None
12.
Filter
a)
set of restrictions placed on the records to temporarily isolate a subset of the records
b)
allows the user to select all or part of a field value and then display only those records which contain the selected value in the field
c)
single piece of information related to the person, place, object, event or idea it describes and are the columns of the table
d)
property which determines the number of characters allowed in a field for the text, number and AutoNumber data types
e)
None
13.
Foreign Key
a)
primary key from one table as a field in a second table to form a relationship between the two tables
b)
set of restrictions placed on the records to temporarily isolate a subset of the records
c)
allows the user to select all or part of a field value and then display only those records which contain the selected value in the field
d)
single piece of information related to the person, place, object, event or idea it describes and are the columns of the table
e)
None
14.
Form Tool
a)
tool which creates a form containing all the fields in the table or other database object on which the form is based
b)
primary key from one table as a field in a second table to form a relationship between the two tables
c)
set of restrictions placed on the records to temporarily isolate a subset of the records
d)
None
e)
None
15.
Form
a)
database object which allows the user to enter, edit or display data from a table or a query
b)
tool which creates a form containing all the fields in the table or other database object on which the form is based
c)
primary key from one table as a field in a second table to form a relationship between the two tables
d)
set of restrictions placed on the records to temporarily isolate a subset of the records
e)
None
16.
Hyperlinks Data Type
a)
data type used to hold hyperlinks to web pages or other Microsoft® Access® objects
b)
database object which allows the user to enter, edit or display data from a table or a query
c)
tool which creates a form containing all the fields in the table or other database object on which the form is based
d)
None
e)
None
17.
Join Line
a)
line connecting the common fields which join two tables
b)
data type used to hold hyperlinks to web pages or other Microsoft® Access® objects
c)
database object which allows the user to enter, edit or display data from a table or a query
d)
None
e)
None
18.
Lookup Wizard
a)
tool which creates a field which looks up a value in another table or in a predefined list of values
b)
line connecting the common fields which join two tables
c)
data type used to hold hyperlinks to web pages or other Microsoft® Access® objects
d)
None
e)
None
19.
Memo Data Type
a)
data type which is used for fields which will contain large amounts of text
b)
tool which creates a field which looks up a value in another table or in a predefined list of values
c)
line connecting the common fields which join two tables
d)
None
e)
None
20.
Microsoft® Access®
a)
program which allows for the creation and management of various types of databases
b)
data type which is used for fields which will contain large amounts of text
c)
tool which creates a field which looks up a value in another table or in a predefined list of values
d)
None
e)
None
21.
Multitable Query
a)
query based on more than one table
b)
program which allows for the creation and management of various types of databases
c)
data type which is used for fields which will contain large amounts of text
d)
None
e)
None
22.
Number Data Type
a)
data type which is used when numeric values are entered to be used in calculations, except not for monetary amounts
b)
query based on more than one table
c)
program which allows for the creation and management of various types of databases
d)
None
e)
None
23.
OLE Object Data Type
a)
data type which allows objects from other Microsoft® Office programs to be embedded in a table
b)
data type which is used when numeric values are entered to be used in calculations, except not for monetary amounts
c)
query based on more than one table
d)
program which allows for the creation and management of various types of databases
e)
None
24.
One-to-Many Relationship
a)
relationship which exists between two tables; one record in the fist table matches zero, one or many records in a second table, and one record in the second table matches at most one record in the first table
b)
data type which allows objects from other Microsoft® Office programs to be embedded in a table
c)
data type which is used when numeric values are entered to be used in calculations, except not for monetary amounts
d)
query based on more than one table
e)
None
25.
Primary Key
a)
field in which the value uniquely identifies each record in a table
b)
relationship which exists between two tables; one record in the fist table matches zero, one or many records in a second table, and one record in the second table matches at most one record in the first table
c)
data type which allows objects from other Microsoft® Office programs to be embedded in a table
d)
data type which is used when numeric values are entered to be used in calculations, except not for monetary amounts
e)
None
26.
Properties
a)
characteristics of each field so the database knows how to store, display and process field values
b)
field in which the value uniquely identifies each record in a table
c)
relationship which exists between two tables; one record in the fist table matches zero, one or many records in a second table, and one record in the second table matches at most one record in the first table
d)
data type which allows objects from other Microsoft® Office programs to be embedded in a table
e)
None
27.
Query Wizard
a)
tool which seeks information by asking a series of questions and then creates an appropriate query based on the answers
b)
characteristics of each field so the database knows how to store, display and process field values
c)
field in which the value uniquely identifies each record in a table
d)
relationship which exists between two tables; one record in the fist table matches zero, one or many records in a second table, and one record in the second table matches at most one record in the first table
e)
None
28.
Query
a)
question asked about the data stored in a database
b)
tool which seeks information by asking a series of questions and then creates an appropriate query based on the answers
c)
characteristics of each field so the database knows how to store, display and process field values
d)
field in which the value uniquely identifies each record in a table
e)
None
29.
Record Set
a)
result of a query
b)
question asked about the data stored in a database
c)
tool which seeks information by asking a series of questions and then creates an appropriate query based on the answers
d)
characteristics of each field so the database knows how to store, display and process field values
e)
None
30.
Record
a)
complete set of data the fields make up; rows of the table
b)
result of a query
c)
question asked about the data stored in a database
d)
None
e)
None
31.
Referential Integrity
a)
set of rules which Microsoft® Access® enforces between related tables when updating data in a database
b)
complete set of data the fields make up; rows of the table
c)
result of a query
d)
None
e)
None
32.
Report Tool
a)
tool which places all the fields from a selected table or query on a report
b)
set of rules which Microsoft® Access® enforces between related tables when updating data in a database
c)
complete set of data the fields make up; rows of the table
d)
None
e)
None
33.
Report Wizard
a)
tool which asks a series of questions and creates a report based on the answers
b)
tool which places all the fields from a selected table or query on a report
c)
set of rules which Microsoft® Access® enforces between related tables when updating data in a database
d)
None
e)
None
34.
Report
a)
formatted printout or screen display of the contents of one or more tables in a database
b)
tool which asks a series of questions and creates a report based on the answers
c)
tool which places all the fields from a selected table or query on a report
d)
None
e)
None
35.
Sort Field
a)
field used to determine the order of records in the datasheet
b)
formatted printout or screen display of the contents of one or more tables in a database
c)
tool which asks a series of questions and creates a report based on the answers
d)
tool which places all the fields from a selected table or query on a report
e)
None
36.
Sorting
a)
process of rearranging records in a specified order or sequence
b)
field used to determine the order of records in the datasheet
c)
formatted printout or screen display of the contents of one or more tables in a database
d)
tool which asks a series of questions and creates a report based on the answers
e)
None
37.
Table
a)
collection of fields which store data
b)
process of rearranging records in a specified order or sequence
c)
field used to determine the order of records in the datasheet
d)
formatted printout or screen display of the contents of one or more tables in a database
e)
None
38.
Template
a)
pattern used to create a specific type of database
b)
collection of fields which store data
c)
process of rearranging records in a specified order or sequence
d)
field used to determine the order of records in the datasheet
e)
None
39.
Text Data Type
a)
data type which accepts only letters, numbers and a few types of punctuation
b)
pattern used to create a specific type of database
c)
collection of fields which store data
d)
process of rearranging records in a specified order or sequence
e)
None
40.
Yes/No Data Type
a)
data type which includes the Yes/No format as well as True/False and On/Off in a field; data type is used when the value can only be one of two possible answers
b)
data type which accepts only letters, numbers and a few types of punctuation
c)
pattern used to create a specific type of database
d)
collection of fields which store data
e)
None
41.
data type which stores pictures, images and other Microsoft® Office files in a field
a)
Attachment Data Type
b)
Yes/No Data Type
c)
Text Data Type
d)
Template
e)
None
42.
data type which inserts a unique value to each record in a table
a)
AutoNumber Data Type
b)
Attachment Data Type
c)
Yes/No Data Type
d)
Text Data Type
e)
None
43.
process of making a copy of the database file to protect the database against loss or damage
a)
Backing Up a Database
b)
AutoNumber Data Type
c)
Attachment Data Type
d)
None
e)
None
44.
data type which is used when monetary values are entered
a)
Currency Data Type
b)
Backing Up a Database
c)
AutoNumber Data Type
d)
None
e)
None
45.
field property which controls the type of data a field stores
a)
Data Type
b)
Currency Data Type
c)
Backing Up a Database
d)
None
e)
None
46.
process of determining fields, tables and relationships needed to satisfy the data and processing requirements
a)
Database Design
b)
Data Type
c)
Currency Data Type
d)
Backing Up a Database
e)
None
47.
collection of objects which work together to store, retrieve, display and summarize information and automate various tasks
a)
Database
b)
Database Design
c)
Data Type
d)
Currency Data Type
e)
None
48.
data type which is used when a date or time is entered into a field
a)
Date and Time Data Type
b)
Database
c)
Database Design
d)
Data Type
e)
None
49.
property which determines the number of characters allowed in a field for the text, number and AutoNumber data types
a)
Field Size
b)
Date and Time Data Type
c)
Database
d)
Database Design
e)
None
50.
single piece of information related to the person, place, object, event or idea it describes and are the columns of the table
a)
Field
b)
Field Size
c)
Date and Time Data Type
d)
Database
e)
None
51.
allows the user to select all or part of a field value and then display only those records which contain the selected value in the field
a)
Filter By Selection
b)
Field
c)
Field Size
d)
Date and Time Data Type
e)
None
52.
set of restrictions placed on the records to temporarily isolate a subset of the records
a)
Filter
b)
Filter By Selection
c)
Field
d)
Field Size
e)
None
53.
primary key from one table as a field in a second table to form a relationship between the two tables
a)
Foreign Key
b)
Filter
c)
Filter By Selection
d)
None
e)
None
54.
tool which creates a form containing all the fields in the table or other database object on which the form is based
a)
Form Tool
b)
Foreign Key
c)
Filter
d)
None
e)
None
55.
database object which allows the user to enter, edit or display data from a table or a query
a)
Form
b)
Form Tool
c)
Foreign Key
d)
None
e)
None
56.
data type used to hold hyperlinks to web pages or other Microsoft® Access® objects
a)
Hyperlinks Data Type
b)
Form
c)
Form Tool
d)
None
e)
None
57.
line connecting the common fields which join two tables
a)
Join Line
b)
Hyperlinks Data Type
c)
Form
d)
None
e)
None
58.
tool which creates a field which looks up a value in another table or in a predefined list of values
a)
Lookup Wizard
b)
Join Line
c)
Hyperlinks Data Type
d)
None
e)
None
59.
data type which is used for fields which will contain large amounts of text
a)
Memo Data Type
b)
Lookup Wizard
c)
Join Line
d)
Hyperlinks Data Type
e)
None
60.
program which allows for the creation and management of various types of databases
a)
Microsoft® Access®
b)
Memo Data Type
c)
Lookup Wizard
d)
Join Line
e)
None
61.
query based on more than one table
a)
Multitable Query
b)
Microsoft® Access®
c)
Memo Data Type
d)
Lookup Wizard
e)
None
62.
data type which is used when numeric values are entered to be used in calculations, except not for monetary amounts
a)
Number Data Type
b)
Multitable Query
c)
Microsoft® Access®
d)
Memo Data Type
e)
None
63.
data type which allows objects from other Microsoft® Office programs to be embedded in a table
a)
OLE Object Data Type
b)
Number Data Type
c)
Multitable Query
d)
Microsoft® Access®
e)
None
64.
relationship which exists between two tables; one record in the fist table matches zero, one or many records in a second table, and one record in the second table matches at most one record in the first table
a)
One-to-Many Relationship
b)
OLE Object Data Type
c)
Number Data Type
d)
Multitable Query
e)
None
65.
field in which the value uniquely identifies each record in a table
a)
Primary Key
b)
One-to-Many Relationship
c)
OLE Object Data Type
d)
Number Data Type
e)
None
66.
characteristics of each field so the database knows how to store, display and process field values
a)
Properties
b)
Primary Key
c)
One-to-Many Relationship
d)
OLE Object Data Type
e)
None
67.
tool which seeks information by asking a series of questions and then creates an appropriate query based on the answers
a)
Query Wizard
b)
Properties
c)
Primary Key
d)
One-to-Many Relationship
e)
None
68.
question asked about the data stored in a database
a)
Query
b)
Query Wizard
c)
Properties
d)
Primary Key
e)
None
69.
result of a query
a)
Record Set
b)
Query
c)
Query Wizard
d)
Properties
e)
None
70.
complete set of data the fields make up; rows of the table
a)
Record
b)
Record Set
c)
Query
d)
Query Wizard
e)
None
71.
set of rules which Microsoft® Access® enforces between related tables when updating data in a database
a)
Referential Integrity
b)
Record
c)
Record Set
d)
None
e)
None
72.
tool which places all the fields from a selected table or query on a report
a)
Report Tool
b)
Referential Integrity
c)
Record
d)
None
e)
None
73.
tool which asks a series of questions and creates a report based on the answers
a)
Report Wizard
b)
Report Tool
c)
Referential Integrity
d)
None
e)
None
74.
formatted printout or screen display of the contents of one or more tables in a database
a)
Report
b)
Report Wizard
c)
Report Tool
d)
None
e)
None
75.
field used to determine the order of records in the datasheet
a)
Sort Field
b)
Report
c)
Report Wizard
d)
None
e)
None
76.
process of rearranging records in a specified order or sequence
a)
Sorting
b)
Sort Field
c)
Report
d)
None
e)
None
77.
collection of fields which store data
a)
Table
b)
Sorting
c)
Sort Field
d)
None
e)
None
78.
pattern used to create a specific type of database
a)
Template
b)
Table
c)
Sorting
d)
Sort Field
e)
None
79.
data type which accepts only letters, numbers and a few types of punctuation
a)
Text Data Type
b)
Template
c)
Table
d)
Sorting
e)
None
80.
data type which includes the Yes/No format as well as True/False and On/Off in a field; data type is used when the value can only be one of two possible answers
a)
Yes/No Data Type
b)
Text Data Type
c)
Template
d)
Table
e)
None
100 %
