Microsoft Access Data Analysis Unleashing the Analytical Power of Access

ISBN-10: 076459978X

ISBN-13: 9780764599781

Edition: 2006

List price: $39.99
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


This guide shows readers that Microsoft Access has strong data analysis capabilities that are easy to learn, applicable to all kinds of business situations, and relevant to many types of organizations.
what's this?
Rush Rewards U
Members Receive:
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.

Customers also bought

Book details

List price: $39.99
Copyright year: 2006
Publisher: John Wiley & Sons, Incorporated
Publication date: 1/4/2006
Binding: Paperback
Pages: 552
Size: 7.50" wide x 9.25" long x 1.50" tall
Weight: 1.782
Language: English

MICHAEL ALEXANDER is the pseudonym of a nurse who has previously worked in the UK and New Zealand.

Defining Data Analysis
Why Use Microsoft Access for Data Analysis?
Where data analysis with Excel can go wrong
Deciding whether to use Access or Excel
A Gentle Introduction to Access
What You Will Learn from This Book
What this book does and does not cover
How this book is organized
About the companion database
Fundamentals of Data Analysis in Access
Access Basics
Access Table Basics
What is a table?
Opening a table in Datasheet view
Identifying important table elements
Opening a table in Design view
Exploring data types
Preparing to create a table
Different methods for creating a table
Creating a table with Design view
Advanced Table Concepts
Field properties
Primary key
Getting Data into Access
Things to remember about importing data
The Relational Database Concept
Excel and the flat-file format
Splitting data into separate tables
Foreign key
Relationship types
Query Basics
What is a query?
Creating a select query
Beyond Select Queries
Aggregate Queries
Creating an aggregate query
Exploring aggregate functions
Action Queries
Why use action queries?
Make-table queries
Delete queries
Append queries
Update queries
Crosstab Queries
Using the Crosstab Query Wizard
Creating a crosstab query manually
Customizing your crosstab queries
Basic Analysis Techniques
Transforming Your Data with Access
Finding and Removing Duplicate Records
Defining duplicate records
Finding duplicate records
Removing duplicate records
Common Transformation Tasks
Filling in blank fields
Changing case
Removing leading and trailing spaces from a string
Finding and replacing specific text
Adding your own text in key positions within a string
Parsing strings using character markers
Working with Calculations and Dates
Using Calculations in Your Analysis
Common calculation scenarios
Using the Expression Builder to construct calculations
Common calculation errors
Using Dates in Your Analysis
Simple date calculations
Advanced analysis using functions
Performing Conditional Analysis
Using Parameter Queries
How parameter queries work
Ground rules of parameter queries
Working with parameter queries
Using Conditional Functions
The IIf function
The Switch function
Advanced Analysis Techniques
Working with Subqueries and Domain Aggregate Functions
Understanding SQL
The SELECT statement
The ORDER BY clause
The WHERE clause
The GROUP BY clause
The HAVING clause
The AS clause
Making sense of joins
Union queries in SQL
Action queries in SQL
Enhancing Your Analysis with Subqueries
Why use subqueries?
Subquery ground rules
Using IN and NOT IN with subqueries
Using subqueries with comparison operators
Using subqueries as expressions
Using correlated subqueries
Using subqueries within action queries
Domain Aggregate Functions
The anatomy of domain aggregate functions
Understanding the different domain aggregate functions
Examining the syntax of domain aggregate functions
Using domain aggregate functions
Running Descriptive Statistics in Access
Basic Descriptive Statistics
Running descriptive statistics with aggregate queries
Determining rank, mode, and median
Pulling a random sampling from your dataset
Advanced Descriptive Statistics
Calculating percentile ranking
Determining the quartile standing of a record
Creating a frequency distribution
Analyzing Data with Pivot Tables and Pivot Charts
Working with Pivot Tables in Access
The anatomy of a pivot table
Creating a basic pivot table
Creating an advanced pivot table with details
Setting the PivotTable view as the default view
Pivot table options
Working with Pivot Charts in Access
The anatomy of a pivot chart
Creating a basic pivot chart
Formatting your pivot chart
Automating Data Analysis
Scheduling and Running Batch Analysis
Introduction to Access Macros
Creating your first macro
Essential macro actions
Setting Up and Managing Batch Analysis
Getting organized
Setting up a basic batch analysis
Building smarter macros
Looping with macros
Scheduling Macros to Run Nightly
Using an AutoExec macro to schedule tasks
Using command lines to schedule tasks
Leveraging VBA to Enhance Data Analysis
Creating and Using Custom Functions
Creating your first custom function
Creating a custom function that accepts arguments
Controlling Analytical Processes with Forms
The basics of passing data from a form to a query
Enhancing automation with forms
Enumerating through a combo box
Processing Data Behind the Scenes
Processing data with RunSQL statements
Advanced techniques using RunSQL statements
Reporting Your Results Using Excel Automation
The Basics of Excel Automation
A word on binding Access to Excel
Creating your first Excel automation procedure
Sending Access data to Excel
Advanced Automation Techniques
Stealing code from Excel
Optimizing macro-generated code
Query Performance, Database Corruption, and Other Final Thoughts
Optimizing Query Performance
Understanding Microsoft Jet's query optimizer
Steps you can take to optimize query performance
Handling Database Corruption
The signs and symptoms of a corrupted database
Recovering a corrupted database
Preventing database corruption
Getting Help in Access
Location matters when asking for help
Use the table of contents instead of a keyword search
Online help is better than offline help
Diversify your knowledgebase with online resources
Data Analyst's Function Reference
Access VBA Fundamentals
Data Analyst's Error Reference
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.