Microsoft Office 2007 In Business Core / Edition 2

Paperback (Print)
Rent
Rent from BN.com
$36.60
(Save 75%)
Est. Return Date: 12/21/2014
Buy Used
Buy Used from BN.com
$97.02
(Save 34%)
Item is in good condition but packaging may have signs of shelf wear/aging or torn packaging.
Condition: Used – Good details
Used and New from Other Sellers
Used and New from Other Sellers
from $22.05
Usually ships in 1-2 business days
(Save 84%)
Other sellers (Paperback)
  • All (14) from $22.05   
  • New (4) from $28.99   
  • Used (10) from $22.04   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$28.99
Seller since 2008

Feedback rating:

(1770)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
New Fast Shipping. Cd Included! Item is Shrink Wrapped!

Ships from: cadiz, KY

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$37.20
Seller since 2014

Feedback rating:

(14)

Condition: New
2008 Spiralbound 2nd ed. With shrink wrapped unopened DVDs. Audience: General/trade. Expedited shipping available.

Ships from: Oxnard, CA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$47.93
Seller since 2007

Feedback rating:

(129)

Condition: New
SPIRAL-BOUND New 0135073200 Brand new book. SEALED STUDENT RESOURCE DVD INCLUDED. Never used. Nice gift. Best buy. Shipped promptly and packaged carefully.

Ships from: Woodinville, WA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$105.00
Seller since 2014

Feedback rating:

(186)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by

Overview

Microsoft Office is the industry standard in business software. Learn how to make Office 2007 work for you! As part of the In Business System, Microsoft Office 2007 In Business Core is the only Office 2007 book that prepares students expressly for core business courses such as Accounting, Economics, Marketing, Finance, and Business Statistics by providing exposure to real business files that meet professional standards, useful references that can be used in later courses, an understanding of how to use the software as a tool to accomplish business goals, and coverage of the core Office skills needed in business. The second edition includes several new features that reinforce the primary mission of the series, which is to illustrate how Microsoft Office is used to accomplish both personal and professional business objectives.

Microsoft Office skills are essential for anyone working in a business environment. Whether you need Word skills for Marketing or Excel skills for Accounting, Microsoft Office 2007 In Business Core ensures that you can meet your business goals.

Read More Show Less

Product Details

  • ISBN-13: 9780135073209
  • Publisher: Prentice Hall
  • Publication date: 1/19/2009
  • Edition description: New Edition
  • Edition number: 2
  • Pages: 1088
  • Product dimensions: 9.50 (w) x 10.90 (h) x 1.60 (d)

Meet the Author

Joseph M. Manzo

In Business series editor and author of Microsoft Office Excel 2007 In Business and Microsoft Office Access 2007 In Business

Joseph began his career in a family-owned business in the garment center of New York City where he managed production plans for knitted textiles sold in the domestic market. Since then, he has worked with several U.S. corporations in the manufacturing, retailing, consulting, and finance industries. He has held positions in Strategic Planning, Information Systems, and Merchandise Planning and Buying. The use of Microsoft Excel and Access was an integral part of managing information and making decisions throughout his career. He developed a high level of expertise in these applications and eventually trained business professionals as a manager in the information systems division of a multibillion dollar retail corporation.

Today, Joseph is a teacher and independent consultant. After practicing business for several years, he moved his career into academia by developing and teaching the Excel competency program at Lehigh University’s prestigious College of Business and Economics. He also teaches the Introduction to Business class for first-year business students at Lehigh. In his consulting practice, Joseph develops strategic plans for new businesses, and develops desktop IT solutions for business performance reporting and analysis. He received an MBA with a concentration in Information Systems Management from Lehigh University and attended Rutgers University for his undergraduate degree.

Dee R. Piziak

Author of Presenting with Microsoft Office PowerPoint 2007 In Business

Dee Piziak is an adjunct faculty member at the University of Wisconsin-Milwaukee and at Concordia University. She teaches various information systems courses at both the undergraduate and graduate level.

Dee holds a B.S. in Computer Information Science from the University of Florida and an M.S. in Computer Science from the University of Wisconsin-Milwaukee.

In addition to teaching, Dee is an Information Technology professional. She has held sales and marketing positions at IBM Corporation, Ameritech, and EMC Corporation. She is currently an Assistant Director for Field Development Systems at Northwestern Mutual in Milwaukee, Wisconsin.

Chris J. Rhoads

Author of Communicating with Microsoft Office Word 2007 In Business

