| |
| |
Office | |
| |
| |
| |
Introduction to Microsoft Office 2013 Features | |
| |
| |
| |
Note Form | |
| |
| |
| |
Use File Explorer to Download, Extract, and Locate Files and Folders | |
| |
| |
| |
Using File Explorer to Download, Extract, and Locate Files and Folders | |
| |
| |
| |
Use Start Search to Locate and Start a Microsoft Office 2013 Desktop App | |
| |
| |
| |
Using Start Search to Locate and Start a Microsoft Office 2013 Desktop App | |
| |
| |
| |
Enter, Edit, and Check the Spelling of Text in an Office 2013 Program | |
| |
| |
| |
Entering and Editing Text in an Office 2013 Program | |
| |
| |
| |
Checking Spelling | |
| |
| |
| |
Perform Commands from a Dialog Box | |
| |
| |
| |
Performing Commands from a Dialog Box | |
| |
| |
| |
Using Undo | |
| |
| |
| |
Create a Folder and Name and Save a File | |
| |
| |
| |
Creating a Folder and Naming and Saving a File | |
| |
| |
| |
Insert a Footer, Add Document Properties, Print a File, and Close a Desktop App | |
| |
| |
| |
Inserting a Footer, Inserting Document Info, and Adding Document Properties | |
| |
| |
| |
Printing a File and Closing a Desktop App | |
| |
| |
| |
Memo | |
| |
| |
| |
Open an Existing File and Save It with a New Name | |
| |
| |
| |
Opening an Existing File and Saving It with a New Name | |
| |
| |
More Knowledge Read-only | |
| |
| |
| |
Sign In to Office and Explore Options for a Microsoft Office Desktop App | |
| |
| |
| |
Signing In to Office and Viewing Application Options | |
| |
| |
| |
Perform Commands from the Ribbon and Quick Access Toolbar | |
| |
| |
| |
Performing Commands from and Customizing the Ribbon and the Quick Access Toolbar | |
| |
| |
More Knowledge Customizing the Ribbon | |
| |
| |
| |
Minimizing and Using the Keyboard to Control the Ribbon | |
| |
| |
| |
Apply Formatting in Office Programs | |
| |
| |
| |
Changing Page Orientation and Zoom Level | |
| |
| |
More Knowledge Zooming to Page Width | |
| |
| |
| |
Formatting Text by Using Fonts, Alignment, Font Colors, and Font Styles | |
| |
| |
| |
Using Format Painter | |
| |
| |
| |
Using Keyboard Shortcuts and Using the Clipboard to Copy, Cut, and Paste | |
| |
| |
| |
Compress Files and Use the Microsoft Office 2013 Help System | |
| |
| |
| |
Compressing Files | |
| |
| |
| |
Using the Microsoft Office 2013 Help System in Excel | |
| |
| |
| |
Install Apps for Office and Create a Microsoft Account | |
| |
| |
| |
Installing Apps for Office | |
| |
| |
| |
Creating a Microsoft Account | |
| |
| |
Summary, GO! Learn It Online | |
| |
| |
Guide to Chapter Assessments | |
| |
| |
Glossary | |
| |
| |
Access Introduction to Microsoft Access 2013 | |
| |
| |
| |
Getting Started with Microsoft Access 2013 | |
| |
| |
| |
Student Advising Database with Two Tables | |
| |
| |
| |
Identify Good Database Design | |
| |
| |
| |
Using Good Design Techniques to Plan a Database | |
| |
| |
| |
Create a Table and Define Fields in a Blank Desktop Database | |
| |
| |
| |
Starting with a Blank Desktop Database | |
| |
| |
| |
Assigning the Data Type and Name to Fields | |
| |
| |
More Knowledge Create Fields by Entering Data | |
| |
| |
| |
Renaming Fields and Changing Data Types in a Table | |
| |
| |
| |
Adding a Record to a Table | |
| |
| |
More Knowledge Renaming or Deleting a Table | |
| |
| |
| |
Adding Additional Records to a Table | |
| |
| |
| |
Importing Data from an Excel Workbook into an Existing Access Table | |
| |
| |
| |
Change the Structure of Tables and Add a Second Table | |
| |
| |
| |
Deleting a Table Field in Design View | |
| |
| |
| |
Changing a Field Size and Adding a Description | |
| |
| |
| |
Viewing the Primary Key in Design View | |
| |
| |
| |
Adding a Second Table to a Database by Importing an Excel Spreadsheet | |
| |
| |
| |
Adjusting Column Widths | |
| |
| |
| |
Printing a Table | |
| |
| |
| |
Create a Query, Form, and Report 510 | |
| |
| |
| |
Creating a Query by Using the Simple Query Wizard 510 | |
| |
| |
| |
Creating and Printing a Form 512 | |
| |
| |
| |
Creating, Modifying, and Printing a Report 514 | |
| |
| |
| |
Close a Database and Exit Access 516 | |
| |
| |
| |
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 | |
| |
| |
| |
Student Workshops Database | |
| |
| |
| |
Use a Template to Create a Database | |
| |
| |
| |
Using a Template to Create a Database | |
| |
| |
| |
Building a Table by Entering Records in a Multiple-Items Form and a Single-Record Form | |
| |
| |
| |
Appending Records by Importing from an Excel Spreadsheet | |
| |
| |
| |
Organize Objects in the Navigation Pane | |
| |
| |
| |
Grouping Database Objects in the Navigation Pane | |
| |
| |
| |
Create a New Table in a Database Created with a Template | |
| |
| |
| |
Using the Table Tool to Create a New Table | |
| |
| |
| |
Entering Records into a New Table | |
| |
| |
| |
Print a Report and a Table | |
| |
| |
| |
Viewing Reports and Printing a Report | |
| |
| |
| |
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 | |
| |
| |
| |
Sort and Query a Database | |
| |
| |
| |
Instructors and Courses Database | |
| |
| |
| |
Open and Save an Existing Database | |
| |
| |
| |
Opening and Saving an Existing Database | |
| |
| |
| |
Resolving Security Alerts and Renaming Tables | |
| |
| |
| |
Create Table Relationships | |
| |
| |
| |
Selecting the Tables and Common Field to Establish the Table Relationship | |
| |
| |
| |
Setting Relationship Options | |
| |
| |
| |
Printing and Saving a Relationship Report | |
| |
| |
| |
Displaying Subdatasheet Records | |
| |
| |
More Knowledge Other Types of Relationships: One-to-One and Many-to-Many | |
| |
| |
| |
Testing Cascade Options | |
| |
| |
| |
Sort Records in a Table | |
| |
| |
| |
Sorting Records in a Table in Ascending or Descending Order | |
| |
| |
| |
Sorting Records in a Table on Multiple Fields | |
| |
| |
| |
Create a Query in Design View | |
| |
| |
| |
Creating a New Select Query in Design View | |
| |
| |
| |
Running, Saving, Printing, and Closing a Query | |
| |
| |
| |
Create a New Query from an Existing Query | |
| |
| |
| |
Copying an Existing Query | |
| |
| |
| |
Modifying the Design of a Query | |
| |
| |
| |
Sort Query Results | |
| |
| |
| |
Sorting Query Results | |
| |
| |
More Knowledge Sorting in Design View or Datasheet View | |
| |
| |
| |
Specify Criteria in a Query | |
| |
| |
| |
Specifying Text Criteria in a Query | |
| |
| |
| |
Specifying Criteria and Hiding the Field in the Query Results | |
| |
| |
| |
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 | |
| |
| |
| |
Athletic Scholarships Database | |
| |
| |
| |
Specify Numeric Criteria in a Query | |
| |
| |
| |
Opening, Renaming, and Saving an Existing Database and Importing a Spreadsheet as a New Table | |
| |
| |
| |
Creating a One-to-Many Table Relationship | |
| |
| |
| |
Specifying Numeric Criteria in a Query | |
| |
| |
| |
Using Comparison Operators in Criteria | |
| |
| |
| |
Using the Between … And Comparison Operator | |
| |
| |
| |
Use Compound Criteria in a Query | |
| |
| |
| |
Using AND Criteria in a Query | |
| |
| |
| |
Using OR Criteria in a Query | |
| |
| |
| |
Create a Query Based on More Than One Table | |
| |
| |
| |
Creating a Query Based on More Than One Table | |
| |
| |
| |
Use Wildcards in a Query | |
| |
| |
| |
Using a Wildcard in a Query | |
| |
| |
More Knowledge Using the ? Wildcard Character to Search for a Single Unknown Character | |
| |
| |
| |
Create Calculated Fields in a Query | |
| |
| |
| |
Creating a Calculated Field in a Query | |
| |
| |
| |
Creating a Second Calculated Field in a Query | |
| |
| |
| |
Formatting Calculated Fields | |
| |
| |
| |
Calculate Statistics and Group Data in a Query | |
| |
| |
| |
Using the Min, Max, Avg, and Sum Functions in a Query | |
| |
| |
| |
Grouping Records in a Query | |
| |
| |
| |
Create a Crosstab Query | |
| |
| |
| |
Creating a Crosstab Query Using the Query Wizard | |
| |
| |
More Knowledge Creating a Crosstab Query Using Data from Two Related Tables | |
| |
| |
| |
Create a Parameter Query | |
| |
| |
| |
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 | |
| |
| |
| |
Forms, Filters, and Reports | |
| |
| |
| |
Students and Majors Database | |
| |
| |
| |
Create and Use a Form to Add and Delete Records | |
| |
| |
| |
Opening and Saving an Existing Database, Renaming Tables, and Viewing a Table Relationship | |
| |
| |
| |
Creating a Form and Viewing Records | |
| |
| |
| |
Creating a Second Form | |
| |
| |
| |
Adding Records to a Table by Using a Form | |
| |
| |
| |
Deleting Records from a Table by Using a Form | |
| |
| |
| |
Printing a Form | |
| |
| |
| |
Filter Records | |
| |
| |
| |
Filtering Data by Selection of One Field | |
| |
| |
| |
Using Filter By Form | |
| |
| |
| |
Using Advanced Filter/Sort | |
| |
| |
More Knowledge Using the Filter Button | |
| |
| |
| |
Create a Form by Using the Form Wizard | |
| |
| |
| |
Creating a Form by Using the Form Wizard | |
| |
| |
| |
Modify a Form in Layout View and in Design View | |
| |
| |
| |
Grouping Controls in Layout View | |
| |
| |
| |
Applying a Theme and Formatting a Form in Layout View | |
| |
| |
| |
Adding, Resizing, and Moving Controls in Layout View | |
| |
| |
| |
Formatting Controls in Layout View | |
| |
| |
| |
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 | |
| |
| |
| |
Job Openings Database | |
| |
| |
| |
Create a Report by Using the Report Tool and Modify the Report in Layout View | |
| |
| |
| |
Opening and Saving an Existing Database, Renaming Objects, and Viewing a Table Relationship | |
| |
| |
| |
Creating a Report by Using the Report Tool and Applying a Theme to the Report | |
| |
| |
| |
Modifying a Report in Layout View | |
| |
| |
| |
Printing a Report | |
| |
| |
| |
Create a Report by Using the Report Wizard | |
| |
| |
| |
Creating a Report by Using the Report Wizard | |
| |
| |
| |
Modify the Design of a Report | |
| |
| |
| |
Formatting and Deleting Controls in Layout View | |
| |
| |
| |
Modifying Controls in Layout View | |
| |
| |
| |
Aligning Controls in Design View | |
| |
| |
| |
Keep Grouped Data Together in a Printed Report | |
| |
| |
| |
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 | |