![Page 1: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/1.jpg)
7-1
PowerPoint Presentation by PowerPoint Presentation by Douglas CloudDouglas Cloud
Professor Emeritus of AccountingProfessor Emeritus of AccountingPepperdine UniversityPepperdine University
© Copyright 2007 Thomson South-Western, a part of The Thomson Corporation. Thomson,
the Star Logo, and South-Western are trademarks used herein under license.
Task Force Image Gallery clip art included in this electronic presentation is used with the
permission of NVTech Inc.
Task Force Image Gallery clip art included in this electronic presentation is used with the
permission of NVTech Inc.
77Computerized Computerized Accounting Accounting SystemsSystems
Financial Accounting
Ingram and Albright
6th edition
Information for DecisionsInformation for Decisions
![Page 2: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/2.jpg)
7-2
ObjectivesObjectivesObjectivesObjectives
Once you have completed this chapter, you should
be able to—
Once you have completed this chapter, you should
be able to—
![Page 3: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/3.jpg)
7-3
1. Identify the primary components of a computerized accounting system.
ObjectivesObjectivesObjectivesObjectives
ContinuedContinuedContinuedContinued
2. Describe the components of a computerized accounting system used to process data and produce useful information.
3. Describe how data are processed in various modules of an accounting system.
![Page 4: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/4.jpg)
7-4
4. Explain the use of relational databases to perform accounting functions.
ObjectivesObjectivesObjectivesObjectives
5. Describe how a database system can be used to create a simple accounting system.
![Page 5: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/5.jpg)
7-5
11ObjectiveObjectiveObjectiveObjective
Identify the primary components of a computerized accounting system.
![Page 6: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/6.jpg)
7-6
Components of a Computerized Components of a Computerized Accounting SystemAccounting System
Components of a Computerized Components of a Computerized Accounting SystemAccounting System
Systems that integrate most of the business information functions as a basis for management decisions are referred to as enterprise resource
planning (ERP) systems.
Systems that integrate most of the business information functions as a basis for management decisions are referred to as enterprise resource
planning (ERP) systems.
![Page 7: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/7.jpg)
7-7
Exhibit Exhibit 11Exhibit Exhibit 11 Components of an Accounting Information System
![Page 8: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/8.jpg)
7-8
The sales module receives order data from customers and maintains accounts receivable
information.
Components of a Computerized Components of a Computerized Accounting SystemAccounting System
Components of a Computerized Components of a Computerized Accounting SystemAccounting System
![Page 9: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/9.jpg)
7-9
Exhibit Exhibit 11Exhibit Exhibit 11 Components of an Accounting Information System
![Page 10: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/10.jpg)
7-10
The purchasing and inventory management module provides purchase order data to vendors.
Components of a Computerized Components of a Computerized Accounting SystemAccounting System
Components of a Computerized Components of a Computerized Accounting SystemAccounting System
Vendors are those who supply Vendors are those who supply specific products to a company.specific products to a company.Vendors are those who supply Vendors are those who supply
specific products to a company.specific products to a company.
![Page 11: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/11.jpg)
7-11
The purchasing and inventory management module maintains accounts payable and inventory
information.
Components of a Computerized Components of a Computerized Accounting SystemAccounting System
Components of a Computerized Components of a Computerized Accounting SystemAccounting System
![Page 12: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/12.jpg)
7-12
Exhibit Exhibit 11Exhibit Exhibit 11 Components of an Accounting Information System
![Page 13: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/13.jpg)
7-13
The human resources module maintains data about
employees, including hours worked and wage rates.
It is used for preparing payroll and It is used for preparing payroll and payroll tax information.payroll tax information.
It is used for preparing payroll and It is used for preparing payroll and payroll tax information.payroll tax information.
Components of a Computerized Components of a Computerized Accounting SystemAccounting System
Components of a Computerized Components of a Computerized Accounting SystemAccounting System
![Page 14: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/14.jpg)
7-14
Exhibit Exhibit 11Exhibit Exhibit 11 Components of an Accounting Information System
![Page 15: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/15.jpg)
7-15
The production module tracks the flow of costs through the
manufacturing process.
Components of a Computerized Components of a Computerized Accounting SystemAccounting System
Components of a Computerized Components of a Computerized Accounting SystemAccounting System
![Page 16: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/16.jpg)
7-16
Exhibit Exhibit 11Exhibit Exhibit 11 Components of an Accounting Information System
![Page 17: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/17.jpg)
7-17
The asset management module identifies long-term asset costs, their expected useful lives, and where these assets are located
in the company.
Components of a Computerized Components of a Computerized Accounting SystemAccounting System
Components of a Computerized Components of a Computerized Accounting SystemAccounting System
![Page 18: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/18.jpg)
7-18
Exhibit Exhibit 11Exhibit Exhibit 11 Components of an Accounting Information System
![Page 19: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/19.jpg)
7-19
The financial management module keeps track of debt,
repayment schedules, interest rates, and shareholder
information.
Components of a Computerized Components of a Computerized Accounting SystemAccounting System
Components of a Computerized Components of a Computerized Accounting SystemAccounting System
![Page 20: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/20.jpg)
7-20
Exhibit Exhibit 11Exhibit Exhibit 11 Components of an Accounting Information System
![Page 21: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/21.jpg)
7-21
The general ledger/financial reporting module provides
information for use by external stakeholders, including
shareholders and government regulators.
Components of a Computerized Components of a Computerized Accounting SystemAccounting System
Components of a Computerized Components of a Computerized Accounting SystemAccounting System
![Page 22: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/22.jpg)
7-22
Subsidiary AccountsSubsidiary AccountsSubsidiary AccountsSubsidiary Accounts
Subsidiary accounts include transactions for individual customers, suppliers, or products. Records for all subsidiary accounts of a particular type are maintained in a subsidiary ledger.
Subsidiary accounts include transactions for individual customers, suppliers, or products. Records for all subsidiary accounts of a particular type are maintained in a subsidiary ledger.
![Page 23: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/23.jpg)
7-23
Subsidiary AccountsSubsidiary AccountsSubsidiary AccountsSubsidiary Accounts
A subsidiary accounts receivable ledger would consist of all the individual customers accounts, with data about purchases and payments for each customer.
A subsidiary accounts receivable ledger would consist of all the individual customers accounts, with data about purchases and payments for each customer.
![Page 24: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/24.jpg)
7-24
Control AccountsControl AccountsControl AccountsControl Accounts
Control accounts are summary accounts that maintain totals for all subsidiary
accounts of a particular type.
Control accounts are summary accounts that maintain totals for all subsidiary
accounts of a particular type.
Example: Example: The balance for The balance for Accounts Accounts ReceivableReceivable control account control account is is the sum of the balances of all the sum of the balances of all customer accounts.customer accounts.
Example: Example: The balance for The balance for Accounts Accounts ReceivableReceivable control account control account is is the sum of the balances of all the sum of the balances of all customer accounts.customer accounts.
![Page 25: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/25.jpg)
7-25
Control AccountsControl AccountsControl AccountsControl Accounts
Records for each control account are maintained in a company’s general ledger.
Records for each control account are maintained in a company’s general ledger.
![Page 26: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/26.jpg)
7-26
22Describe the components of a computerized accounting system used to process data and produce useful information.
ObjectiveObjectiveObjectiveObjective
![Page 27: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/27.jpg)
7-27
Exhibit 2Exhibit 2Exhibit 2Exhibit 2 Data Processing in a Computerized Information System
![Page 28: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/28.jpg)
7-28
Using computer networks, such as
the Internet, to make customer sales is referred
to as E-business.
Using computer networks, such as
the Internet, to make customer sales is referred
to as E-business.
Application software includes
the computer program that
permit data to be recorded and processed.
Application software includes
the computer program that
permit data to be recorded and processed.
![Page 29: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/29.jpg)
7-29
A database is a set of computerized files
in which company data are stored in the form that facilitates
retrieval and updating of the data.
A database is a set of computerized files
in which company data are stored in the form that facilitates
retrieval and updating of the data.
A database management system
controls database functions to ensure data are recorded properly and are accessed only by authorized users.
A database management system
controls database functions to ensure data are recorded properly and are accessed only by authorized users.
![Page 30: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/30.jpg)
7-30
Exhibit Exhibit 44Exhibit Exhibit 44 A Computer Network
![Page 31: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/31.jpg)
7-31
A computer network is a set of hardware
devices that are linked so they can
exchange data among themselves using
software.
![Page 32: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/32.jpg)
7-32
33Describe how data are processed in various modules of an accounting system.
ObjectiveObjectiveObjectiveObjective
![Page 33: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/33.jpg)
7-33
CustomerCustomerCustomerCustomer SalesSales
sales order
Sales filesSales files
Customer filesCustomer files
invoice AccountingAccountingGeneral General
Ledger filesLedger files
ShippingShipping
cash
goodsInventory filesInventory files
A Sales Processing ModuleExhibit 5Exhibit 5Exhibit 5Exhibit 5
![Page 34: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/34.jpg)
7-34
Good internal controls requires that the personnel who account
for the cash should not also have physical access to the cash.
Good internal controls requires that the personnel who account
for the cash should not also have physical access to the cash.
The Sales ModuleThe Sales ModuleThe Sales ModuleThe Sales Module
![Page 35: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/35.jpg)
7-35
The Sales ModuleThe Sales ModuleThe Sales ModuleThe Sales Module
Accounts receivable and sales revenue
transactions are recorded at the time goods are
shipped to customers.
Accounts receivable and sales revenue
transactions are recorded at the time goods are
shipped to customers.
Cash and accounts receivable
transactions are recorded when
cash is received.
Cash and accounts receivable
transactions are recorded when
cash is received.
![Page 36: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/36.jpg)
7-36
A Purchasing and Inventory Management Module
Exhibit 6Exhibit 6Exhibit 6Exhibit 6
purchase orderVendorVendorVendorVendor PurchasingPurchasing Vendor filesVendor files
invoice
AccountingAccountingGeneral General
Ledger filesLedger files
ReceivingReceiving
cash
goodsInventory filesInventory files
![Page 37: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/37.jpg)
7-37
The Purchasing and Inventory The Purchasing and Inventory Management ModuleManagement Module
The Purchasing and Inventory The Purchasing and Inventory Management ModuleManagement Module
The interaction of a company and its suppliers is known as supply-chain
management.
The interaction of a company and its suppliers is known as supply-chain
management.
![Page 38: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/38.jpg)
7-38
A Human Resources ModuleExhibit 7Exhibit 7Exhibit 7Exhibit 7
Time workedEmployeeEmployeeEmployeeEmployee ProductionProduction Production filesProduction files
AccountingAccountingGeneral General
Ledger filesLedger files
PersonnelPersonnel
Cash
Employee filesEmployee filesGovernmentsGovernmentsGovernmentsGovernments
Cash and payroll tax information
![Page 39: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/39.jpg)
7-39
The Human Resources ModuleThe Human Resources ModuleThe Human Resources ModuleThe Human Resources Module
The human resource function in a business is responsible for
hiring and training employees.
The human resource function in a business is responsible for
hiring and training employees.
The data needed to account for
employee activities involve
employees’ hours and their wages or
salaries.
The data needed to account for
employee activities involve
employees’ hours and their wages or
salaries.
![Page 40: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/40.jpg)
7-40
A Production ModuleExhibit 8Exhibit 8Exhibit 8Exhibit 8
Orders/ forecastSalesSalesSalesSales ManufacturingManufacturing Inventory filesInventory files
Cost accounting
Cost accounting General General
Ledger filesLedger files
Stores/ warehouseStores/
warehouse Plant Asset filesPlant Asset files
Employee filesEmployee files
![Page 41: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/41.jpg)
7-41
The Production ModuleThe Production ModuleThe Production ModuleThe Production Module
A special accounting function, known as cost accounting, keeps track of the costs of
resources used in the manufacturing process.
A special accounting function, known as cost accounting, keeps track of the costs of
resources used in the manufacturing process.
![Page 42: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/42.jpg)
7-42
44Explain the use of relational databases to perform accounting functions.
ObjectiveObjectiveObjectiveObjective
![Page 43: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/43.jpg)
7-43
Relational DatabaseRelational DatabaseRelational DatabaseRelational Database
A relational database is a set of related files that are linked so that files can be updated and information can be retrieved
from the files efficiently.
A relational database is a set of related files that are linked so that files can be updated and information can be retrieved
from the files efficiently.
![Page 44: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/44.jpg)
7-44
Relational DatabaseRelational DatabaseRelational DatabaseRelational Database
A table is a file that contains data represented
as rows and columns. Each column identifies a particular attribute of the
entity or process described in the table.
A table is a file that contains data represented
as rows and columns. Each column identifies a particular attribute of the
entity or process described in the table.
Each attribute in the table is
referred to as a field.
Each attribute in the table is
referred to as a field.
![Page 45: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/45.jpg)
7-45
Relational DatabaseRelational DatabaseRelational DatabaseRelational Database
Each table contains one or more primary
keys that uniquely identifies the entities or processes recorded
in the rows of the table.
Each table contains one or more primary
keys that uniquely identifies the entities or processes recorded
in the rows of the table.
The primary key is used to connect the tables into
relationships.
The primary key is used to connect the tables into
relationships.
![Page 46: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/46.jpg)
7-46
Relational DatabaseRelational DatabaseRelational DatabaseRelational Database
The primary key in one table connects to the primary key or a foreign key in another table. A foreign key is a field that is a
primary key in a different table.
The primary key in one table connects to the primary key or a foreign key in another table. A foreign key is a field that is a
primary key in a different table.
![Page 47: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/47.jpg)
7-47
55Describe how a database system can be used to create a simple accounting system.
ObjectiveObjectiveObjectiveObjective
![Page 48: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/48.jpg)
7-48
Copying and Opening Copying and Opening the Databasethe Database
Copying and Opening Copying and Opening the Databasethe Database
It is highly recommended that the database be copied to a hard drive before it
is used.
It is highly recommended that the database be copied to a hard drive before it
is used.
![Page 49: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/49.jpg)
7-49
Copying and Opening Copying and Opening the Databasethe Database
Copying and Opening Copying and Opening the Databasethe Database
It is a good idea to make several
copies of the database under
different names.
It is a good idea to make several
copies of the database under
different names.
FavoriteCookies1.mdb, FavoriteCookies1.mdb, FavoriteCookies2.mdb, FavoriteCookies2.mdb,
and so onand so on
FavoriteCookies1.mdb, FavoriteCookies1.mdb, FavoriteCookies2.mdb, FavoriteCookies2.mdb,
and so onand so on
![Page 50: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/50.jpg)
7-50
Database ContentsDatabase ContentsDatabase ContentsDatabase Contents
Tables contain the data stored in the system.
Queries are short programs that permit a user to obtain data from one or more tables.
Forms provide a means for entering or reading data stored in the database.
Reports provide summary information intended primarily to be printed.
ContinuedContinuedContinuedContinued
![Page 51: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/51.jpg)
7-51
Database ContentsDatabase ContentsDatabase ContentsDatabase Contents
Macros are sequences of steps a user performs to complete a particular task.
Pages provide a means of creating web documents for accessing a database.
Modules are computer programs to provide higher level functions in the database.
![Page 52: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/52.jpg)
7-52
Exercise 7-2Exercise 7-2Exercise 7-2Exercise 7-2
Click the button to skip this exercise.
Press “Enter” or left click the mouse for solution.
Complete the following sentence with the appropriate term:
If you experience trouble making the button work, type 62 and press “Enter.”
ContinuedContinuedContinuedContinued
1. A _____________ is a set of computerized files in which company data are stored in a form that facilitates retrieval and updating of the data.
database
![Page 53: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/53.jpg)
7-53
Exercise 7-3Exercise 7-3Exercise 7-3Exercise 7-3
2. A _________________ is a set of related files that are linked so the files can be updated and information can be retrieved from the files efficiently.
relational database
Press “Enter” or left click the mouse for solution.
Complete the following sentence with the appropriate term:
![Page 54: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/54.jpg)
7-54
Exercise 7-3Exercise 7-3Exercise 7-3Exercise 7-3
3. An accounting record of each (control) account and the balance of each such is called the _______________________.general ledger
ContinuedContinuedContinuedContinued
Press “Enter” or left click the mouse for solution.
Complete the following sentence with the appropriate term:
![Page 55: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/55.jpg)
7-55
Exercise 7-3Exercise 7-3Exercise 7-3Exercise 7-3
4. A _______________________________ controls database functions to ensure data are recorded properly and can be accessed only by those authorized to record, update, or retrieve the data.
database management system
ContinuedContinuedContinuedContinued
Complete the following sentence with the appropriate term:
Press “Enter” or left click the mouse for solution.
![Page 56: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/56.jpg)
7-56
Exercise 7-3Exercise 7-3Exercise 7-3Exercise 7-3
5. A computer program that permits data to be recorded and processed is one kind of ____________________.application software
ContinuedContinuedContinuedContinued
Press “Enter” or left click the mouse for solution.
Complete the following sentence with the appropriate term:
![Page 57: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/57.jpg)
7-57
Exercise 7-3Exercise 7-3Exercise 7-3Exercise 7-3
6. Financial data about individual items of importance in a company are recorded in ________________________.subsidiary accounts
ContinuedContinuedContinuedContinued
Press “Enter” or left click the mouse for solution.
Complete the following sentence with the appropriate term:
![Page 58: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/58.jpg)
7-58
Exercise 7-3Exercise 7-3Exercise 7-3Exercise 7-3
7. Summary accounts that maintain totals for all subsidiary accounts of a particular type are called ________________________.control accounts
ContinuedContinuedContinuedContinued
Press “Enter” or left click the mouse for solution.
Complete the following sentence with the appropriate term:
![Page 59: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/59.jpg)
7-59
Exercise 7-3Exercise 7-3Exercise 7-3Exercise 7-3
ContinuedContinuedContinuedContinued
Press “Enter” or left click the mouse for solution.
Complete the following sentence with the appropriate term:
8. Systems that integrate most of the business information functions are referred to as ___________________________________.enterprise resource planning (ERP) system
![Page 60: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/60.jpg)
7-60
Exercise 7-3Exercise 7-3Exercise 7-3Exercise 7-3
9. The interaction of a company and its suppliers is known as ___________ ____________________. supply- chain management
ContinuedContinuedContinuedContinued
Press “Enter” or left click the mouse for solution.
Complete the following sentence with the appropriate term:
![Page 61: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/61.jpg)
7-61
Exercise 7-3Exercise 7-3Exercise 7-3Exercise 7-3
10. The use of computer networks, such as the Internet, to provide for customer sales is referred to as____________.E-business
ContinuedContinuedContinuedContinued
Press “Enter” or left click the mouse for solution.
Complete the following sentence with the appropriate term:
![Page 62: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/62.jpg)
7-62
THE ENDTHE END
CCHAPTERHAPTER 7 7
![Page 63: 7-1 PowerPoint Presentation by Douglas Cloud Professor Emeritus of Accounting Pepperdine University © Copyright 2007 Thomson South-Western, a part of The](https://reader035.vdocuments.us/reader035/viewer/2022062320/56649d4d5503460f94a2b888/html5/thumbnails/63.jpg)
7-63