Dr. Rhoads (“CJ”) is President and CEO for ETM Associates, Inc., which specializes in helping companies make better decisions regarding business management and information technology. She is also Associate Professor in the College of Business at Kutztown University, where she shares her knowledge in a variety of graduate and undergraduate courses. CJ is a dynamic speaker and sought-after guru on improving business through information technology. She has been widely published, including several instructional manuals, and is a regular columnist for several business publications.

CJ developed her extensive knowledge through a combination of startups and Fortune 500 companies in the financial industry. Prior to starting ETM Associates, she served as Chief Technology and Operations Officer for CommerceLinks.Net, a startup specializing in Live Video Customer Service technologies. During the height of the Internet bubble, she utilized her talents as Chief Technology Officer of Millstar, an E-commerce software development company specializing in online catalogues of highly complex product sets for click and mortar companies. Her large company experience was garnered as Vice President of First USA and MBNA, where she provided internal consult to senior management on technology decision-making topics.

CJ started her career by building Computer Educational Services, a highly successful computer training and consulting firm that eventually merged into Verso Technologies, a publicly traded company. She has a doctorate in Educational Technology from Lehigh University and a Master’s degree from Temple University.

Read More Show Less

Table of Contents

Table of Contents

Preface

PowerPoint

Chapter 1 I Introduction

PowerPoint in Practice Anecdote I My Role as a Sales Engineer

Business Communication, Influences, and Decision Making I Skill Set

High-Impact Communication and Decision Making

PowerPoint: The Electronic Flip Chart and Transparency

PowerPoint Concepts and Terminology

Plan First, Validate, Then Create

The PowerPoint Tour

Video Workshop I Communication and Decision Making

Why Do I Need This? I Planning a Presentation

What's Wrong with This Presentation?

PowerPoint in Practice Anecdote I Solution

Review Questions

Skills Exam

Challenge Questions

Above and Beyond: Running Skills Exam

Above and Beyond: Challenge Questions

Chapter 2 I Creating a Basic Presentation

Designing Your Presentation I Skill Set

Creating a New Presentation

Slide Themes

Slide Layouts

Video Workshop I Designing Your Presentation

Why Do I Need This? I Designing Your Presentation

What's Wrong with This Presentation?

Building Your Presentation I Skill Set

Adding New Slides and Text

Using the Outline Tab

Bullets and Numbered Lists

Video Workshop I Building Your Presentation

Why Do I Need This? I Building Your Presentation

What's Wrong with This Presentation?

Presenting Qualitative and Quantitative Information and Objects I Skill Set

Shapes and Lines

Tables and Charts

SmartArt

Graphics, Audio, and Video

Video Workshop I Presenting Qualitative and Quantitative Information and Objects

Why Do I Need This? I Presenting Qualitative and Quantitative Information and Objects

Why Do I Need This? I Presenting Qualitative and Quantitative Information

What's Wrong with This Presentation?

PowerPoint in Practice Anecdote I Solution

Review Questions

Skills Exam

Challenege Questions

Above and Beyond: Running Skills Exam

Above and Beyond: Challenge Questions

Chapter 3 I Enhancing Your Presentation

PowerPoint in Practice Anecdote I My Role as a Global Account Manager

Formatting Your Slides I SKill Set

Clipboard Options

Font Group

Paragraph Panel

WordArt

Modifying Slide Masters

Video Workship I Formatting Your Slides

Why Do I Need This? I Formatting a Presentation for a Consulting Firm

What's Wrong with This Presentation?

Sharing Content between Presentations I Skill Set

Slide Sorter View

Deleting and Rearranging Slides

Merging Presentations

Why Do I Need This? I Creating a Single Presentation from a Team of People

What's Wrong with This Presentation?

Checking Your Slides I Skill Set

Review Tab

Find and Replace

Print Preview

Video Workshop I Checking for Accuracy

Why Do I Need This? I Creating a Shell

What's Wrong with This Presentation?

PowerPoint in Practice Anecdote I Solution

Review Questions

Skills Exam

Challenge Questions

Above and Beyond: Running Skills Exam

Above and Beyond: Challenge Questions

Chapter 4I Delivering Your Presentation

PowerPoint in Practice Anecdote I My Role as a Senior Manager

Basic Presentation Options I Skill Set

On-Screen (Electronic) Delivery

Web Delivery

Hard-Copy Presentations

Video Workshop I Basic Presentation Options

Why Do I Need This? I Customizing a Slide Show

What's Wrong with this Presentation?

