GO! with Microsoft Access 2013 Introductory

Name: GO! with Microsoft Access 2013 Introductory
Availability: InStock
ISBN: 9780133417487

ISBN-10: 0133417484

ISBN-13: 9780133417487

Edition: 2014

Authors: Shelley Gaskin, Carolyn McLellan, Nancy Graviett

List price: $126.65

30 day, 100% satisfaction guarantee!

Semester Rental: $19.09 Due date: 8/15/2024

Rental notice: supplementary materials (access codes, CDs, etc.) are not guaranteed with rental orders.

Buy used: $7.17

Marketplace

1 new & used from $34.56

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

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…

Book details

List price: $126.65
Copyright year: 2014
Publisher: Pearson Education
Publication date: 5/16/2013
Binding: Comb Bound
Pages: 496
Size: 8.30" wide x 10.80" long x 0.80" tall
Weight: 2.178
Language: English

Shelley Gaskin, Series Editor for the GO! Series, is a professor of business and computer technology at Pasadena City College in Pasadena, California. She holds a master's degree in business education from Northern Illinois University and a doctorate in adult and community education from Ball State University. Dr. Gaskin has 15 years of experience in the computer industry with several Fortune 500 companies and has developed and written training materials for custom systems applications in both the public and private sector. She is also the author of books on Microsoft Outlook and word processing.



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



Creating a Query by Using the Simple Query Wizard



Creating and Printing a Form



Creating, Modifying, and Printing a Report



Close a Database and Exit Access



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



Student Workshops Database



Use a Template to Create a Database 521



Using a Template to Create a Database 521



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



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 667



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


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



Enhancing Tables



City Directory



Manage Existing Tables



Backing Up a Database



Adding File Locations to Trusted Locations



Duplicating a Table and Modifying the Structure



Copying and Appending Records to a Table



Splitting a Table into Two Tables



Appending Records from Another Database



Modify Existing Tables



Finding and Deleting Records



Finding and Modifying Records



Adding and Moving Fields in Design View and Datasheet View



Checking Spelling



Change Data Types



Changing Data Types



Attach Files to Records



Attaching a Word Document to a Record



IT Tasks



Create a Table in Design View



Creating a Table in Design View



Adding Fields to a Table in Design View



Create a Lookup Field



Creating a Lookup Field Based on a List of Values



Creating a Lookup Field Based on Data in Another Table



Set Field Properties



Creating an Input Mask Using the Input Mask Wizard



Creating an Input Mask Using the Input Mask Properties Box



Specifying a Required Field



Setting Default Values for Fields



Indexing Fields in a Table



Create Validation Rules and Validation Text



Creating Data Validation Rules and Validation Text



Testing Table Design and Field Properties



Enhancing Queries



Store Inventory



Create Calculated Fields in a Query



Creating a Calculated Field Based on Two Existing Fields



Creating a Calculated Field Based on One Existing Field and a Number



Use Aggregate Functions in a Query



Adding a Total Row to a Query



Creating a Totals Query



Create a Crosstab Query



Creating a Select Query as the Source for a Crosstab Query



Creating a Crosstab Query



Find Duplicate and Unmatched Records



Finding Duplicate Records



Finding Unmatched Records



Create a Parameter Query



Creating a Parameter Query Using One Criterion



Creating a Parameter Query Using Multiple Criteria



Customer Orders



Create a Make Table Query



Creating a Select Query



Converting a Select Query to a Make Table Query



Create an Append Query



Creating an Append Query for a Table in the Current Database



Creating an Append Query for a Table in Another Database



Create a Delete Query



Creating a Delete Query



Create an Update Query



Creating an Update Query



Creating an Update Query with an Expression



Modify the Join Type



Viewing the Results of a Query Using an Inner Join



Changing the Join Type to an Outer Join



Customizing Forms and Reports



Locations



Create a Form in Design View



Creating a Form in Design View



Adding Sections to a Form



Modify and Add Controls on a Form



Modifying Controls on a Form



Adding Controls to a Form



Format a Form



Adding a Background Color to a Form



Adding a Background Picture to a Form



Modifying the Borders of Controls



Make a Form User Friendly



Adding a Message to the Status Bar



Creating Custom ControlTips



Changing the Tab Order



RBC



Create a Report Based on a Query Using a Wizard



Creating a Report Using a Wizard



Modifying a Report Created Using a Wizard



Create a Report in Design View



Creating a Report in Design View



Modifying the Sections of a Report



Add Controls to a Report



Adding Label and Text Box Controls to a Report



Adding an Image Control and a Line Control to a Report



Group, Sort, and Total Records in Design View



Adding a Grouping and Sort Levels to a Report



Adding Calculated Controls to a Report