MIS Access Exam UNH Questions
Solved 100% Correct
What field property helps to make sure that correct data is entered?
Validation rule
Enforcing referential integrity assures that ________.
you cannot enter a value in the foreign key if there is no corresponding value in
the primary key
What is the most common relationship type?
One to many
Checking the Cascade Delete Related Records checkbox assures that ________.
all records will be deleted in related tables if you delete the primary key in the primary
table
When you run a query, it displays in what view?
Datasheet
Which of the following comparison operators is not valid?
=>
Which option would this wildcard, "H[!oe]" not display?
House
If you add a table with 10 records to a query and add an unrelated table with 4 records
to the same query, how many records will display when you run the query?
40
, What button do you click to see the results of a query?
Run
In the formula, =1+(2-3)+5/6-6^2, what will Access evaluate first?
(2-3)
The correct answer is:
[]
Which of the following is not a common mistake when creating calculated fields?
Forgetting the colon
When you are prompted to enter a value when you run a query which includes
a calculated field, you probably ________.
typed a field name incorrectly
What are predefined computations that perform complex calculations?
Functions
What is not an example of a function?
=15*21
What does Access refer to aggregate functions as?
Totals
Which of the following is not a common aggregate function?
Lowest
What allows you to summarize data by the values of a field?
Adding grouping to a query
Solved 100% Correct
What field property helps to make sure that correct data is entered?
Validation rule
Enforcing referential integrity assures that ________.
you cannot enter a value in the foreign key if there is no corresponding value in
the primary key
What is the most common relationship type?
One to many
Checking the Cascade Delete Related Records checkbox assures that ________.
all records will be deleted in related tables if you delete the primary key in the primary
table
When you run a query, it displays in what view?
Datasheet
Which of the following comparison operators is not valid?
=>
Which option would this wildcard, "H[!oe]" not display?
House
If you add a table with 10 records to a query and add an unrelated table with 4 records
to the same query, how many records will display when you run the query?
40
, What button do you click to see the results of a query?
Run
In the formula, =1+(2-3)+5/6-6^2, what will Access evaluate first?
(2-3)
The correct answer is:
[]
Which of the following is not a common mistake when creating calculated fields?
Forgetting the colon
When you are prompted to enter a value when you run a query which includes
a calculated field, you probably ________.
typed a field name incorrectly
What are predefined computations that perform complex calculations?
Functions
What is not an example of a function?
=15*21
What does Access refer to aggregate functions as?
Totals
Which of the following is not a common aggregate function?
Lowest
What allows you to summarize data by the values of a field?
Adding grouping to a query