PowerPoint in Practice Anecdote I Solution

Review Questions

Skills Exam

Challenge Questions

Above and Beyond: Running Skills Exam

Above and Beyond: Challenge Question

Chapter 5 I Applying the Core Skills

PowerPoint in Practice Anecdote I My Role as the "RFP Guru"

Converting Documents into Presentations I Skill Set

Develop a Road Map

Assemble Your Presentation

Reuse Word and Excel Objects

Effective Delivery Techniques

Video Workshop I Converting Documents into Presentations

Why Do I Need This? I Turning the Road Map into a Project Plan

What's Wrong with This Presentation?

PowerPoint in Practice Anecdote I Solution

Review Questions

Skills Exam

Challenge Questions

Above and Beyond: Running Skills Exam

Above and Beyond: Challenge Questions

Word

Chapter 1 I Introduction to Word Basics

Word in Practice Anecdote I My Role as a Technology Consultant

What is Word? I Skill Set

Why Are We Here?

An Overview of Word

Ribbon, Tabs, and Icons

File Menu

Word 97-2007 File Format

Right-Click, Alt Keys, and Control Keys

Word Help

Settings and the Normal Template

Business Writing

Creating, Writing, and Saving a Word Document

Copy and Paste

Save the Document

The Ruler

Video Workshop I Introduction to Word

Why Do I Need This? I An Introduction to Creating an Outline

What's Wrong with This Document?

Word in Practice Anecdote I Solution

Review Questions

Skills Exam

Challenge Questions

Above and Beyond: Running Skills Exam

Above and Beyond: Challenge Questions

Chapter 2 I Creating a Basic Report

Word in Practice Anecdote I My Role as VP at a Fortune 500 Financial Firm

Paragraph and Text Formatting I Skill Set

Introduction to Styles

Using Styles to Change an Outline into Headings

Creating New Styles

About Paragraph Formatting, Fonts, and Font Sizes

Applying New Styles

Design Rules: Serifs, Consistency, and Whitespace

Paragraph Marks and Styles

Modifying a Style

Video Workshop I Paragraph and Text Formatting

Why Do I Need This? I Formatting Letters

What's Wrong with This Document?

Page Formatting I Skill Set

Page Margins

Inserting Page Numbers

Headers and Footers

Inserting Fields into the Footer

Creating a Cover Page

Video Workshop I Headers and Footers

Why Do I Need This? I Creating a Decision Recommendation Report

What’s Wrong with This Document

Word in Practice Anecdote I Solution

Review Questions

Skills Exam

Challenge Questions

Above and Beyond: Running Skills Exam

Above and Beyond: Challenge Questions

Chapter 3 I Word Document

Enhancements

Word in Practice Anecdote I My Role as Enterprise Network Management Consultant

Inserting and Working with Tables I Skill Set

Inserting Tables

Changing Column Widths

Selecting Components of a Table

Inserting or Deleting Rows or Columns

Splitting and Merging Cells

Modifying Borders and Shading on a Table

Repeating Table Headers

Converting Text to Table

Video Workshop I Inserting Tables

Why Do I Need This? I Creating a Consulting Proposal

What’s Wrong with This Document?

The Power of Find and Replace I Skill Set

Finding Text

Replacing Text

More on Find

Finding and Replacing Invisible Codes

Video Workshop I The Power of Find and Replace

Why Do I Need This? I Creating a Comparison Table from a Download

What’s Wrong with This Document

Complex Headers, Footers, and Page Numbers (Sections) I Skill Set

Review Headers, Footers, and Fields

Inserting a Section Break

Understanding Sections and Headers/Footers

Integrating Page Numbers into Header or Footer

Inserting Table of Contents Field

Table of Contents–Updating and Styles

Video Workshop I Complex Headers, Footers, Page Numbering, and Table of Contents

Why Do I Need This? I Formatting Program Description Documents

What’s Wrong with This Document?

Word in Practice Anecdote I Solution

Review Questions

Skills Exam

Challenge Questions

Above and Beyond: Running Skills Exam

Above and Beyond: Challenge Questions

Chapter 4 I Word Sharing Objects and Adding References

Word in Practice Anecdote I My Role as Chief Technology Officer of an E-Commerce Software Developer

Pictures and Graphics I Skill Set

About Graphics

Inserting a Photo

Inserting a Caption

About Picture Size and Placement

Resizing a Graphic

Cropping a Graphic

Compressing Pictures When Saving

Moving a Graphic and Text Wrapping Choices

