Your Office Microsoft Access 2013, Comprehensive

ISBN-10: 0133143031

ISBN-13: 9780133143034

Edition: 2014

List price: $135.00 Buy it from $0.71 Rent it from $15.98
eBook available
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

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 workshops–effectively challenging students to really retain what they learned as opposed to learning, and then forgetting soon after.Case Progression Promotes Concept Mastery: Readers progress from learning the skills in each Office Application to using the applications as tools to make business decisions.Realistic Series Scenario Provides Business Context: Readers gain a solid understanding of how an organization works as they see how individuals in all facets of a business interact with tools like Microsoft Office and use information to make decisions.Engaging Features Help Students Make Microsoft Office Their Own: Videos, Visual Summaries, and Real-World Advice boxes are among the features that help readers master Office to make decisions and solve problems in a business context.
Used Starting from $6.04
Rent Starting from $15.98
eBooks Starting from $29.99
Rent eBooks
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS PowerPoint® 2010 Online content $4.95 $1.99
Customers also bought
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $135.00
Copyright year: 2014
Publisher: Prentice Hall PTR
Publication date: 6/18/2013
Binding: Mixed Media
Pages: 800
Size: 10.00" wide x 11.25" long x 2.00" tall
Weight: 3.718
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
×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×