Skip to content
Cart (0) Free shipping over $35*
Buybacks (0) Free shipping on buybacks
loading
Help Contact
Return rental ›

Your Office Microsoft Access 2013, Comprehensive

Best in textbook rentals since 2012!

ISBN-10: 0133143031

ISBN-13: 9780133143034

Edition: 2014

Authors: Patti Hammerle, Amy Kinser, Eric Kinser, Diane Lending, Jennifer Massart

List price: $191.65
Blue ribbon 30 day, 100% satisfaction guarantee!
Marketplace
1 new & used from $9.41
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

For use in the Office Applications course or individuals who would like to master Microsoft Access 2013Make Microsoft Office, Your Office The Your Office series teaches readers the way Microsoft Office works in the real world, not just in a classroom. With Your Office, readers will learn to use Office to make decisions and solve problems in a business context. Your Office bridges the gap between skill and application, and empowers students to master Office 2013 as a tool to solve problems and make decisions.Modular Structure Promotes Concept Retention: Provides a strong foundation for readers to practice in each workshop and then synthesize the objectives covered over two…    
Customers also bought

Book details

List price: $191.65
Copyright year: 2014
Publisher: Pearson Education
Publication date: 6/18/2013
Binding: Mixed Media
Pages: 800
Size: 10.00" wide x 11.25" long x 2.00" tall
Weight: 3.366
Language: English

Amy S. Kinser Tim O'Keefe Nathan Stout Diane Lending Dee Piziak Lynn S. Hogan Barbara S. Stover Patti Hammerle

