28) You are an accountant in a small company and are asked to work with the IT to redesign the
user interface. The IT database designer proposes using interface below. What changes should be
made to the form?
Objective 3
1) Sustainability reports are increasingly demanded by managers to evaluate an enterprise’s
responsiveness to economic, environmental, and social sustainability challenges.
2) The difference between Real-time reports and Live reports is that Real-time reports
continuously provide up-to-the minute data.
3) Information broadcasting can be used to email electronic reports to end users on a scheduled
basis.
4) Database reports display the formatted results of database queries.
5) ________ may be used to email electronic reports to users on a scheduled basis.
6) Reports that provide up-to-the minute data without lag time are call ________.
7) The content in a database report is often linked to ________.
8) ________ reports are used by external parties to make decisions.
9) ________ reports are used by internal parties to make decisions.
10) Which types of reports are used by stakeholders to evaluate a company’s ability to respond to
economic, environmental, and social challenges?
A) Management reports
B) Sustainability accounting reports
C) Tax reports
D) Financial accounting and regulatory reports
11) Which report is an internal management report?
A) Contribution Margin Income Statement
B) Balance sheet
C) State income tax report
D) Statement of Cash Flows
12) Which reports are external reports given to outside parties?
A) Financial accounting reports and management reports
B) Tax reports and management reports
C) Regulatory reports and tax reports
D) Management reports and regulatory reports
13) Which report is submitted to the Securities and Exchange commission?
A) Operating and Capital Budgets
B) Cost-Volume-Profit Analysis
C) Profit and Loss
D) Contribution Margin Income Statement
14) Which of the following is NOT a report builder tool?
A) Radio button
B) Text box
C) Chart holder
D) Command button
15) List and describe the four basic types of accounting reports.
16) What are the three typical output formats for reports?
17) Why are financial reports provided to external users? Please provide an example.
18) What is the objective of tax returns? Do the same rules for financially statements apply to the
tax returns?
19) How can a database report be interactive?
20) Database programs provide tools for building database reports. List four tools.
1) Queries may be used with database forms to update data in the database.
2) Query builder tools make it possible to build queries using programming code.
3) Query builder tools may be referred to as query-by-example.
4) The ability to understand SQL programming may be needed to successfully conduct an IT
audit.
5) SQL queries allow you to search, insert, update, and delete data from a relational database.
6) Cyberattacks are injecting malicious SQL programming code into a company’s SQL queries to
retrieve confidential data.
7) To successfully conduct an IT audit, you must understand ________.
8) A relational database is searched and data is retrieved using ________.
9) Query builder tools may be referred to as ________.
10) The ________ translates the query statement into action.
11) Queries may be used with ________ to update data in the database.
A) navigation
B) forms
C) reports
D) tables
12) Queries are questions you ask about
A) Information in a report
B) Data provided in the search results
C) Data stored in a database
D) None of the above
13) For relational databases, queries are usually written in
A) SQL
B) RDBMS
C) QBL
D) RQL
14) Each SQL statement contains the following EXCEPT
A) Field name
B) Database name
C) Action
D) Table name
15) Query builder tools
A) Generate SQL programming code
B) Increase an accountant’s dependance on IT developers
C) Complicate the process of writing SQL programming code
D) Require the ability the write RDBMS programming code
16) Which tier translates the SQL statement into action?
A) User tier
B) Application tier
C) Interface tier
D) Database tier
17) Query builder tools may be referred to as
A) Query-by-code
B) Query-by-icons
C) Query-by-example
D) Query-by-patterns
18) The third main clause of an SQL statement is the
A) Table name
B) Field name
C) Criteria
D) Action
19) The fourth main clause of an SQL statement is the
A) Table name
B) Field name
C) Criteria
D) Action
20) What are cyberattacks increasingly using to extract confidential data?
A) Relational databases
B) SQL programming code
C) Database reports
D) GAAP programming code
21) You are an intern in a large company. The company would like to improve the
communications between the accountants and IT. Because of your background in AIS, you are
asked to explain to the accountants how a data base query would be used with a database to
update the address information of a company’s vendor.
22) You are an intern in a large company. The company would like to improve the
communications between the accountants and IT. Because of your background in AIS, you are
asked to explain to the accountants how a data base query would be used with a database to
update the address information of a company’s customer.
23) What is a query builder tool?
24) List the activities Structure Query Language enables you to perform on a relational database.
25) What are the four main clauses in SQL statements? Provide an example of each clause.
Use the database tables below to answer the following questions.
26) Write the SQL query to retrieve customer’s addresses.
27) Write the SQL query to retrieve the sales orders for all customer with a zip code of 63011.