MIS Access Exam2 UNH |Questions
Solved 100% Correct| Verified Solutions
Quick Access Toolbar - ANSWER A toolbar that provides one click access to commonly
What is a query? - ANSWER A question you ask about the data in the database
Query results are stored in the database (true or false) - ANSWER false
Why would you use a form? - ANSWER to enter, edit, and view records in a database
what are the layout options for a form? - ANSWER columnar, tabular,
datasheet, justified
What is a report? - ANSWER is a formatted printout of the contents of one or more
tables or queries
Should you view a table in print preview? - ANSWER No, a report instead
What does it mean to compact a database? - ANSWER rearranges the data and
objects in a database to decrease file size and make more storage available
What does it mean to backup a database? - ANSWER The process of making a copy of a
database file to protect your database against loss or damage
, What is the top portion of the window in design view? - ANSWER table design grid
The general tab of the field properties pane displays additional field properties for
that data type (true or false) - ANSWER true
What is a composite key - ANSWER multiple primary keys
Should you change the caption in design view or datasheet view? - ANSWER design view
What is entity integrity? - ANSWER Access forces you to add a value, if no value
is entered it is a null value
Do you save in design view or datasheet view? - ANSWER design view
A field must be moved in design view for it to be permanent (true or false) - ANSWER
true
Changing the format in datasheet view changes the actual values (true or false) -
ANSWER false
What is the relationships window? - ANSWER it is a window that illustrates the
relationships in a database
What is a one-to-many relationship? - ANSWER A relationship that exists when
one record in a table matches zero, one, or many records in the second table and
when records in the second table matches at most one record in the first
When you add a table it appears as a field list (true or false) - ANSWER true
Solved 100% Correct| Verified Solutions
Quick Access Toolbar - ANSWER A toolbar that provides one click access to commonly
What is a query? - ANSWER A question you ask about the data in the database
Query results are stored in the database (true or false) - ANSWER false
Why would you use a form? - ANSWER to enter, edit, and view records in a database
what are the layout options for a form? - ANSWER columnar, tabular,
datasheet, justified
What is a report? - ANSWER is a formatted printout of the contents of one or more
tables or queries
Should you view a table in print preview? - ANSWER No, a report instead
What does it mean to compact a database? - ANSWER rearranges the data and
objects in a database to decrease file size and make more storage available
What does it mean to backup a database? - ANSWER The process of making a copy of a
database file to protect your database against loss or damage
, What is the top portion of the window in design view? - ANSWER table design grid
The general tab of the field properties pane displays additional field properties for
that data type (true or false) - ANSWER true
What is a composite key - ANSWER multiple primary keys
Should you change the caption in design view or datasheet view? - ANSWER design view
What is entity integrity? - ANSWER Access forces you to add a value, if no value
is entered it is a null value
Do you save in design view or datasheet view? - ANSWER design view
A field must be moved in design view for it to be permanent (true or false) - ANSWER
true
Changing the format in datasheet view changes the actual values (true or false) -
ANSWER false
What is the relationships window? - ANSWER it is a window that illustrates the
relationships in a database
What is a one-to-many relationship? - ANSWER A relationship that exists when
one record in a table matches zero, one, or many records in the second table and
when records in the second table matches at most one record in the first
When you add a table it appears as a field list (true or false) - ANSWER true
