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

Question 1

Which database interface component is typically used to input data?

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

Answer 1

C

Question 2

A ________ consists of icons that streamline navigation and display logical flow of tasks within each transaction cycle.

Answer 2

graphical user interfaces (GUI)

Question 3

As an accountant, you may be asked to evaluate the interface when making a purchase selection of an accounting system.

Answer 3

True

Question 4

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

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

Question 5

What does the accounting interface connect the user to?

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

Question 6

Software interfaces today are less user-friendly than ever.

Question 7

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

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

Question 8

The accounting interface connects the accountant user to the database behind the screen.

Question 9

________ are used to present the output of the system.

Question 10

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

Question 11

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

Question 12

The ________ connects the accountant to the database.

Question 13

Virtually all accounting software uses databases to

A)Store accounting data
B)View database forms
C)Navigate the accounting system
D)Run database queries

Question 14

Designing the interface to minimize keystrokes and time required to enter and retrieve data ________ productivity of the user.

Question 15

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

Question 16

The interface navigation allows the user to access the following interface components EXCEPT

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

Question 17

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

Question 18

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

Question 19

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

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

Question 20

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

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

Question 21

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

Question 22

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?

Question 23

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

Question 24

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

Question 25

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

Question 26

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

Question 27

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

Question 28

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

Question 29

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

Question 30

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

Question 31

Database forms are often designed to automatically complete portions of the form after the users makes a selection.

Question 32

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

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

Question 33

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

Question 34

Database forms should have appropriate ________ to prevent unauthorized access to data.

Question 35

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

Question 36

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

Question 37

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

Question 38

An example of complying with the ________ guideline is a form that enters a customer address after a user selects a customer name.

Question 39

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

Question 40

Data validation tools ensure data is entered multiple times.

Question 41

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

Question 42

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 43

Database programs for building database forms include all the following EXCEPT

A)Valid data
B)Drop-down lists
C)Icons
D)Command buttons

Question 44

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

Question 45

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

Question 46

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

Question 47

Sustainability reports are increasingly demanded by managers to evaluate an enterprise's responsiveness to economic, environmental, and social sustainability challenges.

Question 48

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

Question 49

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

Question 50

What is data validation? Provide an example.

Question 51

Database reports display the formatted results of database queries.

Question 52

What is dirty data? Provide an example.

Question 53

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

Question 54

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?

Question 55

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

Question 56

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?

Question 57

One of the general guidelines for database form design is "enable auto entry." What is "auto entry"? Please provide an example.

Question 58

Information broadcasting can be used to email electronic reports to end users on a scheduled basis.

Question 59

Provide an example of including appropriate security measures in database form design.

Question 60

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

Question 61

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

Question 62

Which of the following is NOT a report builder tool?

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

List and describe the four basic types of accounting reports.

Question 69

How can a database report be interactive?

Question 70

________ reports are used by external parties to make decisions.

Question 71

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

Question 72

________ reports are used by internal parties to make decisions.

Question 73

What are the three typical output formats for reports?

Question 74

To successfully conduct an IT audit, you must understand ________.

Question 75

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

Question 76

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

Question 77

Why are financial reports provided to external users? Please provide an example.

Question 78

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

Question 79

What is the objective of tax returns? Do the same rules for financially statements apply to the tax returns?

Question 80

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