MIS Access Exam UNH |Questions
Solved 100% Correct| Verified Solutions
To filter exact text values except New York - ANSWER Criteria: <>"New York"
To filter text that begins with a certain criteria - ANSWER Like "Joh*"
To filter dates - ANSWER #1/31/2017#
Filter between dates - ANSWER Between #x# And #x#
Form - ANSWER database used to add data or edit data in a table
Why do we use forms? - ANSWER -Less likely to edit the wrong
record -Show data from more than one table simultaneously -
Resemble paper forms
Bound controls - ANSWER source of data is a field in a table or query; field values
Unbound controls - ANSWER no data source; title, pictures
Solved 100% Correct| Verified Solutions
To filter exact text values except New York - ANSWER Criteria: <>"New York"
To filter text that begins with a certain criteria - ANSWER Like "Joh*"
To filter dates - ANSWER #1/31/2017#
Filter between dates - ANSWER Between #x# And #x#
Form - ANSWER database used to add data or edit data in a table
Why do we use forms? - ANSWER -Less likely to edit the wrong
record -Show data from more than one table simultaneously -
Resemble paper forms
Bound controls - ANSWER source of data is a field in a table or query; field values
Unbound controls - ANSWER no data source; title, pictures