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

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

To save time, database forms often ________ paper forms.

Data validation

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

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

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

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

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

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

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

What is Structured Query Language or SQL?

The following accounting baseline modules use database forms except

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

When writing a Structured Query Language statement, what three things do you need to know?

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

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

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

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 vendor.

Query results are displayed in

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