ACC 401 Unit 3

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/38

encourage image

There's no tags or description

Looks like no tags are added yet.

39 Terms

1
New cards

Entity

something about which an organization wants to collect and store information

2
New cards

Attribures

Identifying properties of an entity stored in a database

3
New cards

Field

box or space where information is held

4
New cards

Record

Rows of fields associated with an entity describing its attributes

5
New cards

Master file

Permanent file of records that stores cumulative data about an organization. Updated by transaction files


6
New cards

Transaction file

file containing individual business transactions during a fiscal period

7
New cards

Batch Processing

cheaper and more efficient way to process accumulating transactions by processing them in intervals.

8
New cards

Real-time processing

Updating each transaction as they occur

9
New cards

Context Diagram

High level view of a DFD

10
New cards

Level 0 DFD

Level of a DFD that has no significant steps past 1.0, 2.0, 3.0, etc…

11
New cards

Application Programming Interfaces

Structured interface that allows one system to interact with another system offering a data service to other systems.

12
New cards

Input Controls

Controls that control the data entered into a system to confirm their validity

  • Forms design

  • Cancellation and storage of documents

  • Authorization and segregation of duties controls

  • visual scanning

  • data entry controls


13
New cards

Forms Design

Good forms design minimizes room for error or omissions through sequentially prenumbered documents and the use of turnaround documents.

14
New cards

Cancellation and Storage of Source Documents

Documents entered into the system should be canceled to avoid duplicates and inadvertent (or intentional) fraud. Digital documents already processed should be flagged as canceled

15
New cards

Data entry Controls

Types of input controls that prevent improper and wrong information form being put into a system

  • Field check

  • Sign check

  • limit check

  • range check

  • size check

  • completeness check

  • validity check

  • reasonableness check


16
New cards

Field Check

verifies that the characters entered into a field are the proper type. dollar value —> numbers only

17
New cards

Sign check

Makes sure a number has a correct arithmetic sign. Dollars should not be negative if we are making a sale.

18
New cards

Limit check

creates a limit on how high a number can be entered into a field

19
New cards

Range check

Creates a ceiling and floor limit of a numerical value allowed in a field

20
New cards

Size Check

Ensures that the data value fits into the assigned field for visibility

21
New cards

Completeness Check

makes sure that the required data items are entered

22
New cards

Validity Check

makes sure that data entered matches similar data in a masterfile like the ID number. Compares entered data with masterfile data.

  • Enter item number 65324 to see if it even exists.


23
New cards

Reasonableness test

Checks the relationship between two data items for logical relationships.

  • If you haven’t worked past 40 hours there should be no overtime hours logged.


24
New cards

Check Digit

A digit in an ID code that is assigned to items, customers, or profiles of information and appended to the end of that code.

25
New cards

Check digit verification

Recalculation of a check digit to identify data entry errors.

26
New cards

Sequence check

An edit check that determines if a transaction file is in proper numerical or alphabetical order.

27
New cards

Batch Totals

Sum of numerical items to verify completeness of a batch

28
New cards

Financial total

Sums of fields containing monetary values to verify completeness of records

29
New cards

Hash totals

sums of nonfinancial fields that have no other purpose or meaning that to check for completeness.

30
New cards

Record Count

type of batch total that equals the number of records processed at a time

31
New cards

Prompting

online data entry completeness check that requests each required item of input data and then waits for an acceptable response before requesting the next required item.

32
New cards

Closed-loop verification

Checks accuracy of data by displaying drop down menus of related information.

33
New cards

Header Record

A label located at the beginning of each file that contains the file name, expiration date, and other identification data.

34
New cards

Trailer record

Label located at the end of a file that contains batch totals calculated during input. Used to verify accuracy after the system reads the input

35
New cards

Transposition Error

An error in inputting information where two adjacent digits were inadvertently reversed. From 46 to 64

  • (if a financial or hash total discrepancy is evenly divisibly by 9)


36
New cards

Cross Footing balance test

Processing control that verifies accuracy by comparing two alternative ways of calculating the same total.

37
New cards

Zero Balance Test

Verifies the balance of control account equals zero after all entries to it have been made

38
New cards

Concurrent update controls

Prevents the errors that occur when two people try to update data at the same time

39
New cards

Checksums

data transmission control that uses a hash of a file to verify accuracy