MIS Cases: Solving Small Business Scenarios Using Application Software
暫譯: MIS 案例：使用應用軟體解決小型企業情境
Cynthia Gardner, Eugene Rathswohl
- 出版商: Wiley
- 出版日期: 2007-04-20
- 定價: $930
- 售價: 2.1 折 $199
- 語言: 英文
- 頁數: 144
- 裝訂: Paperback
- ISBN: 0470101229
- ISBN-13: 9780470101223
-
相關分類:
Apple Developer
立即出貨 (庫存 < 4)
商品描述
Description
Packed with practical assignments with business solving scenarios, this problem-solving book will help readers grasp the skills needed for Microsoft Excel, Access, and simple Web design. Each chapter presents three cases that arm them with the tools to work through situations on their own. The running case presents interesting scenarios within everyday life situations to make the material more engaging. As they progress through each case, they'll gain a new skill set.
Table of Contents
Chapter 1. Access--Tables and Forms.Skill Set:
Table Design.
Field properties.
Lookup wizard.
Validation rule.
Validation Text.
Input mask.
Form Design.
Command buttons.
Calculated fields.
Images and labels.
Tab order.
Field properties.
Case 1. Up the Hill Bakery.
Case 2. Dr. Garrett's Chiropractic Office.
Case 3. HomeTown Realty.
Chapter 2. Access Queries and Reports.
Skill Set:
Queries.
Insert Criteria.
Calculated fields.
Sorting.
Show option.
Reports.
Format reports.
Sorting.
Header/Footer.
Insert Date Function.
Labels.
Case 4. Up the Hill Bakery.
Case 5. EarthFoods Grocery Store.
Case 6. Destination Corporate Event Planning Inc.
Chapter 3. Access- Advanced Queries & Reports, Switchboard.
Skill Set:
Create One-to-Many Relationship.
Make Table Query.
Parameter Queries.
Delete Table Query.
Grouping Queries.
Create a Switchboard.
Case 7. Up the Hill Bakery.
Case 8. Sun and Beach Clothing.
Case 9. Just Breathe.
Developing Applications for Excel.
Chapter 4. Excel Beginning Level.
Skill Set:
Format Spreadsheet.
Absolute Reference.
Order of Operation Calculations.
Vlookup Table.
Sum, Maximum, Minimum function.
AutoFilter.
Date function.
Center Merge.
Goal Seek.
Subtotals.
Case 10. Up the Hill Bakery.
Case 11. Celebrations for Charity.
Case 12. Dr. William Gardner's DentalOffice.
Chapter 5. Excel Intermediate Level
Skill Set:
If function.
3-Dimensional Workbook.
Average Function.
Chart Wizard.
Freeze Panes.
Rename & Format Worksheets.
Case 13. Up the Hill Bakery.
Case 14. JB Bike Rental.
Case 15. Torero Tennis Team.
Chapter 6. Excel Advanced Level.
Skill Set:
PMT Function.
Data Table.
Data Validation.
Formula Audit.
Solver.
Case 16. Up the Hill Bakery.
Case 17. Maxine’s Travel Agency.
Case 18. Thomas Paul Investment Inc.
Developing Applications for WebSite Design.
Chapter 7. WebSite Design.
Skill Set:
Relative Links.
Absolute Links.
Table with borders.
Page Formats.
Page Titles.
Insert Image.
Folder Hierarchy.
Design Concepts.
Case 19. Up the Hill Bakery.
Case 20. Bella Spa.
Case 21. Legends.
商品描述(中文翻譯)
描述
這本解決問題的書籍充滿了實用的作業和商業解決情境，將幫助讀者掌握使用 Microsoft Excel、Access 及簡單網頁設計所需的技能。每一章節都提供三個案例，讓讀者能夠獨立解決問題。持續的案例呈現日常生活中的有趣情境，使材料更具吸引力。隨著他們逐步完成每個案例，他們將獲得新的技能組合。
目錄
第 1 章. Access--表格與表單。技能組合：
表格設計。
欄位屬性。
查詢精靈。
驗證規則。
驗證文字。
輸入遮罩。
表單設計。
命令按鈕。
計算欄位。
圖片與標籤。
標籤順序。
欄位屬性。
案例 1. 上坡烘焙坊。
案例 2. 加勒特醫生的脊椎診所。
案例 3. 家鄉房地產。
第 2 章. Access 查詢與報告。
技能組合：
查詢。
插入條件。
計算欄位。
排序。
顯示選項。
報告。
格式化報告。
排序。
頁眉/頁腳。
插入日期函數。
標籤。
案例 4. 上坡烘焙坊。
案例 5. 地球食品雜貨店。
案例 6. 目的地企業活動策劃公司.
第 3 章. Access- 進階查詢與報告、切換面板。
技能組合：
建立一對多關係。
製作表格查詢。
參數查詢。
刪除表格查詢。
分組查詢。
建立切換面板。
案例 7. 上坡烘焙坊。
案例 8. 陽光與海灘服飾。
案例 9. 只要呼吸。
為 Excel 開發應用程式。
第 4 章. Excel 初級。
技能組合：
格式化試算表。
絕對參考。
