MISY 5325 ACTUAL FINALS QUESTIONS AND
ANSWERS SET A+
✔✔Can the query name contain a period? - ✔✔No
✔✔True or False
Cross-tab query allows you to create three dimensional grouping - ✔✔False
two dimensional grouping
✔✔True or False
When adding a new row in Design View, you can right click or press the INSERT key on
the keyboard to add a new row - ✔✔True
✔✔When a field is set up with choices to select from a drop down arrow - ✔✔Lookup
field
✔✔The Lookup wizard can allow for - ✔✔choices from a drop down arrow and
multivalued choices
✔✔True or False
The Validation rule allow you to have the field pre-filled with a certain text - ✔✔False
the Default Value allows you to pre-fill fields
✔✔What is the Validation rule - ✔✔An expression that limits the values that can be
entered in the field.
✔✔What is the Validation rule syntax? Use HS for example - ✔✔="HS"
✔✔True or False
, The Validation text is use to allow user to see that the correct information was entered -
✔✔False
allows the user to see that the wrong information was entered
✔✔True or False
There is nothing to be retrieved from the Update Query - ✔✔True
✔✔Ture or False
You can recover data once it has been deleted using the Delete Query - ✔✔False
you can not retrieve the data once it has been deleted
✔✔True or False
New records added to the data sheet view will not be automatically sorted by the
primary key - ✔✔False
They will be automatically sorted by primary key
✔✔What is the syntax for someone who started work before 1/1/2013 - ✔✔In criteria
enter
<#1/1/2013#
✔✔What is the syntax for someone who started work after 2013 - ✔✔In criteria enter
<#12/31/2013#
✔✔What is the syntax for someone who started work between the dates Jan 2013 and
Dec 2013 - ✔✔In criteria enter
between #1/1/2013# and #12/31/2013#
✔✔True or False
In Report wizard if your data is not separated in how you want to view your data, this
means you did not set up the relationship between the tables - ✔✔True
✔✔In Report wizard, when asked asked about grouping, the grouping should
automatically be in place if you set up your relationship between the two tables -
✔✔True
✔✔How do you open the Input Mask Wizard - ✔✔the three dots at the end of the row
✔✔True or False
The Input Mask can be used to preset characters like hyphens, dashes, and slashes. for
example ( ) in a phone number, - ✔✔True
ANSWERS SET A+
✔✔Can the query name contain a period? - ✔✔No
✔✔True or False
Cross-tab query allows you to create three dimensional grouping - ✔✔False
two dimensional grouping
✔✔True or False
When adding a new row in Design View, you can right click or press the INSERT key on
the keyboard to add a new row - ✔✔True
✔✔When a field is set up with choices to select from a drop down arrow - ✔✔Lookup
field
✔✔The Lookup wizard can allow for - ✔✔choices from a drop down arrow and
multivalued choices
✔✔True or False
The Validation rule allow you to have the field pre-filled with a certain text - ✔✔False
the Default Value allows you to pre-fill fields
✔✔What is the Validation rule - ✔✔An expression that limits the values that can be
entered in the field.
✔✔What is the Validation rule syntax? Use HS for example - ✔✔="HS"
✔✔True or False
, The Validation text is use to allow user to see that the correct information was entered -
✔✔False
allows the user to see that the wrong information was entered
✔✔True or False
There is nothing to be retrieved from the Update Query - ✔✔True
✔✔Ture or False
You can recover data once it has been deleted using the Delete Query - ✔✔False
you can not retrieve the data once it has been deleted
✔✔True or False
New records added to the data sheet view will not be automatically sorted by the
primary key - ✔✔False
They will be automatically sorted by primary key
✔✔What is the syntax for someone who started work before 1/1/2013 - ✔✔In criteria
enter
<#1/1/2013#
✔✔What is the syntax for someone who started work after 2013 - ✔✔In criteria enter
<#12/31/2013#
✔✔What is the syntax for someone who started work between the dates Jan 2013 and
Dec 2013 - ✔✔In criteria enter
between #1/1/2013# and #12/31/2013#
✔✔True or False
In Report wizard if your data is not separated in how you want to view your data, this
means you did not set up the relationship between the tables - ✔✔True
✔✔In Report wizard, when asked asked about grouping, the grouping should
automatically be in place if you set up your relationship between the two tables -
✔✔True
✔✔How do you open the Input Mask Wizard - ✔✔the three dots at the end of the row
✔✔True or False
The Input Mask can be used to preset characters like hyphens, dashes, and slashes. for
example ( ) in a phone number, - ✔✔True