Moving a Graphic with Cut and Paste

Moving a Graphic with Drag and Drop

Using a Text Box

Video Workshop I Pictures and Graphics

Why Do I Need This? I Consultants Workshop Press Release

What’s Wrong with This Document?

Inserting Slides, Spreadsheets, Charts, and Query Results I Skill Set

Inserting a PowerPoint Slide

Inserting an Excel Chart

Inserting an Excel Spreadsheet

Inserting the Results of an Access Query

Video Workshop I Inserting Slides, Spreadsheets, Charts, and Query Results

Why Do I Need This? I Integrating Information from a Variety of Sources to Persuade

What’s Wrong with This Document?

Footnotes and Endnotes I Skill Set

Adding an Endnote

Adding a Footnote

Converting Endnotes to Footnotes and Vice Versa

Video Workshop I Footnotes and Endnotes

Why Do I Need This? I Making a Case for a Recommendation

What’s Wrong with This Document?

Word in Practice Anecdote I Solution

Review Questions

Skills Exam

Challenge Questions

Above and Beyond: Running Skills Exam

Above and Beyond: Challenge Questions

Excel

Chapter 1 I Introduction

Excel in Practice Anecdote I Excel in Business

What Is Excel? I Skill Set

Why Are We Here?

A Decision-Making Tool

An Overview of Excel

Ribbon, Tabs, and Icons

The File Menu

Excel 97-2003 File Format

Right Click and Control Keys

Settings and Status Bar

Excel Help

Video Workshop I Introduction to Excel

Why Do I Need This? I An Introduction to Cell Referencing

Excel in Practice Anecdote I Solution

Review Questions

Skills Exam

Challenge Questions

Above and Beyond; Running Skills Exam

Above and Beyond: Challenge Questions

Chapter 2 I Excel Basics

Excel in Practice Anecdote I The Role of a Production Planning Manager

Data Management I Skill Set

Data Entry

Auto Fill

Adjusting Columns and Rows

Hiding Columns and Rows

Copy and Paste

Sorting Data (Single Level)

Sorting Data (Multiple Levels)

Video Workshop I Data Management Skills

Why Do I Need This? I Creating Merchandise Sales Reports

What’s Wrong with This Spreadsheet?

Formatting I Skill Set

Data Formats

Data Alignment

Number Formats

Borders (Line Formats)

Cell Color (Fill Color)

Video Workshop I Formatting

Why Do I Need This? I Creating a Store Performance Report

What’s Wrong with This Spreadsheet?

Editing I Skill Set

Editing Data in a Cell

Moving Data

Deleting Columns and Rows

Deleting Worksheets

Inserting Columns and Rows

Inserting, Moving, and Renaming Worksheet Tabs

Video Workshop I Editing

Why Do I Need This? I Editing Store Sales Reports

What’s Wrong with This Spreadsheet?

Printing I Skill Set

Page Setup

Printing a Worksheet

Video Workshop I Printing

Excel in Practice Anecdote I Solution

Review Questions

Skills Exam

Challenge Questions

Above and Beyond: Running Skills Exam

Above and Beyond: Challenge Questions

Chapter 3 I Calculating Data: Formulas and Functions

Excel in Practice Anecdote I My Role as a Merchandise Analyst

Formulas I Skill Set

Basic Formulas

Copying and Pasting Formulas (Relative Reference and Paste Special)

Complex Formulas

Auditing Formulas

Video Workshop I Formulas

Why Do I Need This? I Startup Costs for a New Business

What’s Wrong with This Spreadsheet?

Basic Functions I Skill Set

Basic Statistical Functions

AutoSum

Absolute References (Turning Off Relative References)

Video Workshop I Statistical Functions

Video Workshop I Absolute References

Why Do I Need This? I Evaluating a Transportation Business

What’s Wrong with This Spreadsheet?

Financial Functions I Skill Set

The Future Value Function

The Payment Function

The Function Library

Video Workshop I Future Value Function

Video Workshop I Payment Function

Video Workshop I The Function Library

Why Do I Need This? I Financial Planning for Retirement

What’s Wrong with This Spreadsheet?

Excel in Practice Anecdote I Solution

Review Questions

Skills Exam

Challenge Questions

Above and Beyond: Running Skills Exam

Above and Beyond: Challenge Questions

Chapter 4 I Evaluating Data

Excel in Practice Anecdote I Managing Retail Store Expansion

Logical Functions ( The IF Function ) I Skill Set

IF Function

Nested IF Functions

