Excel Windows Spreadsheet Database: Ranchak: 9780471303602: Book: : eCampus.com

Offers clear, superior instructions on how to convert Excel spreadsheets into Excel databases, how to design them from scratch and to link Excel spreadsheets to other databases such as dBASE, Access, Paradox, etc. Demonstrates when an Excel database is appropriate and when an Excel spreadsheet is better for the jobs users want to accomplish. Features excellent tips on good database design and how to create clear, readable reports (printouts).

What Is a Database?

(12)

Introduction

(1)

Data versus Information

(2)

Lists

(5)

Databases

(3)

Internal Data versus External Data

(2)

Sorting

(30)

Sort Keys

(18)

Advanced Sort Options

(2)

Custom Sort Orders

(8)

Sorting Data in an Outline

(2)

Filtering

(26)

Introduction

(1)

Filtering

(3)

AutoFilter

(8)

Advanced Filter

(14)

Summary

(1)

Data Forms

(14)

Introduction

(1)

What a Data Form Is

(3)

Using a Data Form

(5)

Restricting Data Entry/Editing

(4)

Summary

(2)

Database Functions

(10)

Introduction

(8)

Summary

(2)

Data Tables

(24)

Introduction

(1)

What a Data Table Is

(1)

One-Input Data Tables

(6)

Two-Input Data Tables

100

(3)

Lookup Tables

103

(12)

Summary

115

(2)

Reading and Writing Other Data Formats

117

(21)

Introduction

117

(1)

Importing Data

117

(10)

Exporting Data

127

(6)

Symbolic Link Files

133

(1)

Combining Data from Multiple Files into a Single File

134

(1)

Things to Watch For

135

(1)

Summary

136

(2)

Custom Data Forms

138

(13)

Using VBA to Create a Custom Data Form

138

(11)

Excel 4.0 Style Dialogs

149

(2)

Pivot Tables

151

(35)

What a Pivot Table Is

151

(4)

Creating a Pivot Table

155

(21)

Refreshing a Pivot Table

176

(3)

Creating Charts from Pivot Tables

179

(7)

Advanced Pivot Tables

186

(47)

Adding and Removing Existing Fields

186

(2)

Changing the Layout of a Pivot Table

188

(6)

Using Page Fields to Change Your View of Data

194

(5)

Working with Totals in a Pivot Table

199

(13)

Formatting a Pivot Table

212

(4)

Grouping Items in a Pivot Table Field

216

(12)

Hiding and Showing Detail in a Pivot Table

228

(5)

Macros/VBA

233

(5)

Working with Text

233

(2)

Using Pivot Table Methods in VBA Code

235

(3)

MS Query Overview

238

(11)

External Data

238

(1)

What MS Query Is and How It Works with Excel

238

(2)

Windows Open Services Architecture (WOSA)

240

(6)

Data Access from an Excel Worksheet

246

(3)

Microsoft Query as a Stand-Alone Application

249

(49)

Starting MS Query

249

(1)

Parts of the MS Query Workspace

250

(11)

Building a Simple Query

261

(11)

Building Advanced Queries

272

(26)

Structured Query Language Basics

298

(20)

Introduction

298

(1)

Relational Database Fundamentals

299

(1)

Basic Data Retrieval

299

(7)

Joining Multiple Tables

306

(4)

Sorting Information with SQL

310

(1)

Summarizing Information with SQL

310

(2)

Scalar Functions

312

(2)

Data Updating

314

(4)

Using SQL Server

318

(17)

Introduction

318

(1)

Introduction to Client/Server Computing

318

(2)

Attaching to SQL Server

320

(1)

Views

321

(2)

Stored Procedures

323

(3)

Transact/SQL Query Extensions

326

(3)

Transacts/SQL Programming Language Extensions

329

(6)

Index

335


	Buy Textbooks Sell Textbooks College Apparel Shop by School Virtual Bookstores	Order Status Shipping Rates Return Policy Marketplace Info F.A.S.T.	Contact Us Privacy Policy Legal Notices Site Security Employment	Help Desk eCampus Blog Affiliate Program Bulk Orders College Marketing

Need Help? eService@ecampus.com Copyright© 1999-2008
.