MIS UNH Questions Solved 100% Correct
Connor wants to display records for orders placed before January 1, 2020. Which
of the following criteria should he use in the OrderDate field in Query Design view?
<#1/1/2020#
Which of the following tools can you use to create a query?
Simple Query Wizard
Of all the database objects, a table provides the most formatting, layout,
and summary options
False
The Import Spreadsheet feature helps you import Excel data into Access.
True
To select fields and records to answer a question, you most likely create a form object.
False
Which Access object contains all of the data in the database?
Table
What Field Size should you set for a State field that stores two-character
state abbreviations? (Don't overthink this one!)
2
, A _____ typically shows all the fields for one record on a single screen for data entry
and editing.
Form
Microsoft Access Objects include ( select all that apply):
Reports and Table
Data
Streams of raw facts representing events such as business transactions
Information
facts provided or learned about something or someone
Knowledge
the ability to use information and comes from experience and learning new skills
What is an information system?
A set of interrelated components that collect (or retrieve), process, store, and
distribute information to support decision making and control in an organization
What is the 5 component model?
LOOK AT PIECE OF PAPER
what are the broad classifications of information system?
examples of information systems
Individual: target one person in an organization; highly specialized
Functional: address needs of one department, i.e. accounting module
Connor wants to display records for orders placed before January 1, 2020. Which
of the following criteria should he use in the OrderDate field in Query Design view?
<#1/1/2020#
Which of the following tools can you use to create a query?
Simple Query Wizard
Of all the database objects, a table provides the most formatting, layout,
and summary options
False
The Import Spreadsheet feature helps you import Excel data into Access.
True
To select fields and records to answer a question, you most likely create a form object.
False
Which Access object contains all of the data in the database?
Table
What Field Size should you set for a State field that stores two-character
state abbreviations? (Don't overthink this one!)
2
, A _____ typically shows all the fields for one record on a single screen for data entry
and editing.
Form
Microsoft Access Objects include ( select all that apply):
Reports and Table
Data
Streams of raw facts representing events such as business transactions
Information
facts provided or learned about something or someone
Knowledge
the ability to use information and comes from experience and learning new skills
What is an information system?
A set of interrelated components that collect (or retrieve), process, store, and
distribute information to support decision making and control in an organization
What is the 5 component model?
LOOK AT PIECE OF PAPER
what are the broad classifications of information system?
examples of information systems
Individual: target one person in an organization; highly specialized
Functional: address needs of one department, i.e. accounting module
