WorksheetsBIM I Unit 3 Vocab
Total questions: 80
Worksheet time: 2hrs 0mins
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
d)
pattern used to create a specific type of database
e)
collection of fields which store data
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)
pattern used to create a specific type of database
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)
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
e)
data type which accepts only letters, numbers and a few types of punctuation
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)
data type which stores pictures, images and other Microsoft® Office files in a field
e)
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
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)
data type which stores pictures, images and other Microsoft® Office files in a field
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)
process of making a copy of the database file to protect the database against loss or damage
e)
data type which inserts a unique value to each record in a table
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)
process of making a copy of the database file to protect the database against loss or damage
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)
data type which is used when monetary values are entered
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)
process of determining fields, tables and relationships needed to satisfy the data and processing requirements
e)
field property which controls the type of data a field stores
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)
process of determining fields, tables and relationships needed to satisfy the data and processing requirements
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)
collection of objects which work together to store, retrieve, display and summarize information and automate various tasks
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)
data type which is used when a date or time is entered into a field
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)
property which determines the number of characters allowed in a field for the text, number and AutoNumber data types
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)
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
e)
single piece of information related to the person, place, object, event or idea it describes and are the columns of the table
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)
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
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)
primary key from one table as a field in a second table to form a relationship between the two tables
e)
set of restrictions placed on the records to temporarily isolate a subset of the records
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)
tool which creates a form containing all the fields in the table or other database object on which the form is based
e)
primary key from one table as a field in a second table to form a relationship between the two tables
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)
database object which allows the user to enter, edit or display data from a table or a query
e)
tool which creates a form containing all the fields in the table or other database object on which the form is based
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)
data type used to hold hyperlinks to web pages or other Microsoft® Access® objects
e)
database object which allows the user to enter, edit or display data from a table or a query
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)
line connecting the common fields which join two tables
e)
data type used to hold hyperlinks to web pages or other Microsoft® Access® objects
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)
tool which creates a field which looks up a value in another table or in a predefined list of values
e)
line connecting the common fields which join two tables
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)
data type which is used for fields which will contain large amounts of text
e)
tool which creates a field which looks up a value in another table or in a predefined list of values
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)
data type which is used for fields which will contain large amounts of text
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)
program which allows for the creation and management of various types of databases
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)
query based on more than one table
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)
data type which is used when numeric values are entered to be used in calculations, except not for monetary amounts
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)
data type which allows objects from other Microsoft® Office programs to be embedded in a table
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)
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
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)
field in which the value uniquely identifies each record in a table
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)
tool which seeks information by asking a series of questions and then creates an appropriate query based on the answers
e)
characteristics of each field so the database knows how to store, display and process field values
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)
question asked about the data stored in a database
e)
tool which seeks information by asking a series of questions and then creates an appropriate query based on the answers
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)
result of a query
e)
question asked about the data stored in a database
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)
complete set of data the fields make up; rows of the table
e)
result of a query
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)
set of rules which Microsoft® Access® enforces between related tables when updating data in a database
e)
complete set of data the fields make up; rows of the table
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)
set of rules which Microsoft® Access® enforces between related tables when updating data in a database
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)
tool which places all the fields from a selected table or query on a report
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)
tool which asks a series of questions and creates a report based on the answers
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)
formatted printout or screen display of the contents of one or more tables in a database
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)
field used to determine the order of records in the datasheet
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)
process of rearranging records in a specified order or sequence
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)
Table
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)
Template
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)
Yes/No Data Type
e)
Text Data Type
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)
Attachment Data Type
e)
Yes/No Data Type
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)
AutoNumber Data Type
e)
Attachment Data Type
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)
AutoNumber Data Type
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)
Backing Up a Database
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)
Currency Data Type
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)
Data Type
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)
Database Design
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)
Database
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)
Date and Time Data Type
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)
Field
e)
Field Size
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)
Filter By Selection
e)
Field
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)
Filter
e)
Filter By Selection
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)
Foreign Key
e)
Filter
57.
line connecting the common fields which join two tables
a)
Join Line
b)
Hyperlinks Data Type
c)
Form
d)
Form Tool
e)
Foreign Key
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)
Form
e)
Form Tool
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)
Form
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)
Hyperlinks Data Type
61.
query based on more than one table
a)
Multitable Query
b)
Microsoft® Access®
c)
Memo Data Type
d)
Lookup Wizard
e)
Join Line
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)
Lookup Wizard
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)
Memo Data Type
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)
Microsoft® Access®
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)
Multitable Query
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)
Number Data Type
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)
OLE Object Data Type
68.
question asked about the data stored in a database
a)
Query
b)
Query Wizard
c)
Properties
d)
Primary Key
e)
One-to-Many Relationship
69.
result of a query
a)
Record Set
b)
Query
c)
Query Wizard
d)
Properties
e)
Primary Key
70.
complete set of data the fields make up; rows of the table
a)
Record
b)
Record Set
c)
Query
d)
Query Wizard
e)
Properties
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)
Query
e)
Query Wizard
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)
Record Set
e)
Query
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)
Record
e)
Record Set
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)
Referential Integrity
e)
Record
75.
field used to determine the order of records in the datasheet
a)
Sort Field
b)
Report
c)
Report Wizard
d)
Report Tool
e)
Referential Integrity
76.
process of rearranging records in a specified order or sequence
a)
Sorting
b)
Sort Field
c)
Report
d)
Report Wizard
e)
Report Tool
77.
collection of fields which store data
a)
Table
b)
Sorting
c)
Sort Field
d)
Report
e)
Report Wizard
78.
pattern used to create a specific type of database
a)
Template
b)
Table
c)
Sorting
d)
Sort Field
e)
Report
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)
Sort Field
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)
Sorting
100 %
