Office
Chapter 1 Introduction to Microsoft Office 2013 Features
Project 1A Note Form
Objective 1 Use File Explorer to Download, Extract, and Locate Files and Folders
Activity 1.01 Using File Explorer to Download, Extract, and Locate Files and Folders
Objective 2 Use Start Search to Locate and Start a Microsoft Office 2013 Desktop App
Activity 1.02 Using Start Search to Locate and Start a Microsoft Office 2013 Desktop App
Objective 3 Enter, Edit, and Check the Spelling of Text in an Office 2013 Program
Activity 1.03 Entering and Editing Text in an Office 2013 Program
Activity 1.04 Checking Spelling
Objective 4 Perform Commands from a Dialog Box
Activity 1.05 Performing Commands from a Dialog Box
Activity 1.06 Using Undo
Objective 5 Create a Folder and Name and Save a File
Activity 1.07 Creating a Folder and Naming and Saving a File
Objective 6 Insert a Footer, Add Document Properties, Print a File, and Close a Desktop App
Activity 1.08 Inserting a Footer, Inserting Document Info, and Adding Document Properties
Activity 1.09 Printing a File and Closing a Desktop App
Project 1B Memo
Objective 7 Open an Existing File and Save It with a New Name
Activity 1.10 Opening an Existing File and Saving It with a New Name
More Knowledge Read-only
Objective 8 Sign In to Office and Explore Options for a Microsoft Office Desktop App
Activity 1.11 Signing In to Office and Viewing Application Options
Objective 9 Perform Commands from the Ribbon and Quick Access Toolbar
Activity 1.12 Performing Commands from and Customizing the Ribbon and the Quick Access Toolbar
More Knowledge Customizing the Ribbon
Activity 1.13 Minimizing and Using the Keyboard to Control the Ribbon
Objective 10 Apply Formatting in Office Programs
Activity 1.14 Changing Page Orientation and Zoom Level
More Knowledge Zooming to Page Width
Activity 1.15 Formatting Text by Using Fonts, Alignment, Font Colors, and Font Styles
Activity 1.16 Using Format Painter
Activity 1.17 Using Keyboard Shortcuts and Using the Clipboard to Copy, Cut, and Paste
Objective 11 Compress Files and Use the Microsoft Office 2013 Help System
Activity 1.18 Compressing Files
Activity 1.19 Using the Microsoft Office 2013 Help System in Excel
Objective 12 Install Apps for Office and Create a Microsoft Account
Activity 1.20 Installing Apps for Office
Activity 1.21 Creating a Microsoft Account
Summary, GO! Learn It Online
Guide to Chapter Assessments
Glossary
Access Introduction to Microsoft Access 2013
Chapter 1 Getting Started with Microsoft Access 2013
Project 1A Student Advising Database with Two Tables
Objective 1 Identify Good Database Design
Activity 1.01 Using Good Design Techniques to Plan a Database
Objective 2 Create a Table and Define Fields in a Blank Desktop Database
Activity 1.02 Starting with a Blank Desktop Database
Activity 1.03 Assigning the Data Type and Name to Fields
More Knowledge Create Fields by Entering Data
Activity 1.04 Renaming Fields and Changing Data Types in a Table
Activity 1.05 Adding a Record to a Table
More Knowledge Renaming or Deleting a Table
Activity 1.06 Adding Additional Records to a Table
Activity 1.07 Importing Data from an Excel Workbook into an Existing Access Table
Objective 3 Change the Structure of Tables and Add a Second Table
Activity 1.08 Deleting a Table Field in Design View
Activity 1.09 Changing a Field Size and Adding a Description
Activity 1.10 Viewing the Primary Key in Design View
Activity 1.11 Adding a Second Table to a Database by Importing an Excel Spreadsheet
Activity 1.12 Adjusting Column Widths
Activity 1.13 Printing a Table
Objective 4 Create a Query, Form, and Report 510
Activity 1.14 Creating a Query by Using the Simple Query Wizard 510
Activity 1.15 Creating and Printing a Form 512
Activity 1.16 Creating, Modifying, and Printing a Report 514
Objective 5 Close a Database and Exit Access 516
Activity 1.17 Closing a Database and Exiting Access 517
GO! with Office Web Apps
Objective Export an Access Table to an Excel Spreadsheet, Save to SkyDrive, Edit a Record, and Save to Your Computer
Activity Exporting an Access Table to an Excel Spreadsheet, Saving the Spreadsheet to SkyDrive, Editing a Record in SkyDrive, and Saving to Your Computer
Project 1B Student Workshops Database
Objective 6 Use a Template to Create a Database
Activity 1.18 Using a Template to Create a Database
Activity 1.19 Building a Table by Entering Records in a Multiple-Items Form and a Single-Record Form
Activity 1.20 Appending Records by Importing from an Excel Spreadsheet
Objective 7 Organize Objects in the Navigation Pane
Activity 1.21 Grouping Database Objects in the Navigation Pane
Objective 8 Create a New Table in a Database Created with a Template
Activity 1.22 Using the Table Tool to Create a New Table
Activity 1.23 Entering Records into a New Table
Objective 9 Print a Report and a Table
Activity 1.24 Viewing Reports and Printing a Report
Activity 1.25 Printing a Table
GO! with Office Web Apps
Objective Export an Access Table to an Excel Spreadsheet, Save to Google Drive, Add a Record, and Save to Your Computer
Activity Exporting an Access Table to an Excel Spreadsheet, Saving the Spreadsheet to Google Drive, Editing a Record in Google Drive, and Saving to Your Computer
GO! with Microsoft Office 365
Activity Using the Exchange Online Outlook Meeting Tool to Collaborate
Summary, GO! Learn It Online, GO! For Job Success
Guide to Chapter Assessments
Glossary
Skills Review
Mastering Access
Rubric
GO! Think
Chapter 2 Sort and Query a Database
Project 2A Instructors and Courses Database
Objective 1 Open and Save an Existing Database
Activity 2.01 Opening and Saving an Existing Database
Activity 2.02 Resolving Security Alerts and Renaming Tables
Objective 2 Create Table Relationships
Activity 2.03 Selecting the Tables and Common Field to Establish the Table Relationship
Activity 2.04 Setting Relationship Options
Activity 2.05 Printing and Saving a Relationship Report
Activity 2.06 Displaying Subdatasheet Records
More Knowledge Other Types of Relationships: One-to-One and Many-to-Many
Activity 2.07 Testing Cascade Options
Objective 3 Sort Records in a Table
Activity 2.08 Sorting Records in a Table in Ascending or Descending Order
Activity 2.09 Sorting Records in a Table on Multiple Fields
Objective 4 Create a Query in Design View
Activity 2.10 Creating a New Select Query in Design View
Activity 2.11 Running, Saving, Printing, and Closing a Query
Objective 5 Create a New Query from an Existing Query
Activity 2.12 Copying an Existing Query
Activity 2.13 Modifying the Design of a Query
Objective 6 Sort Query Results
Activity 2.14 Sorting Query Results
More Knowledge Sorting in Design View or Datasheet View
Objective 7 Specify Criteria in a Query
Activity 2.15 Specifying Text Criteria in a Query
Activity 2.16 Specifying Criteria and Hiding the Field in the Query Results
Activity 2.17 Using Is Null Criteria to Find Empty Fields
GO! with Office Web Apps
Objective Export an Access Query to a PDF File, Save to SkyDrive, and Add a Description to the PDF File
Activity Exporting an Access Query to a PDF File, Uploading a PDF File to SkyDrive, and Adding a Description to a PDF File
Project 2B Athletic Scholarships Database
Objective 8 Specify Numeric Criteria in a Query
Activity 2.18 Opening, Renaming, and Saving an Existing Database and Importing a Spreadsheet as a New Table
Activity 2.19 Creating a One-to-Many Table Relationship
Activity 2.20 Specifying Numeric Criteria in a Query
Activity 2.21 Using Comparison Operators in Criteria
Activity 2.22 Using the Between ... And Comparison Operator
Objective 9 Use Compound Criteria in a Query
Activity 2.23 Using AND Criteria in a Query
Activity 2.24 Using OR Criteria in a Query
Objective 10 Create a Query Based on More Than One Table
Activity 2.25 Creating a Query Based on More Than One Table
Objective 11 Use Wildcards in a Query
Activity 2.26 Using a Wildcard in a Query
More Knowledge Using the ? Wildcard Character to Search for a Single Unknown Character
Objective 12 Create Calculated Fields in a Query
Activity 2.27 Creating a Calculated Field in a Query
Activity 2.28 Creating a Second Calculated Field in a Query
Activity 2.29 Formatting Calculated Fields
Objective 13 Calculate Statistics and Group Data in a Query
Activity 2.30 Using the Min, Max, Avg, and Sum Functions in a Query
Activity 2.31 Grouping Records in a Query
Objective 14 Create a Crosstab Query
Activity 2.32 Creating a Crosstab Query Using the Query Wizard
More Knowledge Creating a Crosstab Query Using Data from Two Related Tables
Objective 15 Create a Parameter Query
Activity 2.33 Creating a Parameter Query with One Criteria
More Knowledge Parameter Query Prompts
GO! with Office Web Apps
Objective Export an Access Query to a PDF File, Save the PDF File to Google Drive, and Share the File
Activity Exporting an Access Query to a PDF File, Saving the PDF file to Google Drive, and Sharing the File
GO! with Microsoft Office 365
Activity Sharing Calendars
Summary, GO! Learn It Online, GO! For Job Success
Guide to Chapter Assessments
Glossary
Skills Review
Mastering Access
Rubric
GO! Think
Chapter 3 Forms, Filters, and Reports
Project 3A Students and Majors Database
Objective 1 Create and Use a Form to Add and Delete Records
Activity 3.01 Opening and Saving an Existing Database, Renaming Tables, and Viewing a Table Relationship
Activity 3.02 Creating a Form and Viewing Records
Activity 3.03 Creating a Second Form
Activity 3.04 Adding Records to a Table by Using a Form
Activity 3.05 Deleting Records from a Table by Using a Form
Activity 3.06 Printing a Form
Objective 2 Filter Records
Activity 3.07 Filtering Data by Selection of One Field
Activity 3.08 Using Filter By Form
Activity 3.09 Using Advanced Filter/Sort
More Knowledge Using the Filter Button
Objective 3 Create a Form by Using the Form Wizard
Activity 3.10 Creating a Form by Using the Form Wizard
Objective 4 Modify a Form in Layout View and in Design View
Activity 3.11 Grouping Controls in Layout View
Activity 3.12 Applying a Theme and Formatting a Form in Layout View
Activity 3.13 Adding, Resizing, and Moving Controls in Layout View
Activity 3.14 Formatting Controls in Layout View
Activity 3.15 Modifying a Form in Design View
GO! with Office Web Apps
Objective Export an Access Form to an Excel Spreadsheet, Save to SkyDrive, Edit a Record, and Save to Your Computer
Activity Exporting an Access Form to an Excel Spreadsheet, Saving the Spreadsheet to SkyDrive, Editing a Record in SkyDrive, and Saving to Your Computer
Project 3B Job Openings Database
Objective 5 Create a Report by Using the Report Tool and Modify the Report in Layout View
Activity 3.16 Opening and Saving an Existing Database, Renaming Objects, and Viewing a Table Relationship
Activity 3.17 Creating a Report by Using the Report Tool and Applying a Theme to the Report
Activity 3.18 Modifying a Report in Layout View
Activity 3.19 Printing a Report
Objective 6 Create a Report by Using the Report Wizard
Activity 3.20 Creating a Report by Using the Report Wizard
Objective 7 Modify the Design of a Report
Activity 3.21 Formatting and Deleting Controls in Layout View
Activity 3.22 Modifying Controls in Layout View
Activity 3.23 Aligning Controls in Design View
Objective 8 Keep Grouped Data Together in a Printed Report
Activity 3.24 Keeping Grouped Data Together in a Printed Report
GO! with Office Web Apps
Objective Export an Access Report to a Word File, Save to SkyDrive, and Add a Description to the Word File
Activity Exporting an Access Report to a Word File, Uploading the Word File to SkyDrive, and Adding a Description to the Word File
GO! with Microsoft Office 365
Activity Using a Team Site to Collaborate
Summary, GO! Learn It Online, GO! For Job Success
Guide to Chapter Assessments
Glossary
Skills Review
Mastering Access
Rubric
GO! Think
