MIS access Exam3 UNH |Questions Solved 100% Correct| Verified Solutions

MIS access Exam3 UNH |Questions
Solved 100% Correct| Verified Solutions
WHERE keyword - ANSWER Specifies the criteria the data must match to be shown
in the results



SELECT keyword - ANSWER Instructs Access to return the specific fields from one
or more tables/queries



Structured Query Language (SQL) - ANSWER The industry-standard language for
accessing and manipulating data in a database. Lets you get information from data in
a relational database - very useful skill from employer's perspective



Record Source - ANSWER A table, query, or SQL statement that contains the actual data
that is shown on a form or report


Forms - ANSWER Allow you to easily enter or view data in a database



Reports - ANSWER Used when you want a formatted, electronic, or printed document.
Something you can present. Reports are created from data in tables or queries



Wildcard Character - ANSWER Used to search for a word, part of a word, or pattern


Input Mask - ANSWER Access will insert special characters in the appropriate positions


Parameter Query - ANSWER Prompts the used for input every time the query is run