Tuesday, April 30, 2019

GO! with Microsoft Access 2013 Introductory (Subscription)

GO! with Microsoft Access 2013 Introductory (Subscription)

45.00$

Test Banks & Solution Manual

  1. Test Banks for Textbooks. Save money on TEST BANKS
  2. Anticipate the type of the questions that will appear in your exam.
  3. Delivery is INSTANT. You can download the files IMMEDIATELY once payment is done.
  4. Our test banks can help! All test banks are Downloads-take them with you to study!
  5. YOU GET ALL OF THE CHAPTERS. Each Test Bank follows your textbook.
  6. Ace Your Exams with Us! We are Students Helping Students Pass.
  7. Customer Service 24/7

GO! with Microsoft Access 2013 Introductory (Subscription) Bank Test , GO! with Microsoft Access 2013 Introductory (Subscription) Textbook , GO! with Microsoft Access 2013 Introductory (Subscription) PDF , GO! with Microsoft Access 2013 Introductory (Subscription) eBook , Shelley Gaskin, Pasadena City College Carolyn McLellan, Tidewater Community College Nancy Graviett, Pasadena City College

Category : Higher Education

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

Instalant Download GO! with Microsoft Access 2013 Introductory (Subscription) by Shelley Gaskin, Pasadena City College Carolyn McLellan, Tidewater Community College Nancy Graviett, Pasadena City College ZIP OR PDF

What is Test Bank?

The test bank is a guide for testing and exams. It contains a lot of questions with their correct answers related to an academic textbook. Test banks usually contain true/false questions, multiple choice questions, and essay questions. Authors provide those guides to help instructors and teachers create their exams and tests easily and fast. We recommend all students to download the sample attached to each test bank page and review them deeply..

What is Solutions Manual?

The solutions manual is a guide where you can find all the correct answers (odd and even) to your textbooks’ questions, cases, and problems.

Can I get a sample before buying a Test Bank or Solutions Manual?

Samples are attached to each test bank and solutions manual page at our website. We always recommend students and instructors to download the samples before placing orders. At MANUALS1 we offer a complete sample chapter for each product.

Can I download my files immediately after completing the order?

Yes. Our system will grant you an access to download your files immediately after completing the order.

How will I download my product?

You will receive an email from testbanky that contains the download link.

I am not able to download my test bank or solution manual

If you could not download your product for any reason, contact us and we will solve the issue immediately.

No comments:

Post a Comment