Week%2012-ACC381 - CollegeofBusiness Information Systems...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
Name College of Business Information Systems Management / Accounting Information Systems Lab - Troubleshooting Workbooks (Chapter 10) Samantha Kleitsch / Lise Urbaczewski
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
“All men make mistakes, but only wise men learn from their mistakes.” - Winston Churchill Property of L. Urbaczewski / S. Kleitsch
Background image of page 2
Planning an Excel Application - Workbook that others can use - Easy-to-use interface - Want them to be error-free - Excel application helps in decision making Property of L. Urbaczewski / S. Kleitsch
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Controlling Data-Entry Errors - Data Validation tools - Ranges of acceptable data - Type of data - Error results in input message / error alert - ALWAYS ask yourself DOES THIS MAKE SENSE! Property of L. Urbaczewski / S. Kleitsch
Background image of page 4
Discuss Figure 10.2 What doesn’t make sense? Property of L. Urbaczewski / S. Kleitsch
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Create a Data Validation Rule We need data validation for unit price Specific values (list) We also need data validation for COGS Between 0 and 1 (decimal) How? See “How to” on page 602 Property of L. Urbaczewski / S. Kleitsch
Background image of page 6
Data validation rules Property of L. Urbaczewski / S. Kleitsch
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Specifying validation rule Property of L. Urbaczewski / S. Kleitsch
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 23

Week%2012-ACC381 - CollegeofBusiness Information Systems...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online