Download - Chapter 1-6 Using MIS-Gary
-
Chapter 1 Using MIS
Question 1
The process of automation is a process of moving work from ________.
Selected Answer: human side to computer side
Answers: procedures to people
processes to procedures
human side to computer side
instructions to actors
Question 2 1 out of 1 points
Which of the following statements is true of business users who administer the
development of information systems?
Selected
Answer:
They should take an active role in the system's development.
Answers: They should take an active role in the system's development.
It is mandatory that they hold a degree in database management.
They should refrain from specifying the system's requirements.
When the system fails, they must refrain from performing tasks
related to system recovery.
Question 3 0 out of 1 points
The CEO of a large company asks the sales manager to report the sales figures of
the previous quarter. The manager immediately sends her the list of products
sold in the previous quarter. These details do not qualify as good information
because they are ________.
Selected Answer: not timely
Answers: not relevant
not timely
too narrow in scope
-
too expensive
Question 4 1 out of 1 points
You are looking to buy a home that costs less than $700,000, but your real estate
agent keeps sending you fliers for homes that cost $1,000,000 or more. This
information is likely to be useless because it is ________.
Selected Answer: irrelevant
Answers: inaccurate
not reliable
late
irrelevant
Question 5 1 out of 1 points
Caroline asks her secretary to send information on the meetings that she needs to
attend next month. Her secretary, Joanne, provides her with the details
immediately, but leaves out certain additional details that are irrelevant to
Caroline's requirements. Which of the following statements is true about this
scenario?
Selected
Answer:
The information that Joanne gave was accurate and sufficient for
Caroline's purpose.
Answers: Joanne provided adequate and timely information, but the
information was of no value to Caroline.
The information that Joanne gave was accurate and sufficient for
Caroline's purpose.
The information that Joanne provided was partly good as it was
timely but insufficient.
The information that Caroline obtained through Joanne was not
timely or worth its cost.
Question 6 1 out of 1 points
The most important skill for effective collaboration is to be able to give and
receive critical feedback.
Selected Answer: True
-
Answers: True
False
Question 7 0 out of 1 points
Which of the following is categorized as a nonroutine cognitive skill?
Selected Answer: computer programming
Answers: computer programming
systems thinking
tax accounting
marketing knowledge
Question 8 0 out of 1 points
Which of the following is the least critical aspect of good information?
Selected Answer: data accuracy
Answers: timeliness of data
data accuracy
relevance of data
additional data
Question 9 1 out of 1 points
________ states that the number of transistors per square inch on an integrated
chip doubles every 18 months.
Selected Answer: Moore's Law
Answers: Newton's Law
Faraday's Law
Moore's Law
Nielsen's Law
Question 10 1 out of 1 points
-
The CEO of an organization asks the human resources manager to send
information about the rate of employee turnover in the organization for the last
quarter. The manager sends the salary details of new hires during this period.
This information is likely to be of little use to the CEO because it is ________.
Selected Answer: irrelevant
Answers: too expensive
not timely
inaccurate
irrelevant
Which of the following best describes data?
Selected Answer:
recorded facts or figures
Answers: processed information
information presented in a meaningful context
recorded facts or figures
knowledge derived from facts or figures
Question 2 1 out of 1 points
Moore's Law predicts that the price to performance ratio of computers will double once
in eighteen months.
Selected Answer: False
Answers: True
False
Question 3 1 out of 1 points
-
Which of the following is a low-tech information system?
Selected Answer:
a file of email addresses stored in an email program
Answers:
a file of email addresses stored in an email program
a decision support system that analyzes multiple variables
an inventory tracking system that produces reports every 24 hours
a customer support system that keeps track of product issues
Question 4 1 out of 1 points
Which of the following is considered information rather than mere data?
Selected Answer:
the return on investment of an advertising campaign
Answers:
the return on investment of an advertising campaign
a list of property prices in a neighborhood
the price of a company's shares on a given day
the total number of students in a school
Question 5 1 out of 1 points
Information systems become a waste of time and money when users work with
inaccurate data.
Selected Answer: True
Answers: True
False
-
Question 6 1 out of 1 points
Obtaining or developing new programs is more difficult than ordering additional
hardware.
Selected Answer: True
Answers: True
False
Question 7 1 out of 1 points
A good password is one that contains the user's name or company name.
Selected Answer: False
Answers: True
False
Question 8 1 out of 1 points
Identify how information technology differs from information systems.
Selected
Answer:
One can buy information technology, but not information systems.
Answers: Information systems are a subset of information technology.
Unlike information systems, information technology is used for
producing information.
People are an important component of information technology, but not
of information systems.
One can buy information technology, but not information systems.
Question 9 1 out of 1 points
-
Information technology is an assembly of hardware, software, data, procedures, and
people that produces information.
Selected Answer: False
Answers: True
False
Question 10 1 out of 1 points
Caroline asks her secretary to send information on the meetings that she needs to attend
next month. Her secretary, Joanne, provides her with the details immediately, but leaves
out certain additional details that are irrelevant to Caroline's requirements. Which of the
following statements is true about this scenario?
Selected
Answer:
The information that Joanne gave was accurate and sufficient for
Caroline's purpose.
Answers:
The information that Joanne gave was accurate and sufficient for
Caroline's purpose.
The information that Caroline obtained through Joanne was not timely
or worth its cost.
The information that Joanne provided was partly good as it was timely
but insufficient.
Joanne provided adequate and timely information, but the information
was of no value to Caroline.
Chapter 2 - Using MIS Question 1
1 out of 1 points
The facility manager of an insurance company makes decisions on the monthly purchase
of office supplies. This is an example of an operational decision.
Selected Answer: True
-
Answers: True
False
Question 2 1 out of 1 points
Project teams should document project results and information for future teams. Which
of the following is the project management phase in which the teams perform this
function?
Selected Answer:
finalizing
Answers: starting
planning
finalizing
doing
Question 3 1 out of 1 points
An organization defines the rules that govern a project that it needs to undertake and the
responsibilities of the project team. The project is in the ________ phase of project
management.
Selected Answer:
starting
Answers: finalizing
doing
starting
planning
Question 4
-
1 out of 1 points
The fundamental purpose of the starting phase of a project is ________.
Selected Answer:
setting the ground rules for the project and team
Answers: accomplishing the project tasks effectively
determining tasks and dependencies
setting the ground rules for the project and team
managing tasks and budgets of the project
Question 5 1 out of 1 points
Only one user at a time can open Google Drive documents for editing.
Selected Answer: False
Answers: True
False
Question 6 1 out of 1 points
The task lists of SharePoint are industrial-strength.
Selected Answer: True
Answers: True
False
Question 7 1 out of 1 points
All text messages that the user sends via Lync are automatically recorded and stored in
the user's email folder.
-
Selected Answer: True
Answers: True
False
Question 8 1 out of 1 points
Which of the following statements is true about working with Google Drive?
Selected
Answer:
Google tracks document revisions, with brief summaries of changes
made.
Answers: Documents are stored on the user's personal computer.
Multiple users are not allowed to simultaneously see and edit
documents.
Google tracks document revisions, with brief summaries of changes
made.
Google accounts are not necessarily required to edit documents.
Question 9 1 out of 1 points
________ communication occurs within a team when all team members meet at the
same time.
Selected Answer:
Synchronous
Answers: Sequential
Virtual
Synchronous
-
Unidirectional
Question 10 1 out of 1 points
Which of the following decisions is least likely to involve collaboration?
Selected
Answer:
How much of product A should be ordered from vendor B?
Answers: Should our company acquire company A?
What type of relationship should the company maintain with company
A?
How much of product A should be ordered from vendor B?
What products should we include in the new product line?
Chapter 3 - Using MIS Question 1
1 out of 1 points
A furniture dealer offering a wide variety of designs to premium customers exclusively
is following an industry-wide cost leadership strategy.
Selected Answer: False
Answers: True
False
Question 2 1 out of 1 points
An inventory of raw materials is an example of a repository.
Selected Answer: True
Answers: True
False
-
Question 3 1 out of 1 points
According to Porter's five forces model, in which of the following examples would
rivalry be considered as a weak force affecting the market?
Selected Answer:
Cancer drug manufacturers
Answers: packaged food manufacturers
Cancer drug manufacturers
book sellers
used car dealers
Question 4 1 out of 1 points
Locking in customers by making it difficult or expensive for customers to move to
another product is called establishing high ________.
Selected Answer:
switching costs
Answers: value differentiation
switching costs
entry barriers
product standards
Question 5 0 out of 1 points
In the value chain, the primary activity of customer service is concerned with inducing
buyers to purchase the product and providing a means for them to do so.
-
Selected Answer: True
Answers: True
False
Question 6 1 out of 1 points
Which of the following principles of competitive advantage is related to process
implementations?
Selected Answer:
locking in buyers
Answers:
locking in buyers
enhancing services
differentiating services
creating new products
Question 7 1 out of 1 points
Which of the following is a primary activity in the value chain?
Selected Answer:
receiving and distributing inputs to the product
Answers: negotiating prices with vendors
receiving and distributing inputs to the product
setting up contractual arrangements with various suppliers
finding suitable vendors to supply raw materials
Question 8 1 out of 1 points
-
An organization implements an information system to optimize its supply chain. The
system helps the organization decrease wastages. Hence, the system provides a
competitive advantage to the organization. Here, the information system helped the
organization achieve competitive advantage by ________.
Selected Answer:
reducing costs
Answers:
reducing costs
locking in customers
locking in suppliers
differentiating the products
Question 9 1 out of 1 points
Streamtech, a manufacturer of automobiles, recently received a patent for an unmanned
search boat. By doing this, Streamtech has ________.
Selected Answer:
created an entry barrier
Answers: locked in its suppliers
created an entry barrier
introduced product differentiation
reduced the cost of operations
Question 10 1 out of 1 points
In the next ten years, the ________ is most likely to change.
-
Selected Answer:
pace of integration of new technology
Answers:
pace of integration of new technology
relationship between competitive advantage and IS
model of business strategy
competitive advantage mechanism
Question 1 1 out of 1 points
Which of the following factors determines the structure, features, and functions of an
information system used in a company?
Selected Answer:
the competitive strategy
Answers: the technology used by competitors
the competitive strategy
the size of the company
the value of its brands
Question 2 1 out of 1 points
The difference between the value that an activity generates and the cost of the activity is
called the ________.
Selected Answer:
margin
Answers: revenue
-
value-addition
margin
turnover
Question 3 1 out of 1 points
________ argues that firms should create new, more efficient business processes that
integrate the activities of all departments involved in a value chain.
Selected Answer:
Business process design
Answers:
Business process design
Product differentiation model
Market differentiation model
Business process reengineering
Question 4 1 out of 1 points
A ________ is a collection of something, such as data and raw materials.
Selected Answer:
repository
Answers: linkage
cache
repository
-
value chain
Question 5 1 out of 1 points
Focused differentiation refers to providing a better product or service within an industry
segment.
Selected Answer: True
Answers: True
False
Question 6 0 out of 1 points
Which of the following principles of competitive advantage is related to process
implementations?
Selected Answer:
differentiating products
Answers:
locking in suppliers
differentiating products
creating new products
enhancing services
Question 7 1 out of 1 points
In the context of Porter's five forces model, the bargaining power of suppliers is a weak
force when considering the example of students purchasing gasoline.
Selected Answer: False
Answers: True
False
Question 8
-
1 out of 1 points
According to Porter's model of business activities, interactions across value activities are
called ________.
Selected Answer:
linkages
Answers: cross-functionalities
support activities
linkages
triggers
Question 9 1 out of 1 points
In the inbound logistics activity of a value chain, the manufacturer receives, stores, and
disseminates inputs to a product.
Selected Answer: True
Answers: True
False
Question 10 1 out of 1 points
Hueblue Software, an application provider to the gaming industry, decided to increase
its portfolio by developing motion-control-enabled games for the mobile gaming
industry. In this scenario, which competitive strategy is Hueblue Software
implementing?
Selected Answer:
product differentiation
Answers: reduction of cost
-
locking in suppliers
product differentiation
establishment of alliances
Chapter 4 - Using MISQuestion 1 1 out of 1 points
Mobile systems offer the potential of just-in-time data, which is data delivered to the
user at the precise time it is needed.
Selected Answer: True
Answers: True
False
Question 2 1 out of 1 points
Which of the following is a computer architecture and instruction set that is designed for
portable devices such as phones and tablets?
Selected Answer:
ARM
Answers:
ARM
ASCII
Unix
Mac OS
Question 3 1 out of 1 points
Mobile applications can share their device with other mobile applications.
-
Selected Answer: True
Answers: True
False
Question 4 1 out of 1 points
Mac OS and iOS applications are constructed using Java.
Selected Answer: False
Answers: True
False
Question 5 1 out of 1 points
Programmers cannot alter or add to an open source code.
Selected Answer: False
Answers: True
False
Question 6 1 out of 1 points
A spreadsheet program is an example of ________.
Selected Answer:
horizontal-market application software
Answers:
horizontal-market application software
a firmware
vertical-market application software
an operating system
Question 7
-
1 out of 1 points
Which of the following statements is true of firmware?
Selected Answer:
Users do not need to load firmware into the device's memory.
Answers: The software is coded differently from other software.
Firmware is the same as cache memory.
Users do not need to load firmware into the device's memory.
Firmware cannot be changed or upgraded.
Question 8 1 out of 1 points
A 64-bit, dual processor is needed to effectively utilize more than 4 GB of main
memory.
Selected Answer: True
Answers: True
False
Question 9 1 out of 1 points
A CPU is an example of an input device.
Selected Answer: False
Answers: True
False
Question 10 1 out of 1 points
Quad-processor computers have two CPUs.
-
Selected Answer: False
Answers: True
False
Chapter 5 - Using MIS
A many-to-many (N:M) relationship means that more than one entity is allowed on each side of
the relationship and that the number of entities on each side can be different.
Selected Answer: True
Answers: True
False
Question 2 1 out of 1 points
Every table in a normalized database has a ________.
Selected Answer:
single theme
Answers:
single theme
foreign key
one-to-one relationship between entities
specialized query format
Question 3 1 out of 1 points
The database administrator of an organization constantly manages the processing rights
and responsibilities of employees. This is an example of a(n) ________ task.
Selected Answer:
operational
-
Answers: recovery
operational
development
adaptation
Question 4 1 out of 1 points
A database application is a collection of forms, reports, queries, and application
programs that serves as an intermediary between users and database data.
Selected Answer: True
Answers: True
False
Question 5 1 out of 1 points
________ are the final judges as to what data the database should contain and how the
records in that database should be related to one another.
Selected Answer:
Users
Answers:
Users
Administrators
Designers
Developers
Question 6 1 out of 1 points
-
To modify an existing table, a developer can open the metadata form for that table and
add a new row of metadata.
Selected Answer: True
Answers: True
False
Question 7 1 out of 1 points
A DBMS and database mean the same thing and are synonymous terms that can be used
interchangeably.
Selected Answer: False
Answers: True
False
Question 8 1 out of 1 points
When you modify or delete data present in a database, you are ________.
Selected Answer:
processing the database
Answers:
processing the database
forming a data model
simplifying the data structure
creating a new database
Question 9 1 out of 1 points
The purpose of a database is to keep track of things that involve a single theme.
Selected Answer: False
-
Answers: True
False
Question 10 1 out of 1 points
A database is best described as a collection of unrelated tables.
Selected Answer: False
Answers: True
False
Chapter 6 - Using MISQuestion 1 1 out of 1 points
Wired LAN connections use a protocol standard called Ethernet to communicate.
Selected Answer: True
Answers: True
False
Question 2 1 out of 1 points
In cloud computing, resources are said to be "pooled" because organizations ________.
Selected
Answer:
share the same physical hardware through virtualization
Answers: use open source standards that enable users to modify a program's
source code
offer their services to each other free of charge, in a give-and-take
arrangement
share the same physical hardware through virtualization
use the public Internet to create the appearance of a private connection
-
Question 3 1 out of 1 points
As DSL signals interfere with telephone signals, DSL data transmission and telephone
conversations cannot occur simultaneously.
Selected Answer: False
Answers: True
False
Question 4 1 out of 1 points
Which of the following is true about a VPN?
Selected
Answer:
A VPN client software encrypts messages to ensure secure
transmissions.
Answers: A VPN network does not provide users with remote access.
A VPN connection appears as a secure connection, though it is not.
A VPN client software encrypts messages to ensure secure
transmissions.
A VPN connection utilizes private networks instead of the public
network.
Question 5 1 out of 1 points
The address bar reads "http://www.baron-olufsen.com/" when one visits the Web page of
the luxury brand Baron & Olufsen. This information in the address bar is the ________
of the Web page.
Selected Answer:
URL
-
Answers: IP address
URL
protocol
email ID
Question 6 1 out of 1 points
SOAP is a protocol for requesting web services and for sending responses to web
service requests.
Selected Answer: True
Answers: True
False
Question 7 1 out of 1 points
A URL consists of a protocol followed by a domain name or public IP address.
Selected Answer: True
Answers: True
False
Question 8 1 out of 1 points
A switch detects the speed that a given device can handle and communicates with it at
that speed.
Selected Answer: True
Answers: True
False
Question 9 1 out of 1 points
-
Which of the following TCP/IP application-layer protocols is used to move files over
the Internet and to maintain Web sites?
Selected Answer:
ftp
Answers:
ftp
http
https
smtp
Question 10 1 out of 1 points
Which of the following refers to the three tiers in the three-tier architecture?
Selected Answer:
user,
server,
and
database
Answers: HTML,
XML, and
JSON
TCP, IP,
and HTTP
user,
server,
and
database
tunnel,
switch,
-
and
access
point
Access Quiz 1 Question 1
1 out of 1 points
Enforce referential integrity is one of only two options available
when setting a database relationship with another database.
Selected Answer: False
Answers: True
False
Question 2 1 out of 1 points
________ a database rearranges data and objects in a database to
make its size smaller.
Selected Answer:
Compacting
Answers: Compressing
Backing up
Fragmenting
Compacting
Question 3 1 out of 1 points
Why would you enforce referential integrity?
Selected
Answer:
-
So data cannot be entered into a related table until
the data is entered in the primary table
Answers:
So data cannot be entered into a related table until
the data is entered in the primary table
To determine which software to use Excel or
Access
To avoid accidental deletion of macros
To confirm error free data
Question 4 1 out of 1 points
Alice is working in a database containing the names, service
locations, and services offered by landscapers. She needs to find
landscapers that offer services in the Phoenix area and that
service rare plants. The best way for her to search for this data is
to perform a:
Selected Answer:
Filter by Form.
Answers: Filter by Selection.
Sort Descending.
Filter by Form.
Sort Ascending.
Question 5 1 out of 1 points
The F2 key puts you in Edit mode when in Access.
Selected Answer: False
-
Answers: True
False
Question 6 0 out of 1 points
What is an advantage of using Filter by Form?
Selected
Answer:
The records are also sorted.
Answers: Access automatically saves the results to
storage.
There is no minimum number of records that
can be filtered.
The records are also sorted.
You can use the AND and OR operators.
Question 7 1 out of 1 points
A field that is defined as a primary key in one table is defined as
a(n) ________ in a related table.
Selected Answer:
foreign key
Answers: referential integrity key
foreign key
primary2 key
relational database
Question 8
-
0 out of 1 points
How does the Getting Started page help learn about a database?
Selected
Answer:
The Getting Stated page shows how to create
relationships between tables.
Answers: The Getting Stated page explains what to do if
your system crashes.
The Getting Started page links you to
introductory Access videos.
The Getting Started page details how to install
software.
The Getting Stated page shows how to create
relationships between tables.
Question 9 1 out of 1 points
Information is what is typically entered into a database. Data is
the finished product of the database.
Selected Answer: False
Answers: True
False
Question 10 1 out of 1 points
A template is a predefined database that can be used to jumpstart
the creation of a database.
Selected Answer: True
Answers: True
-
False
Question 1 1 out of 1 points
Enforce referential integrity is one of only two options available
when setting a database relationship with another database.
Selected Answer: False
Answers: True
False
Question 2 1 out of 1 points
Filter by Selection displays only records that match a criterion
that you select.
Selected Answer: True
Answers: True
False
Question 3 1 out of 1 points
You can create a Web app from a Web app template from the
Backstage view.
Selected Answer: True
Answers: True
False
Question 4 1 out of 1 points
A ________ key is the field in the related table that you would
use to connect to the primary key in another table.
Selected Answer:
-
foreign
Answers: merged
secondary
composite
foreign
Question 5 1 out of 1 points
SharePoint is an add-on program for Access.
Selected Answer: False
Answers: True
False
Question 6 1 out of 1 points
You can use Access to create a Web app for sharing data with
others through the Internet.
Selected Answer: True
Answers: True
False
Question 7 1 out of 1 points
People use databases to store collections of data.
Selected Answer: True
Answers: True
False
-
Question 8 1 out of 1 points
When performing a filter by
selection, equals and contains produce the same result.
Selected Answer: False
Answers: True
False
Question 9 1 out of 1 points
A sort can only list records in a database in a specific numeric
sequence.
Selected Answer: False
Answers: True
False
Question 10 1 out of 1 points
An Access database can MOST accurately be described as a
structured collection of:
Selected Answer:
objects.
Answers:
objects.
modules.
tables.
records.
Access Quiz 2 Question 1
-
1 out of 1 points
A query is a question asked about the data in a database.
Selected Answer: True
Answers: True
False
Question 2 1 out of 1 points
When creating a multitable query, in the top section of the query
design, you use ________ lines to connect common fields in
related tables.
Selected Answer:
join
Answers: relationship
connection
common field
join
Question 3 1 out of 1 points
Table modification may be needed after an Excel spreadsheet
has been imported such as:
Selected Answer:
renaming a field.
Answers: updating hyperlinks.
changing the font size.
-
changing the font type.
renaming a field.
Question 4 1 out of 1 points
If data from an Excel worksheet is imported into Access and no
column headings exist, the data will import using:
Selected Answer:
Field1, Field2, Field3, etc.
Answers: Access1, Access2, Access3, etc.
Import1, Import2, Import3, etc.
FieldA, FieldB, FieldC, etc.
Field1, Field2, Field3, etc.
Question 5 1 out of 1 points
Referential integrity should be enforced in a database with
related tables because it:
Selected
Answer:
helps ensure invalid data is not entered into a
table.
Answers: creates a primary key in every table of a
database.
makes the database easier to repair.
helps ensure data is automatically updated.
-
helps ensure invalid data is not entered into a
table.
Question 6 1 out of 1 points
Data redundancy may result in errors.
Selected Answer: True
Answers: True
False
Question 7 1 out of 1 points
The Run command appears as a red exclamation point in Design
view.
Selected Answer: True
Answers: True
False
Question 8 1 out of 1 points
When using Design view, a query can only be sorted on a single
criteria.
Selected Answer: False
Answers: True
False
Question 9 1 out of 1 points
-
A(n) ________ operator, such as the greater than or less than
symbol, can be used in a query criterion to limits the results
produced by the query.
Selected Answer:
comparison
Answers:
comparison
wildcard
delimiter
operand
Question 10 1 out of 1 points
All Excel spreadsheets are ready to import into an Access
database.
Selected Answer: False
Answers: True
False
Access Quiz 3 Question 1
1 out of 1 points
It is NOT possible to add a condition to a Totals query.
Selected Answer: False
Answers: True
False
Question 2 0 out of 1 points
-
When you use a table field in an expression, Access will
automatically correct any spelling errors in the field name.
Selected Answer: [None Given]
Answers: True
False
Question 3 1 out of 1 points
Aggregate functions are most commonly used in all of the
following Access objects EXCEPT:
Selected Answer:
macros.
Answers: reports.
tables.
queries.
macros.
Question 4 1 out of 1 points
Forgetting the colon between a column title and the formula
would give you an invalid syntax error.
Selected Answer: True
Answers: True
False
Question 5 0 out of 1 points
-
When creating a calculated field using field names, Access
automatically surrounds the field names with ________.
Selected Answer:
parentheses ( )
Answers:
brackets [ ]
parentheses ( )
braces { }
quotation marks " "
Question 6 1 out of 1 points
When designing a calculated field, complex formulas can be
created with the:
Selected Answer:
Expression Builder.
Answers: Form Wizard.
Expression Builder.
Table Wizard.
Report Builder.
Question 7 1 out of 1 points
The order of operations specifies that any exponents are
performed first.
Selected Answer: False
-
Answers: True
False
Question 8 0 out of 1 points
When using date data, the date is surrounded by ________.
Selected Answer:
brackets [ ]
Answers: braces { }
parentheses ( )
brackets [ ]
pound signs # #
Question 9 1 out of 1 points
The Calculated fields in Datasheet view can be edited in the
same way other fields from a table are edited.
Selected Answer: False
Answers: True
False
Question 10 1 out of 1 points
The Pmt function returns the monthly payment due on a loan.
Selected Answer: True
Answers: True
False
Question 1
-
1 out of 1 points
When the results of using the COUNT or MAXIMUM aggregate
functions in a query are displayed, they appear in the Total row.
Selected Answer: True
Answers: True
False
Question 2 1 out of 1 points
The arguments to a function are enclosed in:
Selected Answer:
parentheses.
Answers: braces.
parentheses.
brackets.
single-quotation marks.
Question 3 1 out of 1 points
An expression or integer value specifying total number of
payments in a loan is the ________ argument in the PMT
function.
Selected Answer:
num_periods
Answers: rate
present_value
-
future_value
num_periods
Question 4 1 out of 1 points
A ________ query is used to summarize data organized by field
values.
Selected Answer:
grouping
Answers: digest
hierarchical
summary
grouping
Question 5 1 out of 1 points
Which aggregate function would be used to find the least valued
item in a column?
Selected Answer:
MINIMUM
Answers: LOWEST
COUNT
MINIMUM
-
LEAST
Question 6 1 out of 1 points
A query with a Total row is the same as a totals query.
Selected Answer: False
Answers: True
False
Question 7 1 out of 1 points
Which of the following is NOT an Expression Builder
component used when constructing an expression?
Selected Answer:
Expression Arguments
Answers: Expression Categories
Expression Arguments
Expression Elements
Expression Values
Question 8 1 out of 1 points
Which of the following is NOT a Pmt function argument?
Selected Answer:
loan_payment
Answers: present_value
-
rate
loan_payment
future_value
Question 9 0 out of 1 points
It is NOT possible to add a condition to a Totals query.
Selected Answer: [None Given]
Answers: True
False
Question 10 0 out of 1 points
The SUM aggregate function can work with Date/Time data.
Selected Answer: [None Given]
Answers: True
False
Question 1 1 out of 1 points
Sum, Count, and Avg are all examples of aggregate functions.
Selected Answer: True
Answers: True
False
Question 2 1 out of 1 points
Which of the following is NOT a total row option?
-
Selected Answer:
Pmt
Answers: Where
Pmt
Avg
Count
Question 3 1 out of 1 points
A(n) ________ is used to change settings such as formatting and
captions.
Selected Answer:
property sheet
Answers: dialog box
argument menu
parameter list
property sheet
Question 4 1 out of 1 points
Sum, Avg, and Max are examples of ________ functions that are
used to evaluate entire columns of data.
Selected Answer:
aggregate
-
Answers: number
summary
compound
aggregate
Question 5 1 out of 1 points
Multiple arguments in a function are separated by:
Selected Answer:
commas.
Answers:
commas.
colons.
spaces.
semicolons.
Question 6 1 out of 1 points
Calculated fields are created in the Datasheet view of a table.
Selected Answer: False
Answers: True
False
Question 7 0 out of 1 points
-
Following the rules for the order of operations, what is the result
of the following expression: 1 + 2 * 5 ^ 2?
Selected Answer:
101
Answers: 121
225
101
51
Question 8 1 out of 1 points
The Pmt function is BEST suited to determine:
Selected Answer:
the monthly payment on a car loan.
Answers:
the monthly payment on a car loan.
the rate of interest on a car loan.
the due date of a car loan.
the average payment of a car loan.
Question 9 1 out of 1 points
The future_value argument of the Pmt Function is the amount
that is being borrowed.
Selected Answer: False
Answers: True
-
False
Question 10 1 out of 1 points
The present_value argument of the Pmt Function is the amount
owed after the final payment has been made.
Selected Answer: False
Answers: True
False
Wednesday, September
Access Quiz 4 Question 1
1 out of 1 points
A field can be deleted from a report in either Layout or Design
views.
Selected Answer: True
Answers: True
False
Question 2 1 out of 1 points
Form view is used to change a form's data and layout.
Selected Answer: False
Answers: True
False
Question 3 1 out of 1 points
The ________ displays data horizontally across the page.
Selected Answer:
-
Tabular Layout
Answers: Layout
Design View
Stacked Layout
Tabular Layout
Question 4 1 out of 1 points
A ________report is a specialized report that comes
preformatted to coordinate with products such as those
manufactured by Avery.
Selected Answer:
mailing label
Answers: value added
mailing label
rapid distribution
mass distribution
Question 5 0 out of 1 points
When in Layout or Design view, which of the follow is NOT a
form layout tab?
Selected Answer:
Design
Answers: Format
-
Edit
Layout
Design
Question 6 0 out of 1 points
You can sort the data in a form by double-clicking a field and
selecting Sort A to Z or Sort Z to A.
Selected Answer: True
Answers: True
False
Question 7 1 out of 1 points
Which of the following is NOT a view when working with
forms?
Selected Answer:
Tabular
Answers: Form
Tabular
Design
Layout
Question 8 1 out of 1 points
-
What type of form displays records in a tabular layout similar to
a table's Datasheet view but has more editing options, such as
adding graphics and buttons, than a datasheet?
Selected Answer:
multiple Items Form
Answers: subform
multiple Items Form
compound form
split Form
Question 9 1 out of 1 points
Referencing the image above, this form is shown in ________
view.
Selected Answer:
Design
Answers: Layout
Format
Design
Form
Question 10 1 out of 1 points
Which database object is used to add data into or edit data in a table?
-
Selected Answer:
form
Answers:
form
report
query
macro