Question 1

What is a query builder tool?

Accepted Answer

A query builder tool allows you to create queries without using programming code. They are also called query-by-example.

Question 2

SQL queries allow you to search, insert, update, and delete data from a relational database.

Accepted Answer

A) True 
 B)False  True

Question 3

Many accounting software interfaces use a graphical user interface (GUI)to

Accepted Answer

A) Increase the ease of use 
B) Increase the amount of time needed to enter data 
C) Make the software appear more complex than necessary 
D) Increase user confusion 
A) Increase the ease of use 
B) Increase the amount of time needed to enter data 
C) Make the software appear more complex than necessary 
D) Increase user confusion A

Question 4

Database forms allow a user to record accounting transactions that are the result of various business processes.

Accepted Answer

A) True 
 B)False

Question 5

Accounting systems usually use a GUI to increase the ease of entering and retrieving accounting data.

Accepted Answer

A) True 
 B)False

Question 6

Which types of reports are used by stakeholders to evaluate a company's ability to respond to economic, environmental, and social challenges?

Accepted Answer

A) Financial accounting and regulatory reports 
B) Tax reports 
C) Management reports 
D) Sustainability accounting reports 
A) Financial accounting and regulatory reports 
B) Tax reports 
C) Management reports 
D) Sustainability accounting reports

Question 7

The user interface does not need to provide way for the user to query the database.

Accepted Answer

A) True 
 B)False

Question 8

List 5 types of interface tools that help a user interact with the accounting system.

Accepted Answer

Icons
Command buttons
Radio bu

Question 9

What are the three typical output formats for reports?

Accepted Answer

Displayed on screen

Question 10

What are the four main interface components of an accounting interface? What is the purpose of each component?

Accepted Answer

Navigation - Permits the user to move th

Question 11

The ability of an interface to guide the user in a self-explanatory, logical manner is part of which user interface characteristic?

Accepted Answer

A) Effortless navigation 
B) Streamlined, uncluttered design 
C) Customizable preferences 
D) Enhanced productivity 
A) Effortless navigation 
B) Streamlined, uncluttered design 
C) Customizable preferences 
D) Enhanced productivity

Question 12

The second main clause of an SQL statement is the

Accepted Answer

A) Criteria 
B) Action 
C) Table name 
D) Field name 
A) Criteria 
B) Action 
C) Table name 
D) Field name

Question 13

Which of the following is not an important reason to understand SQL programming?

Accepted Answer

A) To reduce reliance on IT programmers 
B) SQL injection cyberattacks are becoming more common 
C) To successfully conduct IT audits 
D) To add data to a relational database 
A) To reduce reliance on IT programmers 
B) SQL injection cyberattacks are becoming more common 
C) To successfully conduct IT audits 
D) To add data to a relational database

Question 14

Which reports are external reports given to outside parties?

Accepted Answer

A) Regulatory reports and tax reports 
B) Tax reports and management reports 
C) Management reports and regulatory reports 
D) Financial accounting reports and management reports 
A) Regulatory reports and tax reports 
B) Tax reports and management reports 
C) Management reports and regulatory reports 
D) Financial accounting reports and management reports

Question 15

Database forms are used to input data into the system.

Accepted Answer

A) True 
 B)False

Question 16

List the three financial statement most frequently used by external users.

Accepted Answer

Profit and Loss Stat

Question 17

List and describe the four basic types of accounting reports.

Accepted Answer

Financial accounting and regulatory repo

Question 18

Database programs provide tools for building database reports. List four tools.

Accepted Answer

Text boxes
Field lab

Question 19

When a login form masks the password, which form design guideline is being followed?

Accepted Answer

A) Appropriate security measures 
B) Mirror paper forms 
C) Enable auto entry 
D) Enter data once 
A) Appropriate security measures 
B) Mirror paper forms 
C) Enable auto entry 
D) Enter data once

Question 20

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 train the accountants. Explain how a data base query would be used with a database for to update the address information of a company's customer.

Accepted Answer

Queries can be used with database forms

What is a query builder tool?

SQL queries allow you to search, insert, update, and delete data from a relational database.

Many accounting software interfaces use a graphical user interface (GUI)to

Database forms allow a user to record accounting transactions that are the result of various business processes.

Accounting systems usually use a GUI to increase the ease of entering and retrieving accounting data.

Which types of reports are used by stakeholders to evaluate a company's ability to respond to economic, environmental, and social challenges?

The user interface does not need to provide way for the user to query the database.

List 5 types of interface tools that help a user interact with the accounting system.

What are the three typical output formats for reports?

What are the four main interface components of an accounting interface? What is the purpose of each component?

The ability of an interface to guide the user in a self-explanatory, logical manner is part of which user interface characteristic?

The second main clause of an SQL statement is the

Which of the following is not an important reason to understand SQL programming?

Which reports are external reports given to outside parties?

Database forms are used to input data into the system.

List the three financial statement most frequently used by external users.

List and describe the four basic types of accounting reports.

Database programs provide tools for building database reports. List four tools.

When a login form masks the password, which form design guideline is being followed?

Accounting Systems Insights

XBRL: Intelligent Business Reporting

Accounting and Sustainability Intelligence

Accounting and Business Intelligence

Integrated Enterprise Systems

Business Processes: Purchasing, Sales, and Payroll Cycles

Accounting Systems and Business Processes

Accounting Databases

Database Design: ERD, REA, and SQL

Accounting System Development

The Risk Intelligent Enterprise: Enterprise Risk Management

Cybersecurity

Fraud and Internal Control

Filters

Exam 3: Accounting Interface: Database Forms, Queries, and Reports

What is a query builder tool?

SQL queries allow you to search, insert, update, and delete data from a relational database.

Many accounting software interfaces use a graphical user interface (GUI)to

Database forms allow a user to record accounting transactions that are the result of various business processes.

Accounting systems usually use a GUI to increase the ease of entering and retrieving accounting data.

Which types of reports are used by stakeholders to evaluate a company's ability to respond to economic, environmental, and social challenges?

The user interface does not need to provide way for the user to query the database.

List 5 types of interface tools that help a user interact with the accounting system.

What are the three typical output formats for reports?

What are the four main interface components of an accounting interface? What is the purpose of each component?

The ability of an interface to guide the user in a self-explanatory, logical manner is part of which user interface characteristic?

The second main clause of an SQL statement is the

Which of the following is not an important reason to understand SQL programming?

Which reports are external reports given to outside parties?

Database forms are used to input data into the system.

List the three financial statement most frequently used by external users.

List and describe the four basic types of accounting reports.

Database programs provide tools for building database reports. List four tools.

When a login form masks the password, which form design guideline is being followed?

Accounting Systems Insights

XBRL: Intelligent Business Reporting

Accounting and Sustainability Intelligence

Accounting and Business Intelligence

Integrated Enterprise Systems

Business Processes: Purchasing, Sales, and Payroll Cycles

Accounting Systems and Business Processes

Accounting Databases

Database Design: ERD, REA, and SQL

Accounting System Development

The Risk Intelligent Enterprise: Enterprise Risk Management

Cybersecurity

Fraud and Internal Control

Filters