Product Cover Image

GO! with Microsoft Access 2013, CourseSmart eTextbook

By Shelley Gaskin, Carolyn McLellan

Published by Prentice Hall

Published Date: Jun 28, 2013

Description

For use in the Office Applications course


Teach the course YOU want in LESS TIME!


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 for students and a one-of-a-kind supplements package.

 

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 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

Purchase Info ?

With CourseSmart eTextbooks and eResources, you save up to 60% off the price of new print textbooks, and can switch between studying online or offline to suit your needs.

Once you have purchased your eTextbooks and added them to your CourseSmart bookshelf, you can access them anytime, anywhere.

Buy Access

GO! with Microsoft Access 2013, CourseSmart eTextbook
Format: Safari Book

$25.99 | ISBN-13: 978-0-13-341489-9