Accounting Information Systems, 2e (Kay/Ovlia)
Chapter 3 Accounting Interface: Database Forms, Queries, and Reports
Objective 1
1) Accounting systems usually use a GUI to increase the ease of entering and retrieving
accounting data.
2) The accounting interface connects the accountant user to the database behind the screen.
3) The user interface does not need to provide way for the user to query the database.
4) Software interfaces today are less user-friendly than ever.
5) The user friendliness of an interface is a minor selection criteria for an accounting system.
6) As an accountant, you may be asked to evaluate the interface when making a purchase
selection of an accounting system.
7) The ________ connects the accountant to the database.
8) ________ are used to present the output of the system.
9) Designing the interface to minimize keystrokes and time required to enter and retrieve data
________ productivity of the user.
10) A ________ consists of icons that streamline navigation and display logical flow of tasks
within each transaction cycle.
11) What does the accounting interface connect the user to?
A) Database management system
B) Database query
C) Database
D) Database reports
12) Virtually all accounting software uses databases to
A) Store accounting data
B) View database forms
C) Navigate the accounting system
D) Run database queries
13) Which of the following is NOT a component of the accounting interface?
A) Database reports
B) Accounting database
C) Database forms
D) Navigation
14) Which database interface component is typically used to input data?
A) Navigation
B) Reports
C) Forms
D) Queries
15) Which database interface component is typically used to present the output of the system?
A) Forms
B) Navigation
C) Reports
D) Queries
16) Which database interface component is typically used to search the database?
A) Forms
B) Queries
C) Reports
D) Navigation
17) The interface navigation allows the user to access the following interface components
EXCEPT
A) Forms
B) Reports
C) Queries
D) DBMS
18) Which of the following database interface components retrieves data from the database?
A) Database query
B) Database form
C) Database report
D) Database navigation
19) The ability of an interface to guide the user in a self-explanatory, logical manner is part of
which user interface characteristic?
A) Streamlined, uncluttered design
B) Enhanced productivity
C) Effortless navigation
D) Customizable preferences
20) Which of the types of user interface tools lets a user enter data, such as a user name?
A) Icon
B) Text box
C) List box
D) Radio button
21) Which of the types of user interface tools is a graphical image?
A) Radio button
B) Icon
C) List box
D) Text box
22) The accounting system’s front-end user interface is serviced by which three database
essentials? What service does each database essential perform?
23) You are an accountant at a medium-sized company, your boss asks you to evaluate the
interface of an accounting she is thinking about purchasing. What interface characteristics do you
consider during your evaluation and why?
24) What are four things that make an accounting system interface more user-friendly?
25) List 5 types of interface tools that help a user interact with the accounting system.
Objective 2
1) Database forms allow a user to record accounting transactions that are the result of various
business processes.
2) Data validation tools ensure data is entered multiple times.
3) Database forms do not need security to limit data access or data entry.
4) Database forms are often designed to automatically complete portions of the form after the
users makes a selection.
5) ________ are used to record accounting transactions resulting from various activities
associated with the modules in an accounting system.
6) An example of complying with the ________ guideline is a form that enters a customer
address after a user selects a customer name.
7) Using an input mask to format a field for a specific number of characters is a ________
technique.
8) Database forms should have appropriate ________ to prevent unauthorized access to data.
9) In a baseline accounting system, a bill entry form is usually associated with the ________
module.
10) In a baseline accounting system, an onscreen journal form is usually associated with the
________ module.
11) To build a database form, a developer uses a ________.
12) Which of the following is NOT a general guideline for database form design?
A) Design user-friendly forms
B) Use data validation
C) Enter data twice
D) Enable auto entry
13) Which of the following types of data validation helps prevent dirty data in the database?
A) Range checks
B) Input mask
C) Drop-down list
D) Limit checks
14) User-friendly data entry forms
A) Do not look like paper forms
B) Ensures dirty data
C) Mirror paper forms
D) Requires entering data twice
15) Which of the following types of data validation formats a data entry field for a specific
number of characters?
A) Input mask
B) Range checks
C) Input masks
D) Drop-down list
16) Which database form design guideline involves executing a database query to retrieve data
so the system can populate a form?
A) Appropriate security measures
B) Enter data once
C) Auto entry
D) Data validation
17) When a web-based form uses encryption for confidential customer information, which form
design guideline is being followed?
A) Mirror paper forms
B) Enter data once
C) Design user-friendly forms
D) Appropriate security measures
18) When a login form masks the password, which form design guideline is being followed?
A) Appropriate security measures
B) Mirror paper forms
C) Enable auto entry
D) Enter data once
19) Database programs for building database forms include all the following EXCEPT
A) Valid data
B) Drop-down lists
C) Icons
D) Command buttons
20) The financial module would use a form to perform which of the following activities?
A) Reconcile bank statements
B) Make adjusting entries
C) Receive inventory
D) Add employees
21) One of the general guidelines for database form design is “enable auto entry.” What is “auto
entry”? Please provide an example.
22) What is dirty data? Provide an example.
23) What is the best method for preventing dirty data from being added to a database?
24) What is data validation? Provide an example.
25) Provide an example of including appropriate security measures in database form design.
26) What are some of the typical database forms used in the vendor module of a baseline
accounting system?
27) You are an accountant in a small company that is installing a new accounting system You are
asked to provide some suggestions for the various field of the form for entering new customer
information. What are your suggestions?