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
Activity 1.14 Creating a Query by Using the Simple Query Wizard
Activity 1.15 Creating and Printing a Form
Activity 1.16 Creating, Modifying, and Printing a Report
Objective 5 Close a Database and Exit Access
Activity 1.17 Closing a Database and Exiting Access
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 521 Activity 1.18 Using a Template to Create a Database 521
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 532
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 667 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
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
Chapter 4 Enhancing Tables
Project 4A City Directory
Objective 1 Manage Existing Tables
Activity 4.01 Backing Up a Database
Activity 4.02 Adding File Locations to Trusted Locations
Activity 4.03 Duplicating a Table and Modifying the Structure
Activity 4.04 Copying and Appending Records to a Table
Activity 4.05 Splitting a Table into Two Tables
Activity 4.06 Appending Records from Another Database
Objective 2 Modify Existing Tables
Activity 4.07 Finding and Deleting Records
Activity 4.08 Finding and Modifying Records
Activity 4.09 Adding and Moving Fields in Design View and Datasheet View
Activity 4.10 Checking Spelling
Objective 3 Change Data Types
Activity 4.11 Changing Data Types
Objective 4 Attach Files to Records
Activity 4.12 Attaching a Word Document to a Record
Project 4B IT Tasks
Objective 5 Create a Table in Design View
Activity 4.13 Creating a Table in Design View
Activity 4.14 Adding Fields to a Table in Design View
Objective 6 Create a Lookup Field
Activity 4.15 Creating a Lookup Field Based on a List of Values
Activity 4.16 Creating a Lookup Field Based on Data in Another Table
Objective 7 Set Field Properties
Activity 4.17 Creating an Input Mask Using the Input Mask Wizard
Activity 4.18 Creating an Input Mask Using the Input Mask Properties Box
Activity 4.19 Specifying a Required Field
Activity 4.20 Setting Default Values for Fields
Activity 4.21 Indexing Fields in a Table
Objective 8 Create Validation Rules and Validation Text
Activity 4.22 Creating Data Validation Rules and Validation Text
Activity 4.23 Testing Table Design and Field Properties
Chapter 5 Enhancing Queries
Project 5A Store Inventory
Objective 1 Create Calculated Fields in a Query
Activity 5.01 Creating a Calculated Field Based on Two Existing Fields
Activity 5.02 Creating a Calculated Field Based on One Existing Field and a Number
Objective 2 Use Aggregate Functions in a Query
Activity 5.03 Adding a Total Row to a Query
Activity 5.04 Creating a Totals Query
Objective 3 Create a Crosstab Query
Activity 5.05 Creating a Select Query as the Source for a Crosstab Query
Activity 5.06 Creating a Crosstab Query
Objective 4 Find Duplicate and Unmatched Records
Activity 5.07 Finding Duplicate Records
Activity 5.08 Finding Unmatched Records
Objective 5 Create a Parameter Query
Activity 5.09 Creating a Parameter Query Using One Criterion
Activity 5.10 Creating a Parameter Query Using Multiple Criteria
Project 5B Customer Orders
Objective 6 Create a Make Table Query
Activity 5.11 Creating a Select Query
Activity 5.12 Converting a Select Query to a Make Table Query
Objective 7 Create an Append Query
Activity 5.13 Creating an Append Query for a Table in the Current Database
Activity 5.14 Creating an Append Query for a Table in Another Database
Objective 8 Create a Delete Query
Activity 5.15 Creating a Delete Query
Objective 9 Create an Update Query
Activity 5.16 Creating an Update Query
Activity 5.17 Creating an Update Query with an Expression
Objective 10 Modify the Join Type
Activity 5.18 Viewing the Results of a Query Using an Inner Join
Activity 5.19 Changing the Join Type to an Outer Join
Chapter 6 Customizing Forms and Reports
Project 6A Locations
Objective 1 Create a Form in Design View
Activity 6.01 Creating a Form in Design View
Activity 6.02 Adding Sections to a Form
Objective 2 Modify and Add Controls on a Form
Activity 6.03 Modifying Controls on a Form
Activity 6.04 Adding Controls to a Form
Objective 3 Format a Form
Activity 6.05 Adding a Background Color to a Form
Activity 6.06 Adding a Background Picture to a Form
Activity 6.07 Modifying the Borders of Controls
Objective 4 Make a Form User Friendly
Activity 6.08 Adding a Message to the Status Bar
Activity 6.09 Creating Custom ControlTips
Activity 6.10 Changing the Tab Order
Project 6B RBC
Objective 5 Create a Report Based on a Query Using a Wizard
Activity 6.11 Creating a Report Using a Wizard
Activity 6.12 Modifying a Report Created Using a Wizard
Objective 6 Create a Report in Design View
Activity 6.13 Creating a Report in Design View
Activity 6.14 Modifying the Sections of a Report
Objective 7 Add Controls to a Report
Activity 6.15 Adding Label and Text Box Controls to a Report
Activity 6.16 Adding an Image Control and a Line Control to a Report
Objective 8 Group, Sort, and Total Records in Design View
Activity 6.17 Adding a Grouping and Sort Levels to a Report
Activity 6.18 Adding Calculated Controls to a Report
Chapter 7 Creating Advanced Forms and Reports
Project 7A MWB Schedule
Objective 1 Create a Split Form
Activity 7.01 Creating a Split Form Using the Split Form Tool
Activity 7.02 Formatting a Split Form
Activity 7.03 Converting an Existing Form into a Split Form
Objective 2 Create a Form and Subform
Activity 7.04 Creating a Form and a Subform Using the Form Tool
Activity 7.05 Creating a Form and a Subform Using the Form Wizard
Activity 7.06 Modifying a Form and a Subform
Activity 7.07 Creating a Subform by Dragging a Related Table onto an Existing Form
Objective 3 Create a Multi-Page Form
Activity 7.08 Creating a Multi-Page Form Using the Tab Control
Project 7B Expense Form
Objective 4 Create and Modify a Subreport
Activity 7.08 Using a Subreport Wizard to Create a Subreport
Activity 7.09 Modifying a Subreport
Activity 7.10 Creating a Subreport by Adding an Object to an Existing Report
Activity 7.11 Displaying a Total from a Subreport on the Main Report
Objective 5 Create a Report Based on a Parameter Query
Activity 7.12 Creating a Report Based on a Parameter Query
Activity 7.13 Printing the Parameters in the Report
Objective 6 Create an Alphabetic Index
Activity 7.14 Creating an Alphabetic Index
Chapter 8 Creating Macros
Project 8A Employee Records
Objective 1 Create a Standalone Macro with One Action
Activity 8.01 Creating a Standalone Macro
Activity 8.02 Opening a Form in Its Own Window
Activity 8.03 Creating a Second Standalone Macro that Executes Automatically
Objective 2 Add Multiple Actions to a Standalone Macro
Activity 8.04 Adding Multiple Actions to an Existing Standalone Macro
Objective 3 Create an Embedded Macro
Activity 8.05 Creating an Embedded Macro on a Form
Activity 8.06 Creating an Embedded Macro on a Report
Objective 4 Print Macro Details
Activity 8.07 Printing Macro Details
Project 8B Employee Benefits
Objective 5 Create a Macro Group
Activity 8.08 Creating the First Macro in a Macro Group
Activity 8.09 Creating a Second Macro in a Macro Group
Activity 8.10 Creating a Third Macro in a Macro Group
Objective 6 Associate a Macro with an Event
Activity 8.11 Associating a Command Button with a Macro
Objective 7 Create a Data Macro
Activity 8.12 Creating an Event-Driven Macro
Chapter 9 Integrating Access with Other Applications
Project 9A Liberty Motors
Objective 1 Import Data from a Word Table
Activity 9.01 Preparing a Word Table for Importing
Activity 9.02 Importing Data from a Word Table
Objective 2 Import Data from an Excel Workbook
Activity 9.03 Importing Data from an Excel Worksheet
Activity 9.04 Appending Data from Excel to an Access Table
Objective 3 Insert an Excel Chart into a Report
Activity 9.05 Creating a Query and a Report
Activity 9.06 Inserting an Excel Chart into a Report
Objective 4 Import from and Link to Another Access Database
Activity 9.07 Importing Data from Another Access Database
Activity 9.08 Linking a Table in Another Access Database
Project 9B Used Car Inventory
Objective 5 Export Data to Word
Activity 9.09 Exporting an Access Query to Word
Activity 9.10 Exporting an Access Report to Word
Objective 6 Use Mail Merge to Integrate Access and Word
Activity 9.11 Merging an Access Table with a Word Document
Objective 7 Export Data to Excel
Activity 9.12 Exporting Selected Records to Excel
Activity 9.13 Copying Selected Records to an Existing Excel Workbook
Objective 8 Export Data to an HTML File and an XML File
Activity 9.14 Exporting a Report to an HTML File
Activity 9.15 Exporting a Report to an XML File
Chapter 10 Administering Databases and Writing SQL Statements
Project 10A Lawyers
Objective 1 Create a Navigation Form
Activity 10.01 Creating a Navigation Form Using the Navigation Form Tool
Objective 2 Use Microsoft Access Analysis Tools
Activity 10.02 Using the Table Analyzer
Activity 10.03 Using the Performance Analyzer
Activity 10.04 Viewing Object Dependencies
Objective 3 Modify Access Views and Behaviors
Activity 10.05 Modifying Access Options
Activity 10.06 Customizing the Quick Access Toolbar
Activity 10.07 Setting Current Database Options
Activity 10.08 Setting Navigation Options
Objective 4 Use the Database Splitter
Activity 10.09 Splitting a Database
Objective 5 Encrypt and Decrypt Databases
Activity 10.10 Encrypting a Database with a Password
Activity 10.11 Decrypting a Database with a Password
Objective 6 Create a Locked Database
Activity 10.12 Creating a Secure ACCDE File
Project 10B Overdue
Objective 7 Modify a Query in SQL View
Activity 10.13 Modifying a Query in SQL View
Objective 8 Create a Query in SQL View
Activity 10.14 Creating an SQL Statement
Activity 10.15 Specifying the Join Type in SQL
Objective 9 Create a Union Query Using SQL
Activity 10.16 Creating a Union Query in SQL View
Objective 10 Create Calculated Fields and SQL Aggregate Functions
Activity 10.17 Creating Calculated Fields in SQL
Activity 10.18 Writing SQL Aggregate Functions
