- ホーム
- > 洋書
- > 英文書
- > Computer / Databases
Full Description
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 ExperienceThis 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.
Contents
OfficeChapter 1 Introduction to Microsoft Office 2013 FeaturesProject 1A Note FormObjective 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 SpellingObjective 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 MemoObjective 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 AssessmentsGlossary Access Introduction to Microsoft Access 2013 Chapter 1 Getting Started with Microsoft Access 2013Project 1A Student Advising Database with Two TablesObjective 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 510Activity 1.14 Creating a Query by Using the Simple Query Wizard 510Activity 1.15 Creating and Printing a Form 512Activity 1.16 Creating, Modifying, and Printing a Report 514Objective 5 Close a Database and Exit Access 516Activity 1.17 Closing a Database and Exiting Access 517GO! with Office Web AppsObjective 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 DatabaseObjective 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 AppsObjective 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 365Activity 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 DatabaseProject 2A Instructors and Courses DatabaseObjective 1 Open and Save an Existing Database Activity 2.01 Opening and Saving an Existing Database Activity 2.02 Resolving Security Alerts and Renaming TablesObjective 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 ViewActivity 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 AppsObjective 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 DatabaseObjective 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 CharacterObjective 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 QueryActivity 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 AppsObjective 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 365Activity 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 ReportsProject 3A Students and Majors DatabaseObjective 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 AppsObjective 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 DatabaseObjective 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 AppsObjective 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 365Activity 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
