Search
Info
Warning
Danger

Study Resources (Accounting)

31) Which of the relationships below is a many-to-many relationship? A) VENDORS, PURCHASE ORDERS B) PURCHASE ORDERS, ITEMS C) ITEMS, PO LINE D) PO LINE, VENDORS 32) The ________ table is an intersection table. A) VENDORS B) PURCHASE ORDERS C) ITEMS D) PO LINE 33) By using an intersection table, which field can be removed from the PURCHASE ORDERS table? A).
0 Views
View Answer
Objective 3 1) Management reports are used by external parties to make decisions, such as, whether or not to make a loan to a company. 2) The difference between Real-time reports and Live reports is Real-time reports continuously provide up-to-the minute data. 3) The design of the reports should be consistent with the.
0 Views
View Answer
Spice House Receive Items Narrative When Spice House receives the inventory items from the vendor, an employee verifies the items listed on the packing slip with the items listed on the purchase order. Then another employee records the items received and database tables are updated. Spice House generates a receiving report.
0 Views
View Answer
Spice House Purchase Order Narrative On Monday of each week, the manager of Spice House generates an inventory report. For items that are low, the manager creates a purchase order. The manager sends the purchase order to the vendor. Spice House database tables: Item, Customer, Sales Order, Sales Order Line, Vendor, Purchase.
0 Views
View Answer
11) To build a database form, a developer uses a ________. 12) The following accounting baseline modules use database forms except A) Reports module B) Customer module C) Banking module D) Vendor module 13) 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.
0 Views
View Answer
11) Queries may be used with ________ to update data in the database. A) Reports B) Navigation C) Forms D) Tables 12) Query results are displayed in A) Database forms and SQL statements B) Database forms and reports C) Database tables and reports D) Database tables and SQL statements 13) Database queries can retrieve data from A) Multiple forms B) Multiple reports C).
1 Views
View Answer
Objective 3 1) In a hierarchical database, data is retrieved using record addresses. 2) In a network database, a parent record can have many child records and each child record can have only one parent record. 3) What IT professionals call people or things, accounting professionals call objects. 4) A database table that stores.
0 Views
View Answer
19) List the datastores in the EspressoCoffee Make Deposit DFD. 20) List the events in the EspressoCoffee Make Deposit DFD. 21) List the agents in the EspressoCoffee Make Deposit DFD. 22) What DFD level is the EspressoCoffee Make Deposit DFD? How do you know this? 23) Create an EAD table for EspressoCoffee Make Deposit.
0 Views
View Answer
Objective 2 1) Data stored in a data warehouse is used for routine business activities. 2) The ________ is responsible for managing the enterprise's databases. 3) Data stored in a ________ may be current data, historical data, or future estimates. 4) ________ databases are databases containing data collected by other organizations. 5) To retrieve data.
0 Views
View Answer
11) Which table would be used when processing a purchase order? A) Customer table B) Employee table C) Item table D) Invoice Line table 12) When receiving inventory, which table is usually not used? A) Cash Account table B) Purchase Order table C) Vendor table D) Item table Acme Purchase Narrative Acme needs to purchase more copper to make widgets. Acme.
0 Views
View Answer
Objective 4 1) Normalization is the process of increasing data redundancy in a relational database. 2) To maintain entity integrity, a relational database designer will allow multiple records to have the same primary key value. 3) To maintain primary key integrity, a relational database designer will not allow a primary key to have.
0 Views
View Answer
6) A rounded rectangle on a data flow diagram indicates a(n) ________ in an accounting system. 7) Lines and arrows indicate ________ in an accounting system. 8) In a data flow diagram, what does the Agent represent? A) What B) Where C) Who D) When/How 9) In a data flow diagram, what does the Event represent? A) What B).
0 Views
View Answer
Objective 4 1) Queries may be used with database forms to update data in the database. 2) Query builder tools make it possible to build queries using programming code. 3) Query builder tools may be referred to as query-by-example. 4) The ability to understand SQL programming may be needed to successfully conduct an IT.
0 Views
View Answer
Spice House Cash Deposit Narrative When Spice House makes cash deposits, the manager counts the cash and creates a deposit slip. The database tables are automatically updated. Spice House database tables: Item, Customer, Sales Order, Sales Order Line, Vendor, Purchase Order, Purchase Order Line, Employees, Employee Type, Time, Cash Receipts, Cash Account,.
0 Views
View Answer
Use the database table below to answer the following questions. 14) You are an accountant at a small company and you are reviewing the vendor database table. Identify the database anomalies shown and explain how they impact this database. 15) What suggestions would you give the database designer? How should the database.
1 Views
View Answer
Objective 2 1) Database forms allow a user to record accounting transactions that are the result of various business processes. 2) Onscreen forms may use data validation to help minimize errors. 3) Database forms do not need security to limit data access or data entry. 4) Database programs provide tools for building database forms.
0 Views
View Answer
30) Create an Event-Agent-Datastore table based on the Books Ga'Lore! customer order process data flow diagram. 31) Write a narrative based on the Books Ga'Lore! customer order process data flow diagram. 32) A friend is taking this AIS course and is having trouble understanding the difference between the various levels of data.
0 Views
View Answer
11) A ________ identifies the differences between the baseline modules and the customization required to meet enterprise-specific needs. 12) The ________ approach to customization involves customizing and installing customer, vendor, employee, and remaining modules for the entire enterprise at the same time. 13) The advantage to the ________ approach is that the.
1 Views
View Answer
Objective 3 1) Data flow diagrams are pictorial descriptions of business processes. 2) ________ focus on business processes using a pictorial, nontechnical view that is well suited to learning, designing, and understanding accounting systems. 3) Programmers often use ________ for designing computer program logic. 4) ________ is best suited for object-oriented programming purposes. 5).
0 Views
View Answer
21) An intersection table's primary key is a(n) ________. 22) Generally, the relationship between a table that stores customer data and table that stores sales order data is ________. 23) Generally, the relationship between a table that stores sales order data and a table that stores inventory data is ________. 24) To record.
0 Views
View Answer
Objective 4 1) Payroll consists of printing payroll checks and paying payroll liabilities. 2) The pay employees and pay payroll liabilities are part of the ________ baseline accounting module. 3) The ________ module consists of transactions related to payroll. Acme Process Payroll Liabilities Acme has an automated process for paying the payroll liabilities. On the.
0 Views
View Answer
42) What are the basic steps for creating an accounting database? 43) What is the purpose of a foreign key? Provide an example. 44) Describe the types of relationships possible between tables in a relational database. Indicate whether each relationship is desirable in a relational database. 45) What are the basic steps for.
0 Views
View Answer
22) The accounting system's front-end user interface is serviced by which three database essentials? What service does each database essential perform? 23) What are the four main interface components of an accounting interface? What is the purpose of each component? 24) What are four things that make an accounting system interface more.
0 Views
View Answer
11) Create a narrative for the Books Ga'Lore! Payroll DFD. Payroll DFD 12) List the datastores in the Payroll DFD. 13) List the agents in the Payroll DFD. 14) List the events in the Payroll DFD. 15) List the data flows in the Payroll DFD. Objective 5 1) DFDs can also be used to document processes for.
1 Views
View Answer
3) Since most accounting systems use databases to store accounting data, the account balances are calculated using various database tables. 4) When customizing an off-the-shelf accounting system, the company drills down to develop a detailed view of the accounting system. 5) When a new accounting system is developed, organizations rarely streamline business.
1 Views
View Answer
16) What are the transactions typically associated with vendors? Please define each transaction. 17) What are the transactions typically associated with customers? Please define each transaction. 18) What are the transactions typically associated with employees? Please define each transaction. 19) What are the transactions typically associated with the banking module of a baseline.
0 Views
View Answer
16) Which of the following are events in the Order DFD? A) Verify Order Forms, Verify Customer Credit, Customer Information B) Verify Customer Identity, Verify Order Forms, Store Order Information C) Sales Order Line and Sales Order D) Store Order Information and Item information 17) Which of the following are not data flows in the.
1 Views
View Answer
15) Create an EAD table for EspressoCoffee Receive Customer Payment DFD. Spice House Cash Sale Narrative When the Spice House makes a cash sale, a sales receipt is generated and the employee gives the customer the receipt and the items. The database tables are automatically updated. Spice House database tables: Item, Customer, Sales.
0 Views
View Answer
Match the database table to the appropriate transaction cycle. A) Banking Cycle B) Payroll Cycle C) Financial Cycle D) Sales Cycle E) Purchasing Cycle 11) General Ledger 12) Account Transactions 13) Time Worked 14) Employee 15) Purchase Order 16) Cash Receipts 17) Customer 18) Database ________ store pieces of information about people, events, and objects. 19) Database ________ are used to search the database.
0 Views
View Answer
Objective 1 1) In a gap analysis, the gap between the baseline modules and the customization required to meet enterprise-specific needs is analyzed. 2) When using the big bang approach, timing of the implementation can play a crucial role in its success. 3) Troubleshooting a complex system is easier to accomplish when entering.
10 Views
View Answer
26) Create an Event-Agent-Database table for the Books Ga'Lore! Shipping Process Narrative. 27) Create a level-1 data flow diagram for the Books Ga'Lore! Shipping Process Narrative. 28) Create an Event-Agent-Database table for the Books Ga'Lore! Invoice Narrative. 29) Create a level-1 data flow diagram for the Books Ga'Lore! Invoice Order Narrative. .
0 Views
View Answer
Objective 1 1) Best practices for business processes are often not built into baseline accounting systems. 2) Some of the benefits of using an off-the-shelf accounting system are lower cost, tighter security, and scalability. 3) When adapting an organization's business practices to meet a baseline system's process requires extensive changes, ________ may be.
2 Views
View Answer
11) What does the accounting interface connect the user to? A) Database management system B) Database query C) Database D) Database reports 12) 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.
0 Views
View Answer