Video Workshop I IF Functions

Why Do I Need This? I Price Management

What’s Wrong with This Spreadsheet?

Logical Functions (AND OR) I Skill Set

AND Function

OR Function

Combining AND, OR, and IF Functions

Video Workshop I AND and OR Functions

Why Do I Need This? I Managing Product Shipments

What’s Wrong with This Spreadsheet?

Lookup Functions I Skill Set

VLookup Function

HLookup Function

Video Workshop I The VLookup Function

Video Workshop I The HLookup Function

Why Do I Need This? I Personal Investment Strategies

What’s Wrong with This Spreadsheet?

Excel in Practice Anecdote I Solution

Review Questions

Skills Exam

Challenge Questions

Above and Beyond: Running Skills Exam

Above and Beyond: Challenge Questions

Chapter 5 I Presenting Information with Charts

Excel in Practice Anecdote I My Role as a Consultant

Creating Charts I Skill Set

Column Charts (Data Comparisons)

Stacked Column Charts (Percent to Total Over Time)

Line Charts ( Trends Over Time)

Pie Charts (Percent to Total)

Video Workshop I Creating Charts

Why Do I Need This? I Analyzing Industry Statistics

What’s Wrong with This Spreadsheet?

Formatting Charts I Skill Set

Titles and Legends

Plot Area and Data Series

X- and Y-Axes Labels

Adding Annotations and Objects

Video Workshop I Formatting Charts

Why Do I Need This? I Charting Stocks versus the Dow Jones Industrial Average

What’s Wrong with This Spreadsheet?

Advanced Chart Options I Skill Set

Defining the X-and Y-Axes Manually

The Scatter Plot Chart

Pasting Charts into PowerPoint and Word

Video Workshop I Scatter Plot Charts

Video Workshop I Pasting Charts into Word

Why Do I Need This? I Analyzing Supply and Demand

What’s Wrong with This Spreadsheet?

Excel in Practice Anecdote I Solution

Review Questions

Skills Exam

Challenge Questions

Above and Beyond: Running Skills Exam

Above and Beyond: Challenge Questions

Chapter 6 I Applying Core Competency Skills: Financial Planning and Accounting

Excel in Practice Anecdote I My Role as a Strategic Planning Manager

Linking Data I Skill Set

Linking Worksheets and Workbooks

Updating Workbook Links

SUMIF Function

Video Workshop I Linking Data

Video Workshop I SUMIF Function

Why Do I Need This? I Store Construction Plans

What’s Wrong with This Spreadsheet?

Financial Planning I Skill Set

Financial Assumptions

Freeze Panes

Financial Data

Cash Analysis (The NPV Function)

Video Workshop I NPV Function

Video Workshop I Financial Plans

Why Do I Need This? I Evaluating Business Initiatives Using Net Present Value

What’s Wrong with This Spreadsheet?

Financial Accounting I Skill Set

T-Accounts

Journals

Ledgers

Trial Balance and Work Sheets

Statements

Video Workshop I Financial Accounting

Why Do I Need This? I Analyzing Adjusting Entries and Net Income

What’s Wrong with This Spreadsheet?

Excel in Practice Anecdote I Solution

Review Questions

Skills Exam

Challenge Questions

Above and Beyond: Running Skills Exam

Above and Beyond: Challenge Questions

Access

Chapter 1 I Introduction

Access in Practice Anecdote I Access in Business

What is Access? I Skill Set

Databases

Business Decisions and Databases

Navigation Pane and Access Objects

File Formats and Other Access Settings

Access Help

Using versus Creating Databases

Video Workshop I Introduction to Access

Why Do I Need This? I How Companies Use Databases

What’s Wrong with This Database?

Access in Practice Anecdote I Solution

Review Questions

Skills Exam

Challenge Questions

Above and Beyond: Running Skills Exam

Above and Beyond: Challenge Questions

Chapter 2 I The Database Table

Access in Practice Anecdote I Merchandise Planning in the Fashion Industry

Creating Tables I Skill Set

Creating a New Table

Field Names, Data Types, and Field Properties

Indexing and Primary Keys

Entering and Formatting Data

Adjusting and Hiding Columns and Rows

Copying and Pasting Data

Sorting and Filtering Data

Video Workshop I Creating an Access Table

Why Do I Need This? I Collecting Customer Data for Marketing Promotions

What’s Wrong with This Database?

Editing Tables I Skill Set

Changing Data Types and Field Properties

Changing the Sequence of Fields

Editing Data and Field Names

