Oops! Looks like we're having trouble connecting to our server.
Refresh your browser window to try again.
About this product
Product Identifiers
PublisherWiley & Sons, Incorporated, John
ISBN-100471303607
ISBN-139780471303602
eBay Product ID (ePID)895420
Product Key Features
Number of Pages340 Pages
LanguageEnglish
Publication NameExcel 5 for Windows, Spreadsheet Database
Publication Year1994
SubjectDesktop Applications / Spreadsheets, Enterprise Applications / General
TypeTextbook
AuthorJohn Dranchak
Subject AreaComputers
FormatTrade Paperback
Dimensions
Item Height1.7 in
Item Weight71.8 Oz
Item Length10.3 in
Item Width8.3 in
Additional Product Features
Intended AudienceTrade
LCCN94-007802
Dewey Edition20
IllustratedYes
Dewey Decimal650/.0285/5369
Table Of ContentWhat Is a Database'. Sorting. Filtering. Data Forms. Database Functions. Data Tables. Reading and Writing Other Data Formats. Custom Data Forms. Pivot Tables. Advanced Pivot Tables. Macros/VBA. MS Query Overview. Microsoft Query as a Stand-Alone Application. Structured Query Language Basics. Using SQL Server. Index.
SynopsisOffers 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).