MIS Access Exam2 UNH |Questions
Solved 100% Correct| Verified Solutions
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
, When importing data, the names of fields must match (true or false) - ANSWER true
When would you use the Quick Start Selections? - ANSWER If you wanted to add
a group of related fields at the same time (found in Data Type Gallery)
What is the Default Value Property? - ANSWER It is a field property that specifies what
value will appear
What is the acronym GUI? - ANSWER Graphical User Interface
What does *ing do ? - ANSWER Sets a criteria (wildcard) to find all records ending in ing
What are the two ways you can see the results of a query made in design view?
- ANSWER Click run or view in the top left corner
Where is the status bar located in query design view, also what is it? - ANSWER The
buttons in the lower right corner that allows you to change views (design --> datasheet)
What key would you click to finalize a record and save it? - ANSWER enter
What do you select to select a whole row? - ANSWER the row selector
What is the result of a query called? - ANSWER a record set
If you want to make specialized, technical queries, which one should you use, a
query design or query wizard? - ANSWER query wizard
Solved 100% Correct| Verified Solutions
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
, When importing data, the names of fields must match (true or false) - ANSWER true
When would you use the Quick Start Selections? - ANSWER If you wanted to add
a group of related fields at the same time (found in Data Type Gallery)
What is the Default Value Property? - ANSWER It is a field property that specifies what
value will appear
What is the acronym GUI? - ANSWER Graphical User Interface
What does *ing do ? - ANSWER Sets a criteria (wildcard) to find all records ending in ing
What are the two ways you can see the results of a query made in design view?
- ANSWER Click run or view in the top left corner
Where is the status bar located in query design view, also what is it? - ANSWER The
buttons in the lower right corner that allows you to change views (design --> datasheet)
What key would you click to finalize a record and save it? - ANSWER enter
What do you select to select a whole row? - ANSWER the row selector
What is the result of a query called? - ANSWER a record set
If you want to make specialized, technical queries, which one should you use, a
query design or query wizard? - ANSWER query wizard
