Formatting and Enhancing a Document. I have a quick question before we start with troubleshooting. Maintaining Data in Access Tables. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more. Students go to college now with a different set of skills than they did years ago. Let us know if you need further assistance.
Summarizing Data and Calculating in Forms and Reports. Both apps are on the windows screen. . Integrating Programs: Word, Excel, and PowerPoint. Working with Multiple Worksheets, Tables, and Other File Formats. With this in mind, the Exploring series seeks to move students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everyone needs to know.
Understanding Database Fundamentals Using an Existing Database Hands-On Exercise 1: Databases Are Everywhere! I can also see all the pictures on the Pictures app. We're with you every step of the way to make a seamless transition to teaching with Microsoft Office 2013. In case you would like to import multiple images into PowerPoint, you may use the Photo Album feature. Sorts and Filters Sorting Table Data on One or Multiple Fields Creating, Modifying, and Removing Filters Hands-On Exercise 2: Sorts and Filters Access Versus Excel, and Relational Databases Knowing When to Use Access or Excel to Manage Data Understanding Relational Power Hands-On Exercise 3: Access Versus Excel, and Relationship Databases Access Database Creation Creating a Database Hands-On Exercise 4: Access Database Creation Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Chapter Two Tables and Queries in Relational Databases: Designing Databases and Extracting Data Objectives Case Study Bank Audit Table Design, Creation, and Modification Designing a Table Creating and Modifying Tables Hands-On Exercise 1: Table Design, Creation, and Modification Multiple-Table Databases Sharing Data Establishing Table Relationships Hands-On Exercise 2: Multiple-Table Databases Single-Table Queries Creating a Single-Table Query Specifying Query Criteria for Different Data Types Understanding Query Sort Order Running, Copying, and Modifying a Query Using the Query Wizard Hands-On Exercise 3: Single-Table Queries Multitable Queries Creating a Multitable Query Modifying a Multitable Query Hands-On Exercise 4: Multitable Queries Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Chapter Three Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions Objectives Case Study Housing Slump Means Opportunity For College Students Calculations and Expressions Creating a Calculated Field in a Query Formatting and Saving Calculated Results Hands-On Exercise 1: Calculations and Expressions The Expression Builder and Functions Creating Expressions with the Expression Builder Using Built-In Functions in Access Hands-On Exercise 2: The Expression Builder and Functions Aggregate Functions Adding Aggregate Functions to Datasheets Creating Queries with Aggregate Functions Hands-On Exercise 3: Aggregate Functions Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Chapter Four Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries Objectives Case Study Coffee Shop Starts New Business Form Basics Creating Forms Using Form Tools Using Form Views Working with a Form Layout Control Sorting Records in a Form Hands-On Exercise 1: Create and Modify forms Report Basics Creating Reports Using Report Tools Using Report Views Modifying a Report Sorting Records in a Report Hands-On Exercise 2: Report Basics Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Microsoft Office PowerPoint 2013 Chapter One Introduction to PowerPoint: Creating a Basic Presentation Objectives Case Study Be a Trainer Introduction to PowerPoint Using PowerPoint Views Typing a Speaker Note Saving As a Slide Show Hands-On Exercise 1: Introduction to PowerPoint Presentation Creation Planning a Presentation Assessing Presentation Content Reviewing the Presentation Hands-On Exercise 2: Presentation Creation Presentation Enhancement Inserting Media Objects Adding a Table Using Animations and Transitions Inserting a Header or Footer Hands-On Exercise 3: Presentation Enhancement Navigation and Printing Running and Navigating a Slide Show Printing in PowerPoint Hands-On Exercise 4: Navigation and Printing Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Chapter Two Presentation Development: Planning and Preparing a Presentation Objectives Case Study The Wellness Education Center Templates Creating a Presentation Using a Template Modifying a Presentation Based on a Template Hands-On Exercise 1: Templates Outlines Creating a Presentation in Outline View Modifying an Outline Structure Printing an Outline Hands-On Exercise 2: Outlines Data Imports Importing an Outline Reusing Slides from an Existing Presentation Hands-On Exercise 3: Data Imports Design Using Sections Examining Slide Show Design Principles Modifying a Theme Modifying the Slide Master Hands-On Exercise 4: Design Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Chapter Three Presentation Design: Illustrations and Infographics Objectives Case Study Illustrations and Infographics Mini-Camp Shapes Creating Shapes Applying Quick Styles and Customizing Shapes Hands-On Exercise 1: Shapes Smartart and Wordart Creating SmartArt Modifying SmartArt Creating WordArt Modifying WordArt Hands-On Exercise 2: SmartArt and WordArt Object Manipulation Modifying Objects Arranging Objects Hands-On Exercise 3: Object Manipulation Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Chapter Four PowerPoint Rich Media Tools: Enhancing with Multimedia Objectives Case Study Engagement Album Pictures Inserting a Picture Transforming a Picture Using the Internet as a Resource Hands-On Exercise 1: Pictures Video Adding Video Using Video Tools Hands-On Exercise 2: Video Audio Adding Audio Changing Audio Settings Hands-On Exercise 3: Audio Photo Albums Creating a Photo Album Setting Photo Album Options Hands-On Exercise 4: Photo Albums Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Application Capstone Exercises Word Excel Access PowerPoint Glossary Index. Integrating Programs: Word and Excel. For use in the Office Applications course or readers that need to get started with Microsoft Office 2013.
These apps simply are not listed anywhere as an option to choose for importing pictures or anything else for that matter. And, because so much learning takes place outside of the classroom, this series provides learning tools that students can access anywhere, any time. Office—Chapter 1: Microsoft Office 2014 Overview Word—Chapter 1: Creating and Editing Business Documents Word—Chapter 2: Formatting and Customising Documents Word—Chapter 3: Using Tables, Columns, and Graphics Word—Chapter 4: Using Templates and Mail Merge Integrating Word Skills Excel—Chapter 1: Creating and Editing Worksheets Excel—Chapter 2: Using Formulas and Functions Excel—Chapter 3: Creating and Editing Charts Excel—Chapter 4: Importing, Creating Data Tables, and Filtering Data Integrating Word and Excel Skills Access—Chapter 1: Creating a Database and Tables Access—Chapter 2: Using Design View, Data Validation, and Relationships Access—Chapter 3: Creating and Using Queries Access—Chapter 4: Creating and Using Forms and Reports Integrating Word, Excel, and Access Skills PowerPoint—Chapter 1: Creating and Editing Presentations PowerPoint—Chapter 2: Illustrating Slides with Pictures and Graphical Elements PowerPoint—Chapter 3: Preparing for Delivery and Using a Slide Presentation Integrating Office Skills Appendices — Using Office Help — Business Document Formats — Getting the Most Out of SimNet and SimGrader — Office Shortcuts — Office Web Apps — Customising Microsoft Office 2014 — Certification?? Page numbers are included for easy reference to help students locate the answers. Marquee Series: Microsoft Office 2013 offers your students a highly-effective, hands-on visual approach to learning the essential skills in Word, Excel, Access, and PowerPoint. Within its structured environment, students practice what they learn, test their understanding, and pursue a personalized study plan that helps them absorb course material and understand difficult concepts. Here is a summary of the applications available in Microsoft Office 2013: Microsoft Office 2013 is available in three different forms which are aimed at different users. This requires students to work actively with this important vocabulary and prove conceptual understanding.
Table of Contents Windows 8 Chapter One Getting Started with Windows 8 Objectives Case Study Cedar Grove Elementary School Windows 8 Fundamentals Understanding the Start Screen Configuring the Start Screen Running Windows 8 Apps Closing Apps Understanding the Desktop Managing Windows 8 Apps and Windows Hands-On Exercise 1: Windows 8 Fundamentals Windows Programs and Security Features Identifying Windows Accessories Working with Security Settings and Software Hands-On Exercise 2: Windows Programs and Security Features Windows Search and Help Performing a Search Using Targeted Searches Getting Help Hands-On Exercise 3: Windows Search and Help Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Microsoft Office 2013 Chapter One Office Fundamentals and File Management: Taking the First Step Objectives Case Study Spotted Begonia Art Gallery Windows 8 Startup Logging In with Your Microsoft Account Identifying the Start Screen Components Interacting with the Start Screen Accessing the Desktop Hands-On Exercise 1: Windows 8 Startup Files and Folders Using File Explorer Working with Folders and Files Selecting, Copying, and Moving Multiple Files and Folders Hands-On Exercise 2: Files and Folders Microsoft Office Software Identifying Common Interface Components Getting Office Help Hands-On Exercise 3: Microsoft Office Software The Backstage View Tasks Opening a File Printing a File Closing a File and Application Hands-On Exercise 4: The Backstage View Tasks Home Tab Tasks Selecting and Editing Text Using the Clipboard Group Commands Using the Editing Group Commands Hands-On Exercise 5: Home Tab Tasks Insert Tab Tasks Inserting Objects Review Tab Tasks Reviewing a File Page Layout Tab Tasks Using the Page Setup Dialog Box Hands-On Exercise 6: Insert Tab Tasks, Page Layout Tab Tasks, and Review Tab Tasks Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Chapter One Introduction to Word: Organizing a Document Objectives Case Study Swan Creek National Wildlife Refuge Introduction to Word Processing Beginning and Editing a Document Customizing Word Hands-On Exercise 1: Introduction to Word Processing Document Organization Using Features That Improve Readability Viewing a Document in Different Ways Hands-On Exercise 2: Document Organization Document Settings and Properties Preparing a Document for Distribution Modifying Document Properties Hands-On Exercise 3: Document Settings and Properties Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Microsoft Office Word 2013 Chapter Two Document Presentation: Editing and Formatting Objectives Case Study Phillips Studio L Photography Text and Paragraph Formatting Applying Font Attributes Formatting a Paragraph Hands-On Exercise 1: Text and Paragraph Formatting Document Appearance Formatting a Document Applying Styles Hands-On Exercise 2: Document Formatting Objects Inserting and Formatting Objects Hands-On Exercise 3: Objects Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Chapter Three Document Productivity: Working with Tables and Mail Merge Objectives Case Study Traylor University Economic Impact Study Tables Inserting a Table Formatting a Table Hands-On Exercise 1: Tables Advanced Table Features Managing Table Data Enhancing Table Data Hands-On Exercise 2: Advanced Table Features Mail Merge Creating a Mail Merge Document Completing a Mail Merge Hands-On Exercise 3: Mail Merge Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Chapter Four Collaboration and Research: Communicating and Producing Professional Papers Objectives Case Study Literature Analysis Research Paper Basics Using a Writing Style and Acknowledging Sources Creating and Modifying Footnotes and Endnotes Exploring Special Features Hands-On Exercise 1: Research Paper Basics Document Tracking Reviewing a Document Tracking Changes Hands-On Exercise 2: Document Tracking Online Document Collaboration Using SkyDrive Sharing and Collaborating on Documents Hands-On Exercise 3: Online Document Collaboration Chapter Objectives Review Key Terms Matching Multiple Choice Practice Exercises Mid-Level Exercises Beyond the Classroom Capstone Exercise Microsoft Office Excel 2013 Chapter One Introduction to Excel: What Is a Spreadsheet? The latest edition provides an easy-to-follow map through each chapter to help students learn, study, and review efficiently and be successful in this class and beyond. If you need more help, please post back and we will be happy to assist you Thank you,. Description This book covers introductory Word, Excel, Access, and PowerPoint, with an additional Windows 8 chapter. Page numbers link the questions back to the white pages for review. Move students beyond the point-and-click.
Table of Contents Information Technology Essentials. Hope the above information answers your query. This includes page numbers so students can skip between objectives where they feel they need the most help. Integrating Programs: Word, Excel, and Access. The issue I'm having is that I can not import pictures from these apps into PowerPoint 2013. However you may also refer the link provided below for more information. Creating Queries, Forms, and Reports.
With Safari, you learn the way you learn best. The goal of the Exploring series is to move students beyond the point and click, to understanding the why and how behind each skill. The Office Skills text that was designed with today's students—and the way today's readers use an Office textbook—in mind. Pricing subject to change at any time. Pricing subject to change at any time. The estimated amount of time this product will be on the market is based on a number of factors, including faculty input to instructional design and the prior revision cycle and updates to academic research-which typically results in a revision cycle ranging from every two to four years for this product. Browsing the Internet Using Internet Explorer 10.
Newly included in this is a Key Terms Matching exercise, a Collaboration Case, and Soft Skills Case for every chapter. Hi Jermey, Welcome to Microsoft Community and thank you for posting the question. Microsoft Office 2013 is a suite of applications that enable you to produce documents, spreadsheets, presentations and other desktop publishing. I can see all of them on this app. With Skills for Success, Microsoft Office 2013 is at your fingertips! Skills for Success is the Microsoft Office 2013 standalone textbook that recognizes how readers learn today! Each chapter has approximately 12—15 exercises ranging from multiple choice questions to open-ended projects. Creating and Editing a Document. Maintaining Files and Customizing Windows.
Teaching and Learning Experience This program will provide a better teaching and learning experience—for you and your students. Using Functions, Setting Print Options, and Adding Visual Elements. And, coming from Pearson, you can be confident you have an experienced partner that is committed to providing the content, resources, and expertise for the best digital learning tools—now and into the future. Newly designed in an easy-to-read bulleted format. These questions cover the most essential concepts in the white pages required for students to be successful in working the Hands-On Exercises. . .