Robert T. Grauer,
Michelle Hulett,
Cynthia Krebs,
Maurie Lockley,
Judy Scheeren
e.a.
Exploring Microsoft Office 2007 Volume 2
Paperback Engels 2007 1e druk 9780136130376Niet leverbaar.
Samenvatting
The content associated with the traditional text has moved to Pearson Custom Library (PCL). PCL allows customers to create customized textbooks, giving students a more engaging and affordable education. If you would like to purchase the full test without customization, please use ISBN: 0558727883. For more information about customization opportunities, refer to www.pearsoncustomlibrary.com.
Specificaties
ISBN13:9780136130376
Taal:Engels
Bindwijze:Paperback
Aantal pagina's:1296
Uitgever:Pearson Education
Druk:1
Lezersrecensies
Wees de eerste die een lezersrecensie schrijft!
Inhoudsopgave
Exploring Microsoft Office Word 2007 Comprehensive
Chapter 5 - Advanced Features: Wizards, Templates, and Mail Merge
Section 1 Automated Features
Using shortcuts
Hands-On Exercise #1: Using a Wizard
Section 2 Mail Merge
Creating Form Letters
Hands-On Exercise #2: Using the Mail Merge Wizard
Section 3 Merge with External Source Data
Merging with Excel and Access Data
Hands-On Exercise #3: Merge with External Source Data
Summary
Key Terms
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 6 - Desktop Publishing: Creating a Newsletter and Other Documents
Section 1 Introduction to Desktop Publishing
The Newsletter
Columns
Hands-On Exercise #1: Newspaper columns
Section 2 Elements of Graphic Design
The Grid
The Drawing Toolbar
Hands-On Exercise #2: Complete the Newsletter
Section 3 Object Linking and Embedding
Inserting Objects from other Applications
Hands-On Exercise #3: Object Linking and Embeddings
Summary
Key Terms
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 7 - The Expert User: Forms, Document Protection, and Macros
Section 1 Forms
Creating an Electronic form
Hands-On Exercise #1: Forms
Section 2 Protection and Authentication
Adding Security
Create an Electronic Stamp of Authenticity
Hands-On Exercise #2: Secure a document and add a digital signature
Section 3 Automating Word
Introduction to Macros
Hands-On Exercise #3: Introduction to Macros
Summary
Key Terms
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 8 - Introduction to xHTML: Creating a Home Page and a Web Site
Section 1 Online Resources
Microsoft Word and the Internet
Hands-On Exercise #1: Microsoft Word and the World Wide Web
Section 2 Creating a Home Page
Using Word to Create a Web Page
Developing a Web Site
Hands-On Exercise #2: World Wide Travel Home Page
Section 3 Introduction to XML
Extensible Markup Language
Hands-On Exercise #3 Introduction to XML
Summary
Key Terms
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Exploring Microsoft Office Excel 2007 Comprehensive
Chapter 5 - Convert Data to Information
Section 1 Table Management
Exploring Table and Data Theory
Working with a Table Form
Importing Text
Hands-on Exercise 1: Import Data and Maintain a List
Section 2 Data Management
Defining Data and Information
Hands-on Exercise 2: Data Versus Information
Section 3 Data Analysis
Exploring Pivot Tables and Pivot Charts
Hands-on Exercise 3: Pivot Tables and Pivot Charts
Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 6 - Consolidate Data and Link Files
Section 1 Data Consolidation
Consolidating Data from multiple Worksheets
Defining the Three-Dimensional Workbook
Hands-on Exercise 1: Copy Worksheets
Section 2 Worksheet 3-D References
Working with 3-D Refernces
Hands-on Exercise 2: Worksheet References
Section 3 Workbook Linking and Documentation
Linking Workbooks
Creating the Cover Sheet
Hands-on Exercise 3: Linking and Documentation
Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 7 - What-IF Analysis--Forecasting and Amortization
Section 1 Financial Analysis
Defining Forecasting
Using Scenario Manager
Solving Problems with Goal Seek
Hands-on Exercise 1: The Financial Forecast
Section 2 Functions for Amortization Table
Working with Functions
Using Name Manager
Hands-on Exercise 2: The Amortization Schedule
Section 3 Workgroups and Auditing
Validating Data
Auditing Formulas
Setting up a Watch Window
Hands-on Exercise 3: Auditing
Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 8 - Templates, Themes, and Web Pages
Section 1 Worksheet Automation
Working with Existing Templates, Themes, and Styles
Creating a Template
Using Styles for Advanced Formatting
Hands-on Exercise 1: Creating a Template
Section 2 Web Pages
Creating a Web page
Hands-on Exercise 2: Creating a Web Page
Section 3 Web Queries and Web Data
Creating Web Queries
Hands-on Exercise 3: Web Queries
Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 9 - Collaboration and Macros
Section 1 Excel Collaboration
Sharing Data
Copying to Word
Copying to Power Point
Hands-on Exercise 1:
Section 2 Repetitive Tasks
Working with Macros
Hands-on Exercise 2:
Summary
Key Terms
Practice Exercises
Mid-Level Exercises
Capstone Project
Mini Cases
Chapter 10 - Data Analysis--A Capstone Chapter
Section 1 Drowning in Data
The Admissions Office
Hands-on Exercise 1: Case Relevant Scenario
Section 2 The Case Worksheet
Hands-on Exercise 2: Case Relevant Scenario
Section 3 The Case Worksheet
Hands-on Exercise 3: Case Relevant Scenario
Section 4 The Case Worksheet
Hands-on Exercise 4: Case Relevant Scenario
Exploring Microsoft Access 2007 Comprehensive
Chapter 5 — Sub-reports, More Query Types, Pivot Tables and Charts
Section 1 Pivot Tables
Creating Pivot Tables
Hands-on Exercise 1: Pivot Tables
Section 2 Pivot Charts
Recognizing Good Chart Design
Creating Pivot Charts
Editing Pivot Charts
Hands-on Exercise 2: Pivot Charts
Section 3 Interactive Pivots
Creating Multiple Pivots
Hands-on Exercise 3: Interactive Pivots
Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 6 — Data Protection — Working with Data Integrity
Section 1 Protecting Table Data
Creating a table validation rule
Hands-on Exercise 1: Data Validation
Section 2 Understanding the need for forms
Planning the form
Selecting and modifying Controls
Hands-on Exercise 2: Form Creation
Section 3 - Advanced Forms
Creating a calculated control in a form
Adding a sub form
Hands-on Exercise 3: Advanced Forms
Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 7 — Database Maintenance — Creating Advanced Queries
Section 1 Maintenance Query Types
Creating a Make Table Query
Creating an Append Query
Creating a Delete Query
Creating an Update Query
Hands-on Exercise 1: Creating Maintenance Queries
Section 2 Advanced Queries
Crosstab Queries
Using Table Field Indexes
Hands-On Exercise 2: Cross tabbing and Indexing
Section 3 Housekeeping
Setting the database to compact automatically
Converting a database to previous Access versions
Hands-on Exercise 3: Maintenance
Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 8 — Integrating Access with the Internet
Section 1 Access and the Web
Creating a Hyperlinked Field
Inserting Hyperlinks to a File or Web Page
Linking to an E-mail Address
Hands-on Exercise 1: Getting Connected
Section 2 Access and the Web
Exporting database objects as an HTML document
Importing or Linking to an HTML File
Viewing a Data Access Page
Hands-on Exercise 2:
Section 3 Access and Excel
Creating Data for Excel Users
Hands-on Exercise 3:
Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 9 — Bulletproofing the Database
Section 1 Data Protection
Analyzing Database performance
Managing and Securing the Data
Using Performance Analyzer
Using the Linked Table Manager
Creating a database Replica
Synchronizing the design and replica
Hands-on Exercise 1: Performance Measurements
Section 2 Helping Database Users
Creating a user interface
Creating a switchboard
Creating a dialog box
Adding command buttons
Viewing and testing a switchboard
Hands-on Exercise 2: Switchboards and Commands
Section 3 Splits and Security
Splitting a database
Encrypting the data
Establishing User-level security
Testing security levels
Normalizing a Database
Hands-on Exercise 3: Split Database and User Securities
Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 10 - Customizing a database with programming languages
Section 1
Using SQL
Viewing SQU statements in a query
Modifying a SQL statement
Section 2
Using VBA
Introducing Events
Working with procedures
Creating Modules
Displaying an Event Procedure
Testing a procedure in an intermediate window
Creating Class modules
Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Exploring Microsoft Office PowerPoint 2007 Comprehensive
Chapter 5 — Working with Charts and Graphs
Text-based Charts
Basic Statistical Charts and Graphs
Advanced Statistical Charts and Graphs
Hands-on Exercises 1-4
Capstone Exercise
Mini-Cases 1-3
(Content Application, Disaster Recovery, Research)
Chapter 6 — Customizing a Slideshow
Masters
Color Schemes
Custom Template
Custom Animation
Create a Custom Show
Hidden Slides
Macros
Hands-on Exercises 1-4
Capstone Exercise
Mini-Cases 1-3
(Content Application, Disaster Recovery, Research)
Chapter 7 — Saving a Web Page and Adding Interactivity
Hyperlinks
Buttons
Web Pages
Hands-on Exercises 1-4
Capstone Exercise
Mini-Cases 1-3
(Content Application, Disaster Recovery, Research)
Chapter 8 — Collaborating with Others
Comments
Merge and Compare
Package for CD
Broadcast
Hands-on Exercises 1-4
Capstone Exercise
Mini-Cases 1-3
(Content Application, Disaster Recovery, Research)
Chapter 5 - Advanced Features: Wizards, Templates, and Mail Merge
Section 1 Automated Features
Using shortcuts
Hands-On Exercise #1: Using a Wizard
Section 2 Mail Merge
Creating Form Letters
Hands-On Exercise #2: Using the Mail Merge Wizard
Section 3 Merge with External Source Data
Merging with Excel and Access Data
Hands-On Exercise #3: Merge with External Source Data
Summary
Key Terms
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 6 - Desktop Publishing: Creating a Newsletter and Other Documents
Section 1 Introduction to Desktop Publishing
The Newsletter
Columns
Hands-On Exercise #1: Newspaper columns
Section 2 Elements of Graphic Design
The Grid
The Drawing Toolbar
Hands-On Exercise #2: Complete the Newsletter
Section 3 Object Linking and Embedding
Inserting Objects from other Applications
Hands-On Exercise #3: Object Linking and Embeddings
Summary
Key Terms
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 7 - The Expert User: Forms, Document Protection, and Macros
Section 1 Forms
Creating an Electronic form
Hands-On Exercise #1: Forms
Section 2 Protection and Authentication
Adding Security
Create an Electronic Stamp of Authenticity
Hands-On Exercise #2: Secure a document and add a digital signature
Section 3 Automating Word
Introduction to Macros
Hands-On Exercise #3: Introduction to Macros
Summary
Key Terms
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 8 - Introduction to xHTML: Creating a Home Page and a Web Site
Section 1 Online Resources
Microsoft Word and the Internet
Hands-On Exercise #1: Microsoft Word and the World Wide Web
Section 2 Creating a Home Page
Using Word to Create a Web Page
Developing a Web Site
Hands-On Exercise #2: World Wide Travel Home Page
Section 3 Introduction to XML
Extensible Markup Language
Hands-On Exercise #3 Introduction to XML
Summary
Key Terms
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Exploring Microsoft Office Excel 2007 Comprehensive
Chapter 5 - Convert Data to Information
Section 1 Table Management
Exploring Table and Data Theory
Working with a Table Form
Importing Text
Hands-on Exercise 1: Import Data and Maintain a List
Section 2 Data Management
Defining Data and Information
Hands-on Exercise 2: Data Versus Information
Section 3 Data Analysis
Exploring Pivot Tables and Pivot Charts
Hands-on Exercise 3: Pivot Tables and Pivot Charts
Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 6 - Consolidate Data and Link Files
Section 1 Data Consolidation
Consolidating Data from multiple Worksheets
Defining the Three-Dimensional Workbook
Hands-on Exercise 1: Copy Worksheets
Section 2 Worksheet 3-D References
Working with 3-D Refernces
Hands-on Exercise 2: Worksheet References
Section 3 Workbook Linking and Documentation
Linking Workbooks
Creating the Cover Sheet
Hands-on Exercise 3: Linking and Documentation
Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 7 - What-IF Analysis--Forecasting and Amortization
Section 1 Financial Analysis
Defining Forecasting
Using Scenario Manager
Solving Problems with Goal Seek
Hands-on Exercise 1: The Financial Forecast
Section 2 Functions for Amortization Table
Working with Functions
Using Name Manager
Hands-on Exercise 2: The Amortization Schedule
Section 3 Workgroups and Auditing
Validating Data
Auditing Formulas
Setting up a Watch Window
Hands-on Exercise 3: Auditing
Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 8 - Templates, Themes, and Web Pages
Section 1 Worksheet Automation
Working with Existing Templates, Themes, and Styles
Creating a Template
Using Styles for Advanced Formatting
Hands-on Exercise 1: Creating a Template
Section 2 Web Pages
Creating a Web page
Hands-on Exercise 2: Creating a Web Page
Section 3 Web Queries and Web Data
Creating Web Queries
Hands-on Exercise 3: Web Queries
Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 9 - Collaboration and Macros
Section 1 Excel Collaboration
Sharing Data
Copying to Word
Copying to Power Point
Hands-on Exercise 1:
Section 2 Repetitive Tasks
Working with Macros
Hands-on Exercise 2:
Summary
Key Terms
Practice Exercises
Mid-Level Exercises
Capstone Project
Mini Cases
Chapter 10 - Data Analysis--A Capstone Chapter
Section 1 Drowning in Data
The Admissions Office
Hands-on Exercise 1: Case Relevant Scenario
Section 2 The Case Worksheet
Hands-on Exercise 2: Case Relevant Scenario
Section 3 The Case Worksheet
Hands-on Exercise 3: Case Relevant Scenario
Section 4 The Case Worksheet
Hands-on Exercise 4: Case Relevant Scenario
Exploring Microsoft Access 2007 Comprehensive
Chapter 5 — Sub-reports, More Query Types, Pivot Tables and Charts
Section 1 Pivot Tables
Creating Pivot Tables
Hands-on Exercise 1: Pivot Tables
Section 2 Pivot Charts
Recognizing Good Chart Design
Creating Pivot Charts
Editing Pivot Charts
Hands-on Exercise 2: Pivot Charts
Section 3 Interactive Pivots
Creating Multiple Pivots
Hands-on Exercise 3: Interactive Pivots
Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 6 — Data Protection — Working with Data Integrity
Section 1 Protecting Table Data
Creating a table validation rule
Hands-on Exercise 1: Data Validation
Section 2 Understanding the need for forms
Planning the form
Selecting and modifying Controls
Hands-on Exercise 2: Form Creation
Section 3 - Advanced Forms
Creating a calculated control in a form
Adding a sub form
Hands-on Exercise 3: Advanced Forms
Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 7 — Database Maintenance — Creating Advanced Queries
Section 1 Maintenance Query Types
Creating a Make Table Query
Creating an Append Query
Creating a Delete Query
Creating an Update Query
Hands-on Exercise 1: Creating Maintenance Queries
Section 2 Advanced Queries
Crosstab Queries
Using Table Field Indexes
Hands-On Exercise 2: Cross tabbing and Indexing
Section 3 Housekeeping
Setting the database to compact automatically
Converting a database to previous Access versions
Hands-on Exercise 3: Maintenance
Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 8 — Integrating Access with the Internet
Section 1 Access and the Web
Creating a Hyperlinked Field
Inserting Hyperlinks to a File or Web Page
Linking to an E-mail Address
Hands-on Exercise 1: Getting Connected
Section 2 Access and the Web
Exporting database objects as an HTML document
Importing or Linking to an HTML File
Viewing a Data Access Page
Hands-on Exercise 2:
Section 3 Access and Excel
Creating Data for Excel Users
Hands-on Exercise 3:
Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 9 — Bulletproofing the Database
Section 1 Data Protection
Analyzing Database performance
Managing and Securing the Data
Using Performance Analyzer
Using the Linked Table Manager
Creating a database Replica
Synchronizing the design and replica
Hands-on Exercise 1: Performance Measurements
Section 2 Helping Database Users
Creating a user interface
Creating a switchboard
Creating a dialog box
Adding command buttons
Viewing and testing a switchboard
Hands-on Exercise 2: Switchboards and Commands
Section 3 Splits and Security
Splitting a database
Encrypting the data
Establishing User-level security
Testing security levels
Normalizing a Database
Hands-on Exercise 3: Split Database and User Securities
Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Chapter 10 - Customizing a database with programming languages
Section 1
Using SQL
Viewing SQU statements in a query
Modifying a SQL statement
Section 2
Using VBA
Introducing Events
Working with procedures
Creating Modules
Displaying an Event Procedure
Testing a procedure in an intermediate window
Creating Class modules
Summary
Key Terms
Multiple Choice
Practice Exercises
Mid-Level Exercises
Capstone Exercise
Mini Cases
Exploring Microsoft Office PowerPoint 2007 Comprehensive
Chapter 5 — Working with Charts and Graphs
Text-based Charts
Basic Statistical Charts and Graphs
Advanced Statistical Charts and Graphs
Hands-on Exercises 1-4
Capstone Exercise
Mini-Cases 1-3
(Content Application, Disaster Recovery, Research)
Chapter 6 — Customizing a Slideshow
Masters
Color Schemes
Custom Template
Custom Animation
Create a Custom Show
Hidden Slides
Macros
Hands-on Exercises 1-4
Capstone Exercise
Mini-Cases 1-3
(Content Application, Disaster Recovery, Research)
Chapter 7 — Saving a Web Page and Adding Interactivity
Hyperlinks
Buttons
Web Pages
Hands-on Exercises 1-4
Capstone Exercise
Mini-Cases 1-3
(Content Application, Disaster Recovery, Research)
Chapter 8 — Collaborating with Others
Comments
Merge and Compare
Package for CD
Broadcast
Hands-on Exercises 1-4
Capstone Exercise
Mini-Cases 1-3
(Content Application, Disaster Recovery, Research)
Rubrieken
- advisering
- algemeen management
- coaching en trainen
- communicatie en media
- economie
- financieel management
- inkoop en logistiek
- internet en social media
- it-management / ict
- juridisch
- leiderschap
- marketing
- mens en maatschappij
- non-profit
- ondernemen
- organisatiekunde
- personal finance
- personeelsmanagement
- persoonlijke effectiviteit
- projectmanagement
- psychologie
- reclame en verkoop
- strategisch management
- verandermanagement
- werk en loopbaan