Term
|
Definition
| Standards that guide behavior toward other people |
|
|
Term
|
Definition
| address the ethical use of computers and internet usage |
|
|
Term
|
Definition
- right to be left alone when you want
- control over personal possessions
- not to be observed without your consent
|
|
|
Term
|
Definition
| assurance that messages and information are available only to those who are authorized to view them |
|
|
Term
| Acceptable Use Policy (AUP) |
|
Definition
| Contract that a user must agree to follow in order to be provided access to a network |
|
|
Term
|
Definition
| General principles to guide the proper use of the Internet |
|
|
Term
|
Definition
| tracking people's activities by such measures as number of keystrokes, error rate, and number of transactions processed |
|
|
Term
| Decision Support System (DSS) |
|
Definition
| models information to support managers during decision-making process |
|
|
Term
|
Definition
| impact that changes in one or more parts of the model have on other parts of the model |
|
|
Term
|
Definition
| Check the impacts of a change in an assumption on the proposed solution |
|
|
Term
|
Definition
| Finds the inputs necessary to achieve a goal such as a desired level of output |
|
|
Term
| Executive Information System |
|
Definition
| Specialized DSS that supports senior level executives within the organization |
|
|
Term
|
Definition
| aggregation of information and features and the complex groupings of interrelated information |
|
|
Term
|
Definition
| Enables users to get details of information |
|
|
Term
|
Definition
| Looks at infomation from different perspectives |
|
|
Term
|
Definition
| Integrates informations from multiple components to present in a unified display |
|
|
Term
|
Definition
| imitate the reasoning precesses |
|
|
Term
|
Definition
| Emulate the way human brain works |
|
|
Term
|
Definition
| Mimics the evolutionary to generate incresingly better solutions to a problem |
|
|
Term
|
Definition
| Knowledge-Based Information System |
|
|
Term
|
Definition
| Divide information set into mutally exclusive groups |
|
|
Term
|
Definition
| Systems depend on cluster analysis to segment customer information and identify behavioral traits |
|
|
Term
|
Definition
| Predictions made on the basis of time-series information |
|
|
Term
|
Definition
| Time-stamped information collected at a particular frequency |
|
|
Term
|
Definition
| materials flow from suppliers to suppliers at all levels |
|
|
Term
|
Definition
| Organization gets the semi-finished materials |
|
|
Term
|
Definition
| Distribution of products to customers |
|
|
Term
|
Definition
| View all areas up and down the supply chain |
|
|
Term
|
Definition
Distorted product demand info passes from one entity to the next throughout the supply chain
1+1+1 = 3 for someone |
|
|
Term
|
Definition
| Generates demand forecasts using statistical tools and forecasting techniques |
|
|
Term
| Supply Chain Planning (SCP) |
|
Definition
| Software using advanced algorithms to improve the flow and effciency of the supply chain |
|
|
Term
|
Definition
| Software automates the different steps and stages of the supply chain |
|
|
Term
|
Definition
| Right-click a worksheet tab and then select All Sheets |
|
|
Term
| To Group Adjacent Worksheets |
|
Definition
| Click the first worksheet tab, press and hold Shift, and then click the last worksheet tab |
|
|
Term
| Nonadjacent Worksheet Tabs |
|
Definition
| Click first worksheet tab, press and hold Ctrl, and then click each additional worksheet tab |
|
|
Term
|
Definition
| Can enter labels, values, dates, and formulas on one worksheet and applies to all grouped worksheets |
|
|
Term
|
Definition
| Insert, widen, cut, copy, etc. will affect all grouped worksheets |
|
|
Term
| Page Layouts and Printing |
|
Definition
| Identical headers, page orientation, print areas to all grouped worksheets |
|
|
Term
|
Definition
Links data from several worksheets
='October'!E3+'December'!E3 |
|
|
Term
|
Definition
=[Cleveland.xlsx]'Qtr3'A1
Link to cell A1 in Qtr3 worksheet in the Cleveland workbook |
|
|
Term
|
Definition
| Enable you to detect and correct erros in formulas by identifying relationships among cells |
|
|
Term
Audit Formulas
1. Syntax Error |
|
Definition
| Violates correct construction of a formula |
|
|
Term
Audit Formulas
2. Logical Error |
|
Definition
| Produces inaccurate results |
|
|
Term
|
Definition
| Cells referenced by a formula in another cell |
|
|
Term
|
Definition
| Contain formulas that refer to other cells |
|
|
Term
|
Definition
| Opens when error is identified |
|
|
Term
|
Definition
Control data that can be entered into a cell
Prevents "wrong" data in a cell |
|
|
Term
ACCESS
Opening a database |
|
Definition
- Browse for a file
- Recent Documents List
|
|
|
Term
|
Definition
Column Naming
Last Name, First Name, etc.
Make up one record |
|
|
Term
|
Definition
| Each set of info regarding one book is considered to be one record |
|
|
Term
|
Definition
Consists of records which contain info about a single entity
1. Employees
2. Orders
3. Products
... |
|
|
Term
ACCESS
Six types of objects |
|
Definition
1. Tables
2. Queries
3. Reports
4. Forms
5. Modules
6. Macros |
|
|
Term
ACCESS
Tables -- Datasheet View |
|
Definition
| Used to add, modify, delete and view records |
|
|
Term
ACCESS
Tables -- Design View |
|
Definition
| Used to create and modify the fields in a table |
|
|
Term
ACCESS
Forms, Queries and Reports |
|
Definition
| All based on data contained in table(s) |
|
|
Term
ACCESS
Compact and Repair |
|
Definition
Fixes issues due to inefficient file storage and growth of a database.
Can reduce file size by 50% |
|
|
Term
|
Definition
Subset of records and can be applied in Datasheet view
1. Filter by Selection
2. Filter by Form |
|
|
Term
|
Definition
| Toggle Filter icon can be used to apply and remove the current filter as many times as desired |
|
|
Term
|
Definition
| Help avoid data entry errors |
|
|
Term
ACCESS
Sarbanes Oxley Act (SOX) |
|
Definition
Protects general public and comapies shareholders against fraudulent practices and accounting errors.
All records must be saved for a period of five years and be made available to the SEC upon request |
|
|
Term
|
Definition
| Safeguarding of data like SS #'s, CC #'s, Medical Records |
|
|
Term
|
Definition
Allows for date to being arithmetic
Order-Shipped Day to see delay |
|
|
Term
ACCESS
Normalization or Multiple Tables |
|
Definition
| Reduces redundancy of information |
|
|
Term
ACCESS
Customer ID - Primary Key |
|
Definition
| one record, only one unique id per customer |
|
|
Term
ACCESS
Customer ID - Regular Field |
|
Definition
| ID may appear many times - place many orders |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Enables you to sort the dataset |
|
|
Term
|
Definition
| Whether or not you see a field in the dataset |
|
|
Term
|
Definition
| Determines the records that will be selected for display |
|
|
