GO! with Microsoft Access 2013 Introductory: (GO! for Office 2013)

For use in the Office Applications course. This book is also suitable for students and individuals seeking an introduction to Microsoft Access 2013. The primary goal of the GO! Series, aside from teaching computer applications, is ease of implementation, with an approach that is based on clearly defined projects.   Teaching and Learning Experience This program will provide a better teaching and learning experience–for you and your students. Here’s how: Personalize Learning: MyITLab delivers proven results in helping students succeed, provides engaging experiences that personalize learning, and comes from a trusted partner with educational expertise and a deep commitment to helping students and instructors achieve their goals. Engage Students with a Project-Based Approach: GO!’s project-based approach teaches students to solve real problems as they practice and learn the features. Motivate Students with Clear Instruction: Based on professor and student feedback, this text has been designed to offer clear instruction for full student comprehension. Teach the Course You Want in Less Time: The GO! series’ one-of-a kind instructional system provides you with everything you need to prepare for class, teach the material, and assess your students.

Table of Contents:
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