MIS access Exam UNH |Questions
Solved 100% Correct| Verified Solutions
Why use Access over Excel? - ANSWER 1. Do you need to store data in separate
tables that are related?
2. Do you have a very large amount of data to store?
3. Will more than one person need to access the data?
What is the default name for a table created in design view? - ANSWER Table1
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
How do you toggle between table design grid and field properties - ANSWER F6
What do you click to display help information - ANSWER F1
What is a composite key - ANSWER multiple primary keys
Why would you change the field size property? - ANSWER to decrease the amount
of storage used for a particular field
, What datatypes can you use the field size property for? - ANSWER ONLY short
text, number, and autonumber
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
In Access, short text is right aligned while numbers, date, and currency are left
aligned (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
The join line connects the form header to the rest of the form (true or false) - ANSWER
false; it is the line that connects a common field between two tables in the
relationship window
Solved 100% Correct| Verified Solutions
Why use Access over Excel? - ANSWER 1. Do you need to store data in separate
tables that are related?
2. Do you have a very large amount of data to store?
3. Will more than one person need to access the data?
What is the default name for a table created in design view? - ANSWER Table1
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
How do you toggle between table design grid and field properties - ANSWER F6
What do you click to display help information - ANSWER F1
What is a composite key - ANSWER multiple primary keys
Why would you change the field size property? - ANSWER to decrease the amount
of storage used for a particular field
, What datatypes can you use the field size property for? - ANSWER ONLY short
text, number, and autonumber
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
In Access, short text is right aligned while numbers, date, and currency are left
aligned (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
The join line connects the form header to the rest of the form (true or false) - ANSWER
false; it is the line that connects a common field between two tables in the
relationship window
