GO! with Microsoft Access 2013 Comprehensive

by Gaskin, Shelley; McLellan, Carolyn; Graviett, Nancy

• ISBN13: 9780133415056
• ISBN10: 0133415058
• Edition: 1st
• Format: Spiral Bound
• Copyright: 2013-05-15
• Publisher: Pearson

Summary

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

 

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