Common Features
Common Features Workshop 1
Prepare Case: Painted Paradise Resort and Spa Employee Training Preparation
Working with the Office Interface
Understand Office Applications and Accounts
Start Office Programs and Manipulate Windows
Use the Office Ribbon, Contextual Tools, and Other Menus
Manipulating Files and Finding Help in Office
Manage Files in Office
Get Help
Understanding the Cloud and Touch Integration
Use Windows SkyDrive
Use Touch Mode, Gestures, and Reading Mode
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Perform in Your Life
Access Module 1-Understanding and Using a Relational Database
The Four Main Database Objects
Prepare Case: Red Bluff Golf Club Putts for Paws Charity Tournament
Understanding Database Basics and Tables
Understand what Access Is
Maneuvering in the Navigation Pane
Understand what a Table Is
Manually Navigate a Database
Understanding Queries, Forms, and Reports
Understand what a Query Is
Understand what a Form Is
Understand what a Report Is
Backing Up Your Database
Compact and Repair a Database
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Tables, Keys, and Relationships
Prepare Case: Red Bluff Golf Club Putts for Paws Charity Tournament Database
Inserting Data into a Database
Importing Data from Other Sources
Manual Data Entry
Understanding Tables and Keys
Creating a Table in Design View
Understand Masks and Formatting
Understanding and Designating Keys
Understanding Relational Databases
Understanding Basic Principles of Normalization
Understanding Relationships
Create a One-to-Many Relationship
Create a Many-to-Many Relationship
Understanding Referential Integrity
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Access Module 1 Capstone
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Group
How Others Perform
Access Module 2-Accessing, Maintaining, and Presenting Information
Queries and Data Access
Prepare Case: Turquoise Oasis Spa Data Management
Work With Datasheets
Find and Replace Records in the Datasheet
Modify Datasheet Appearance
Queries
Run Other Query Wizards
Create Queries in Design View
Sort Query Results
Define Selection Criteria for Queries
Create Aggregate Functions
Create Calculated Fields
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Access Information from an Access Database
Prepare Case: Turquoise Oasis Spa's New Database
Creating Customized Forms
Navigate in datasheets and forms
Update Table Records Using Forms
Create a Form Using the Form Wizard
Modify a Form's Design
Creating Customized Reports
Create a Report Using the Report Wizard
Use and Customize Access Themes
Modify a Report's Design
Save a Report as a PDF File
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Access Module 2 Capstone
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Group
How Others Perform
Access Module 3-Ensuring Consistent Data and Advanced Querying
Advanced Tables
Prepare Case: The Red Bluff Golf Club: Modifying Database Tables
Controlling the Way Data Is Entered: Advanced Field Options
Understand Input Masks
Use Custom Formatting
Define Data Validation Rules
Work with Captions
Create Indexes
Use the Required Data Property
Define Default Values
Advanced Data Types
Create Lookup Fields
Use the Calculated Data Type
Use the Yes/No Data Type
Use AutoNumbers and Determining Preferences for Natural Keys
Use the Attachments, Hyperlinks, and OLE Objects Data Types
Filtering Data
Create Filters
Using the Table Analyzer Wizard
Normalize a Table
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Pattern Matching and Functions in Queries
Prepare Case: The Red Bluff Golf Club: Creating Queries
Working with Advanced Criteria and Calculations
Wildcard Characters in String Comparisons
Find Records with the "Most" or "Least" Values
Make a Parameter Query Ask for Input
Concatenate Strings Using the & Operator
Use Advanced Query Operators
Using Advanced Functions in Queries
The IIf Function
The IsNull Function
Date Functions
The Round Function
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Access Module 3 Capstone
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Group
How Others Perform
Access Module 4-Leveraging Queries for Business Information and Intelligence
Aggregated Calculations, Subquerying, and SQL
Prepare Case: The Turquoise Oasis Spa Database: Querying with Advanced Calculations
Understanding the Group By Aggregate Function in Aggregated Calculations
The Group By Clause
Summarize Data
Summarize Duplicate Data
Understanding the Where Aggregate Function in Aggregated Calculations
Where Aggregate Function
Business Calculations Using Subquerying
Subqueries
Percentage of Sales Revenue
Percentage of Sales Volume
Physical Volume
Percentage of Physical Volume
Understanding Structured Query Language
SQL Statements
SELECT Statement Basics
Create a Basic SQL Query
The WHERE Clause
The ORDER BY Clause
The HAVING Clause with AS and GROUP BY
The INNER JOIN and OUTER JOIN Clauses
The Union Query
The SQL Subquery
Creating a Crosstab Query
Crosstab Query Wizard
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Action Queries and Advanced Relationships
Prepare Case: The Turquoise Oasis Spa: Understanding Action Queries
Understanding Action Queries
Create a New Table Using a Make Table Query
Append Data to a Table
Edit and Delete Data
Create, Test, and Run Delete Queries
Advanced Relationships Using Multiple Tables
Inner Joins
Outer Joins
Use the Find Unmatched Query Wizard
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Access Module 4 Capstone
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Group
How Others Perform
Access Module 5-Producing Professional Forms and Reports
Advanced Form Settings and Form Types
Prepare Case: Enhancing Data Entry at the Red Bluff Golf Club
Working with Form Properties
Define Bound and Unbound Forms
Modify the Form Property Sheet
Using Advanced Form Modification
Modify the Form Header
Modify the Form in Design View
Creating Advanced Forms
Create Specialized Forms
Create a Multipage Form Using Tab Controls
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Advanced Reports and Mailing Labels
Prepare Case: Enhancing Database Reports at the Red Bluff Golf Club
Creating Customized Reports
Use the Summary Options in Report Wizard
Modify the Report in Design View
Selecting and Modifying Controls in Design View
Change Report Properties
Add and Remove Fields from a Report
Use the Group, Sort, and Total Pane
Add Labels and Shapes to a Report
Modify Calculated Fields in a Report
Creating Parameter Reports
Create a Parameter Report
Use Conditional Formatting in a Report
Creating Mailing Labels
Create Mailing Labels
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Access Module 5 Capstone
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Group
How Others Perform
Access Module 6-Building a Refined User Interface and Experience
Develop Navigation Forms and the User Interface
Prepare Case: Turquoise Oasis Spa Database
Creating Navigation Forms
View a Navigation Form
Create a Navigation Form
Modify a Navigation Form
Refining the User Interface
Create a Main Menu
Add Command Buttons to the Navigation Form
Set Start-Up Display Options
Test the Application
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Create a Refined User Experience with Macros
Prepare Case: The Turquoise Oasis Spa Database: Automating Tasks and Increasing Functionality
Understanding the Purpose of Macros
Modify Database Settings for Protection from Macro Viruses
Understand the Macro Designer
Understand How to Test and Troubleshoot Macros
Increase Efficiency and Usability of a Database by Automating Tasks
Improve Database Design and Function by Automating Manual Processes
Reduce Processing Time by Combining Routine Tasks
Create Macro Groups
Create Macros That Run When the Database Opens
The Benefits of Embedded Macros
Increase Functionality of Forms and Reports
Implement Complex Business Rules with Data Macros
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Access Module 6 Capstone
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Group
How Others Perform
Access Module 7-Implementing and Automating a Database with VBA
Use VBA In Access
Prepare Case: The Red Bluff Golf Course & Pro Shop Putts for Paws Charity Database
Introducing VBA Basics
Understand the Functionality of VBA in Access
Convert an Existing Macro to VBA
Edit and Structure VBA Procedures
Create and Use Loops in VBA
Adding VBA to an Access Database
Create VBA Procedures
Use Comments to Document VBA Procedures
Debug the VBA in a Database and Add Error Handling
Compiling and Securing Your VBA
Compile VBA Modules
Secure VBA in a Database
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Implement Your Database
Prepare Case: The Red Bluff Golf Course & Pro Shop Putts for Paws Charity Database
Implementing a Database
Shared and Exclusive Modes
Prepare a Database for a Single User
Compatibility Between Versions of Access
Prepare a Database for Multiple Users
Encryption and Passwords
Setting the User's Experience
Control Startup Options
Methods of Implementation
Concept Check
Key Terms
Visual Summary
Practice
Practice Case 1
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
Access Module 7 Capstone
More Practice
More Practice Case 1
Problem Solve
Problem Solve Case 1
Problem Solve Case 2
Perform
Perform in Your Life
Perform in Your Career
Perform in Your Group
How Others Perform
Efficient Interaction with a Touchscreen
Prepare Case: Painted Paradise Resort and Spa Works with Touch Features
Interacting with a Windows 8 Tablet PC
Understand Variations in Tablets
Understand Methods for Interacting with a Tablet PC
Using the Touch-Screen Interface
Use Flick, Touch, and Bezel Gestures
Use Office 2013 Touch Gestures
Use Other Touch Features
Concept Check
Key Terms
Normalize a Database for Effective Design
Prepare Case: The Terra Cotta Brew Coffee Shop Designing a Normalized Database
Normalizing a Database
Types of Anomalies
The First Normal Form
The Second Normal Form
The Third Normal Form
Join Tables Together in Relationships with Referential Integrity
Understanding an Entity Relationship Diagram
Concept Check
Key Terms
Visual Summary
Problem Solve
Problem Solve Case 1
Perform
Perform in Your Career
How Others Perform
  • TextbookRush.com BBB Business Review
  • Trustpilot
Like TextbookRush on Facebook Follow TextbookRush on X Follow TextbookRush on Instagram Subscribe to TextbookRush on YouTube Follow TextbookRush on Pinterest Add TextbookRush on Snapchat Add TextbookRush on TikTok
© 2002-2024 TextbookRush
Subscribe