Overview

Full Product Details

Author:   Cyntha Gardner ,  Eugene J. Rathswohl
Publisher:   John Wiley and Sons Ltd
Imprint:   John Wiley & Sons Ltd
Dimensions:   Width: 19.20cm , Height: 0.60cm , Length: 23.00cm
Weight:   0.236kg
ISBN:  

9780470101223

ISBN 10:   0470101229
Pages:   144
Publication Date:   11 May 2007
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Out of Print
Availability:   In Print  
Limited stock is available. It will be ordered for you and shipped pending supplier's limited stock.

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.

Reviews

Author Information

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions