GO! with Microsoft Access 2013 Brief

Name: GO! with Microsoft Access 2013 Brief
Price: 5.7 USD
Availability: InStock
ISBN: 9780133414509

ISBN-10: 0133414507

ISBN-13: 9780133414509

Edition: 2014

Authors: Shelley Gaskin, Carolyn McLellan

List price: $71.60

30 day, 100% satisfaction guarantee!

Marketplace

3 new & used from $5.70

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: $71.60
Copyright year: 2014
Publisher: Pearson Education
Publication date: 5/14/2013
Binding: Comb Bound
Pages: 320
Size: 8.75" wide x 10.75" long x 0.50" tall
Weight: 1.430
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 510



Creating a Query by Using the Simple Query Wizard 510



Creating and Printing a Form 512



Creating, Modifying, and Printing a Report 514



Close a Database and Exit Access 516



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



Student Workshops Database



Use a Template to Create a Database



Using a Template to Create a Database



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


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



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