Problem-solving Cases in Microsoft Access and Excel
Problem-Solving Cases in Microsoft Access and Excel helps build spreadsheets and database skills using realistic business cases and is the perfect complement to a computer literacy or MIS course. Each case introduces a compelling business problem and, with the help of tutorials on Microsoft Access and Excel, trains users in critical thinking and problem solving. Readers will use Microsoft Access and Excel throughout the book to work through the case material. The scenarios found in the text reflect real business situations, ranging from small, privately-owned companies to large corporations.
What people are saying - Write a review
We haven't found any reviews in the usual places.
TUTORIAL A Database Design
TUTORIAL B Microsoft Access
The Cafeteria Paper Products Business
6 other sections not shown
Other editions - View all
Problem Solving Cases in Microsoft Access and Excel
Ellen Monk,Spring Davidson,Joseph Brady
Limited preview - 2009
Access Answer Report Aphrodite Assignment Assume basketballs BEGINNING-OF-THE-YEAR CASH button calculated field CALCULATIONS section CASH FLOW STATEMENT CASH ON HAND cell addresses changing cells chart Club compound key compute CONSTANTS section constraints costs course customers DEBT OWED Decision Support Delete Design View diskette employees END-OF-THE-YEAR CASH enter entity example Excel field name follows the figure footballs foreign key Genre2 header INCOME AFTER TAXES INCOME BEFORE TAXES INCOME STATEMENT INCOME TAX EXPENSE instructor inventory turnover key field KEY RESULTS line items follows marketing Mega memorandum Microsoft Access minimum cash NanoHexamics NUMBER OF UNITS P/E ratio primary key production query output REVENUE Scenario Manager Section Your spreadsheet selling price shoes shown in Figure software maintenance STATEMENT AND CASH SUMMARY OF KEY TAX RATE ticket tutorial UNITS SOLD visual aids Wage Data Wage Rate Salaried zero