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

Question 1

Many accounting software interfaces use ________ to increase ease of use.

Answer 1

graphical user interfaces (GUI)

Question 2

Which database interface component is typically used to search the database?

A)Queries
B)Forms
C)Navigation
D)Reports

Answer 2

A

Question 3

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

Answer 3

False

Question 4

The interface navigation allows the user to access the following interface components except?

A)Reports
B)DBMS
C)Forms
D)Queries

Question 5

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

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

Question 6

A complex user interface can result in a large percentage of the features being used.

Question 7

A well designed interface uses various interface tools effectively so that only valid data is entered to ensure data integrity and quality.

Question 8

One of the characteristics that make software more user friendly is

A)Complex navigation
B)Cluttered design
C)Customizable preferences
D)Maximum number of keystrokes

Question 9

The ________ connects the accountant to the database.

Question 10

Which database interface component is typically used to input data?

A)Queries
B)Forms
C)Navigation
D)Reports

Question 11

Which database interface component is typically used to present the output of the system?

A)Queries
B)Forms
C)Navigation
D)Reports

Question 12

________ are used to present the output of the system.

Question 13

What does the accounting interface connect the user to?

A)Database management system
B)Database query
C)Database
D)Database reports

Question 14

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

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

Question 15

Which of the following is not a component of the accounting interface?

A)Database forms
B)Navigation
C)Database reports
D)Accounting database

Question 16

Which of the following database interface components retrieves data from the database?

A)Database report
B)Database navigation
C)Database form
D)Database query

Question 17

The user friendliness of an interface is a minor selection criteria for an accounting system.

Question 18

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

Question 19

Database forms are used to input data into the system.

Question 20

An effective accounting system has a ________ interface.

Question 21

Which of the following types of data validation helps prevent dirty data in the database?

A)Limit checks
B)Drop-down list
C)Range checks
D)Input mask

Question 22

The following accounting baseline modules use database forms except

A)Reports module
B)Customer module
C)Banking module
D)Vendor module

Question 23

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

Question 24

Database forms do not need security to limit data access or data entry.

Question 25

Using an input mask to format a field for a specific number of characters is a ________ technique.

Question 26

What are four things that make an accounting system interface more user-friendly?

Question 27

Which of the types of user interface tools is a graphical image?

A)Radio button
B)Icon
C)List box
D)Text box

Question 28

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

Question 29

Onscreen forms may use data validation to help minimize errors.

Question 30

To save time, database forms often ________ paper forms.

Question 31

To build a database form, a developer uses a ________.

Question 32

Data validation

A)Makes data entry for the user difficult
B)Ensures only valid data is entered
C)Is not necessary for relational databases
D)Requires entering data twice

Question 33

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

Question 34

The accounting system's front-end user interface is serviced by which three database essentials? What service does each database essential perform?

Question 35

________ tools help prevent dirty data from being inserted into a database.

Question 36

In a baseline accounting system, a bill entry form is usually associated with the ________ module.

Question 37

In a baseline accounting system, an onscreen journal form is usually associated with the ________ module.

Question 38

________ are used to record accounting transactions resulting from various activities associated with the modules in an accounting system.

Question 39

Which of the following types of data validation formats a data entry field for a specific number of characters?

A)Limits checks
B)Drop-down list
C)Range checks
D)Input mask

Question 40

Database programs provide tools for building database forms for accounting interface development.

Question 41

What is data validation? Provide an example.

Question 42

What is dirty data? Provide an example.

Question 43

Which database form design guideline involves executing a database query to retrieve data so the system can populate a form?

A)Enter data once
B)Data validation
C)Appropriate security measures
D)Auto entry

Question 44

The content in a database report is often linked to ________.

Question 45

The design of the reports should be consistent with the user requirements.

Question 46

You are an accountant in a small company and were 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?

Question 47

Management reports are used by external parties to make decisions, such as, whether or not to make a loan to a company.

Question 48

What are some of the typical database forms used in the employee module of a baseline accounting system?

Question 49

What are some typical database forms used in the customer module of a baseline accounting system?

Question 50

________ may be used to email electronic reports to users on a scheduled basis.

Question 51

Reports that provide up-to-the minute data without lag time are call ________.

Question 52

List the 6 general guidelines for database form design discussed in the text.

Question 53

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

Question 54

Which form would be used in the baseline customer module?

A)Purchase order
B)Deposit slip
C)Credit memo
D)B and C

Question 55

When a web-based form uses encryption for confidential customer information, which form design guideline is being followed?

A)Design user-friendly forms
B)Appropriate security measures
C)Mirror paper forms
D)Enter data once

Question 56

Database reports display the formatted results of database queries.

Question 57

What are some of the typical database forms used in the vendor module of a baseline accounting system?

Question 58

Which form would be used in the baseline vendor module?

A)Purchase order
B)Time sheet
C)Credit memo
D)Deposit slip

Question 59

What is the best method for preventing dirty data from being added to a database?

Question 60

The difference between Real-time reports and Live reports is Real-time reports continuously provide up-to-the minute data.

Question 61

The ability to understand SQL programming may be needed to successfully conduct an IT audit.

Question 62

The output of an accounting system typically appears in

A)A report format
B)A query
C)Database
D)An icon

Question 63

Query builder tools may be referred to as query-by-example.

Question 64

Database queries are ________ that retrieve data from the database.

Question 65

What are the three typical output formats for reports?

Question 66

Queries may be used with database forms to update data in the database.

Question 67

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

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

Question 68

What is the difference between a real-time report and a live report?

Question 69

Which types of reports are directed to internal users and are created as needed?

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

Question 70

________ may be used with database forms to update data in the database.

Question 71

How can a database report be interactive?

Question 72

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

Question 73

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

Question 74

Cyberattacks are injecting malicious SQL programming code into a company's SQL queries to retrieve confidential data.

Question 75

Which of the following is not a report builder tool?

A)Radio button
B)Text box
C)Chart holder
D)Command button

Question 76

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

Question 77

Database reports display the formatted results of ________.

Question 78

Query builder tools make it possible to build queries using programming code.

Question 79

Which reports are external reports given to outside parties?

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 80

List and describe the four basic types of accounting reports.