Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help with the answers for accounting information system Validation rules are useful to prevent data entry errors in databases. True False Which one of

Please help with the answers for accounting information system

image text in transcribed Validation rules are useful to prevent data entry errors in databases. True False Which one of these is not a good guideline to follow when creating tables in a relational database? Design first, create tables later Name tables systematically, using conventional \"tbl\" prefixes Use mnemonic names for data fields Assign at least 50 characters to each text field Use consistent data types for primary and foreign key fields The purpose of an input mask is to: Disguise data when they are first input into a database Transform data from alphabetic to numeric formats Help users avoid data entry errors Hide sensitive data such as passwords onscreen In QB, an appropriate field in which to use a default value would be Customer phone number Employee SSN Date on a check Number of items on an invoice both c and d A querie is used to extract information from a database True False In a database, like Access, the terms \"size,\" \"data type,\" and \"input mask\" are mostly closely associated with: A table A record A data field A database An agent It would be appropriate to store zip codes as a field type "text" as opposed to "number" True False Which of the following is not an example of a form for entering data in QuickBooks? Invoice Bill Check register Income Statement These are all examples of QB forms Many reports extract information from tables, and then calculate results in "calculated fields" True False Reports pull information fields directly from tables; queries are never used. True False The chart of accounts in QB is an example of a report. True False QuickBooks reports can be customized extensively True False You must run a report to find the balance of an asset account in QB. True False You have to use a report to get the balances for revenue and expense accounts because that way the business owners can control who sees the information. revenue and expense are equity accounts revenue and expense accounts are only second normal form, while balance sheet accounts are third normal, so a report must be used to normalize the accounts income statement accounts are for a time period, and are not permanent accounts like balance sheet accounts that always have a running "snapshot" balance. revenue and expense accounts are not as important as other accounts in the day-to-day running of a business. Suppose an employee's date of hire is changed in an employee table. When a database user subsequently runs a report showing the number of years the employee has worked for the company (a calculated field), what will happen? Nothing. The same value that was calculated in any prior report will continue to show in the new report The new report will show a new calculated value The new report will show the average of the original value and the new value This depends upon other settings not indicated in the statement Which of these is not an example of a calculated field? Unit cost of an item Extension amount Sales tax Grand total all of these are calculated fields Manual forms, in terms of database form design, are: Rarely useful Used to guide the development of electronic forms Used to collect information electronically Self-calculating Difficult to translate into computer forms if they are multi-part Reports enable users to: Change information in the underlying database tables See summarized output of database information in a familiar, usable form Limit the distribution of database information Re-format input masks Test validation parameters

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting Chapters 1-15

Authors: James A Heintz, Robert W Parry

19th Edition

0324376162, 978-0324376166

More Books

Students also viewed these Accounting questions