Inserting Fields

Deleting Fields and Records

Video Workshop I Editing a Table

Why Do I Need This? I Managing Transportation Data

What’s Wrong with This Database?

Importing and Linking Data I Skill Set

Importing Data

Linking Data

Printing Tables

Video Workshop I Linking and Importing Tables

What’s Wrong with This Database?

Access in Practice Anecdote I Solution

Review Questions

Skills Exam

Challenge Questions

Above and Beyond: Running Skills Exam

Above and Beyond: Challenge Questions

Chapter 3 I Selecting and Summarizing Data from Tables

Access in Practice Anecdote I Databases in Practice

Know Your Data I Skill Set

Getting Started

Single Field Primary Key Tables

Multiple Field Primary Key Tables

Video Workshop I Evaluating Tables

Why Do I Need This? I Analyzing a Call Center Database

What’s Wrong with This Database?

Fundamental Query Techniques (The Select Query) I Skill Set

Creating a New Query

Adding Fields and Adjusting Columns

Query Name and Properties

Defining Basic Criteria (OR AND)

Formatting and Sorting Data

Editing Queries

Exploring Queries to Excel

Video Workshop I Basic Queries

Why Do I Need This? I Analyzing Transportation Data

What’s Wrong with This Database?

Advanced Queries I Skill Set

Grouping Data

Mathematical Summaries (Aggregate Functions)

Nested Queries

Advanced Queries

Crosstab Queries

Video Workshop I Advanced Queries

Why Do I Need This? I Analyzing Merchandise Sales Trends

What’s Wrong with This Database?

Access in Practice Anecdote I Solution

Review Questions

Skills Exam

Challenge Questions

Above and Beyond: Running Skills Exam

Above and Beyond: Challenge Questions

Chapter 4 I Applying Calculations to Data

Access in Practice Anecdote I My Role as an Information Systems Advisor

Formulas I Skill Set

Custom Fields

Calculated Fields

The Expression Builder

Video Workshop I Formulas

Why Do I Need This? I Stock Analysis

What’s Wrong with This Database?

IIF Function I Skill Set

Basic IIF Function

Nested IIF Function

Video Workshop I IIF Functions

Why Do I Need This? I Developing a Promotion Strategy

What’s Wrong with This Database?

Financial Functions I Skill Set

Future Value

Payment Function

Help with Functions

Video Workshop I Future Value Function

Video Workshop I Payment Function

Why Do I Need This? I Assessing the Value of Real Estate

What’s Wrong with This Database?

Access in Practice Anecdote I Solution

Review Questions

Skills Exam

Challenge Questions

Above and Beyond: Running Skills Exam

Above and Beyond: Challenge Questions

Chapter 5 I Reports

Access in Practice Anecdote I My Role as a Retail Store Analyst

Fundamental Report Techniques I Skill Set

Creating a New Report

Setting the Dimensions of a Report

Report Header

Detail

Page Footer

Report Footer

Video Workshop I Fundamental Report Skills

Why Do I Need This? I Human Resource Status Report

What’s Wrong with This Database?

Advanced Report Techniques I Skill Set

Grouping Data

Sorting Data

Calculated Fields

Conditional Formatting

Group and Report Totals

Lines

Dates

Video Workshop I Advanced Report Skills

Why Do I Need This? I Industry and Company Performance Report

What’s Wrong with This Database?

Access in Practice Anecdote I Solution

Review Questions

Skills Exam

Challenge Questions

Above and Beyond: Running Skills Exam

Above and Beyond: Challenge Questions

Chapter 6 I Applying Core Competency Skills

Access in Practice Anecdote I Managing a Strategic Alliance

Using Multiple Tables in Queries I Skill Set

Joining Tables

Inner Joins

Outer Joins

Defining table Relationships

Video Workshop I Joining Tables

Video Workshop I Table Relationships

Why Do I Need This? I Evaluating Marketing Strategies and Sales

What’s Wrong with This Database?

Comprehensive Access Project I Skill Set

Selecting Tables

Adding and Joining Tables in a Select Query

Creating a Parameter Query

Adding Calculations

Constructing the Final Report

Video Workshop I Comprehensive Project

Why Do I Need This? I Wealth Management Investment Reports

What’s Wrong with This Database?

Access in Practice Anecdote I Solution

Review Questions

Skills Exam

Challenge Questions

Above and Beyond; Running Skills Exam

Above and Beyond: Challenge Questions

Quick Reference Guide

Glossary

Index

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)