Wintersalen Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Original Essays | November 7, 2014

    Karelia Stetz-Waters: IMG The Hot Sex Tip Cosmo Won't Tell You



    Cosmopolitan Magazine recently released an article titled "28 Mind-Blowing Lesbian Sex Positions." Where was this vital information when I was a... Continue »
    1. $10.47 Sale Trade Paper add to wish list

    spacer

Access 2002 Bible with CDROM (Bible)

by

Access 2002 Bible with CDROM (Bible) Cover

 

Out of Print

Synopses & Reviews

Publisher Comments:

"The Best book out there ... I used this book so much I wore out the binding." -Don Dimon, MCSE, MCP+I, Senior Programmer/Analyst If Access 2002 can do it, you can do it too ... Client lists. Sales figures. Product inventories. In today's networked, Internet-everywhere world, you need to get a grip on your data - and make sure it's easy to access. With expert advice from Cary Prague and Michael Irwin, you'll quickly discover how to put the Web-savvy database management capabilities of Microsoft Access 2002 to work. Packed with step-by-step instructions and practical examples, this bestselling guide delivers everything you need to organize, present, analyze, and share your data over a corporate network or the Internet. Inside, you'll find complete coverage of Access 2002

* Design flexible databases using the proven seven-step method

* Create tables, forms, queries, and reports quickly with Access wizards

* Use expressions to validate data, apply rules, or format numbers

* Import, export, and link data from other Microsoft Office XP programs

* Set relationships between multiple tables to facilitate queries

* Make your data look good with formatting tricks and multimedia elements

* Create SQL Server applications with stored procedures and triggers

* Program custom forms, reports, and menus with VBA

* Create live Web forms using XML and Data Access Pages

Bonus CD-ROM

* Demos of Check Writer, EZ File Manager, EZ Access Developer's Suite, and other tools from Database Creations

* All examples and code from the book

* A searchable e-version of the book

Shareware programs are fully functional, free trial versions of copyrighted programs. If you like particular programs, register with their authors for a nominal fee and receive licenses, enhanced versions, and technical support. Freeware programs are free, copyrighted games, applications, and utilities. You can copy them to as many PCs as you like-free-but they have no technical support. www.hungryminds.com System Requirements: Pentium class PC running Windows 9x/NT/2000/Me and XP, CD-ROM drive.

Synopsis:

Master Access 2002's database management capabilities and its Web features by using the step-by-step instructions, practical examples and advice. The CD contains "Check Writer" and its source code, EZ Access Developeer Suite Sampler plus example files, templates and source code from the book.

Synopsis:

Access 2002 Bible provides comprehensive coverage of all new features and capabilities, including vastly improved Data Access Pages which gives you more ways to provide information over the Web. In addition, Access 2002 carries several performance improvements and an enhanced new file format.

Synopsis:

If Access can do it, you can do it too! Client lists. Sales figures. Web research. Take charge of your data to better run your business or organization. With expert advice from Cary Prague and Michael Irwin, you'll quickly master Access 2002's top database management capabilities and its hot new Web features. Using step-by-step instructions and practical examples and advice, the authors demonstrate everything you need to know to organize, present, analyze, and share data on a network or over the Web.

Access 2002 Bible provides comprehensive coverage of all new features and capabilities, including vastly improved Data Access Pages which gives you more ways to provide information over the Web. In addition, Access 2002 carries several performance improvements and an enhanced new file format.

About the Author

About the Authors Cary N. Prague is an internationally best selling author and lecturer in the database industry. He owns Database Creations, Inc., the world's largest Microsoft Access add-on company. Their products include a line of financial software; Business! for Microsoft Office, a mid-range accounting system, POSitively Business! Point of Sale software, the Inventory Barcode manager for mobile data collection, and the Check Writer and General Ledger. Database Creations also produces a line of developer tools including the appBuilder, an application generator for Microsoft Access, the EZ Access Developer Tools for building great user interfaces, appWatcher for maintaining code bases among several developers, and Surgical Strike, the only Patch Manager for Microsoft Access. Cary also owns Database Creations Consulting, LLC., a successful consulting firm specializing in Microsoft Access and SQL Server applications. Local and national clients include many Fortune 100 companies including manufacturers, defense contractors, insurance, health-care, and software industry companies. His client list includes Microsoft, United Technologies, ABB, Smith & Wesson Firearms, Pratt and Whitney Aircraft, ProHealth, OfficeMax, Continental Airlines, and other Fortune 500 companies. Formerly, he has held numerous management positions in corporate information systems, including Director of Managed Care Reporting for MetraHealth, Director of Corporate Finance and Software Productivity at Travelers Insurance where he was responsible for software support for 35,000 end users, and Manager of Information Systems support for Northeast Utilities. He is one of the top best-selling authors in the computer database management market having written over forty books which have sold over one million copies on software including Microsoft Access, Borland (Ashton-Tate) dBASE, Paradox, R:Base, Framework, and graphics. Cary's books include eleven books in the Access Bible series (recently number one on the Ingram Bestselling Database Titles list and in the Amazon.com top 100), Access 97 Secrets, dBASE for Windows Handbook, dBASE IV Programming (winner of the Computer Press Association's Book of the Year award for Best Software Specific Book), and Everyman's Database Primer Featuring dBASE IV. He previously completed three books for Access 2000 including Weekend Crash Course in Access 2000 Programming. Cary recently sold a product line named eTools for Microsoft Access to MightyWords, a division of FatBrain.com and Barnes and Noble. Cary is certified in Access as a Microsoft Certified Professional and has passed the MOUS test in Access and Word. He is a frequent speaker at seminars and conferences around the country. He is on the exclusive Microsoft Access Insider Advisory Board and makes frequent trips to Microsoft headquarters in Redmond, WA. He has been voted the best speaker by the attendees of several national conferences. Recently, he was a speaker for Microsoft sponsored conferences in New Orleans, Hawaii, Phoenix, Chicago, Toronto, Palm Springs, Boston, and Orlando. He has also spoken at Borland's Database Conference, Digital Consulting's Database World, Microsoft's Developer Days, Computerland's Technomics Conference, COMDEX, and COMPAQ Computer's Innovate. He was a contributing editor to Access Advisor magazine and has written for the Microsoft Office Developer's journal. Cary holds a master's degree in computer science from Rensselaer Polytechnic Institute, and an M.B.A. and Bachelor of Accounting from the University of Connecticut. He is also a Certified Data Processor. Michael R. Irwin is considered one of the leading authorities on automated database and Internet management systems today. He is a noted worldwide lecturer, a winner of national and international awards, best-selling author, and developer of client/server, Internet, Intranet, and PC-based database management systems. Mr. Irwin has extensive database knowledge, gained by working with the Metropolitan Police Department in Washington, D.C. as a developer and analyst for the Information Systems Division for over 20 years and assorted Federal Agencies of the United States Government. Since retiring in June 1992, he runs his own consuiting firm, named The Irwin Group, and is principal partner in the company - IT in Asia, LLC, specializing in Internet database integration and emphasizing Client/Server and net solutions. With consulting offices in Cincinnati Ohio, Bangkok Thailand, and Manila Philippines, his companies offer Training and Development of Internet and database applications. His company has the distinction of being one of the first Microsoft Solution's Providers (in 1992). His local, national, and international clients include many software companies, manufacturers, government agencies, and international companies. His range of expertise includes database processing and integration between mainframe, minicomputer, and PC-based database systems, as well as B-2-B and B-2-C integration between back-end databases; he is a leading authority on PC-based databases. He is one of the top best-selling authors in the computer database management market having authored numerous database books, with several of them consistently on the best sellers lists. His books, combined, have sold nearly a million copies worldwide. His most recent works include The OOPs Primer (Borland Press, dBASE 5.5 for Windows Programming (Prentice Hall), Microsoft Access 2000 Bible, Microsoft Access 2000 Bible Gold Edition (co-authored), and Working with the Internet. The Access Bible series have recently been number one on the Ingram Bestselling Database Titles list and is always in the Amazon.com top 100. He has also written several books on customs and cultures of the countries of Asia (including China, Japan, Thailand, and India). Two of his books have won international acclaim. His books are published in over 24 languages worldwide. He has been a contributing editor and author to many well-known magazines and journals. He is a frequent speaker at seminars and conferences around the world and has been voted the best speaker by the attendees of several international conferences. Michael has developed and markets several add-on software products for the Internet and productivity related applications. Many of his productivity applications can be obtained from several of his Internet sites or on many common download sites. Many of his application and systems are distributed as freeware and careware. He has also developed and distributes several development tools and add-ins for a wide range of developer applications.

Table of Contents

Preface.

Acknowledgments.

PART I: First Things First.

Chapter 1: What Is Access 2002?

Chapter 2: Installing and Running Access 2002.

Chapter 3: A Hands-on Tour of Access 2002.

Chapter 4: Database Concepts and Design.

PART II: Creating the Objects.

Chapter 5: Creating Database Tables.

Chapter 6: Setting Relationships Between Tables.

Chapter 7: Working with Information in Tables.

Chapter 8: Creating and Using Simple Data-Entry Forms.

Chapter 9: Understanding and Creating Simple Queries.

Chapter 10: Creating and Working with Simple Reports.

PART III: Using Access in Your Work.

Chapter 11: Using Operators, Functions, and Expressions.

Chapter 12: Creating Relations and Joins in Queries.

Chapter 13: Working with Select Queries.

Chapter 14: Understanding Form Controls.

Chapter 15: Creating and Customizing Data-Entry Forms.

Chapter 16: Creating Great Looking Forms.

Chapter 17: Adding Data-Validation Controls to Forms.

Chapter 18: Using OLE Objects, Graphs, Pivot Tables/Charts, and ActiveX Controls.

Chapter 19: Creating and Customizing Reports.

Chapter 20: Presentation-Quality Reports and Printing.

Chapter 21: Creating Calculations and Summaries in Reports.

PART IV: Advanced Access Database Topics.

Chapter 22: Working with External Data.

Chapter 23: Working with Advanced Select Queries.

Chapter 24: Working with Action Queries.

Chapter 25: Advanced Query Topics.

Chapter 26: Working with Subforms.

Chapter 27: Creating Mail Merge and Label Reports.

PART V: Access Application Tools.

Chapter 28: Working with Macros and Events.

Chapter 29: Using Macros in Forms and Reports.

Chapter 30: Working with Visual Basic in Access 2002.

Chapter 31: Using Visual Basic in Forms and Reports.

Chapter 32: Creating Switchboards, Command Bars, Menus, Toolbars, and Dialog Boxes.

PART VI: Access and the External World.

Chapter 33: Moving from Jet to the SQL Server 2000 Desktop Engine.

Chapter 34: Working with Access Projects.

Chapter 35: Using and Creating Access Objects for Intranets and the Internet.

Chapter 36: Building Web Applications, Data Access Pages, and XML.

Appendix A: Access 2002 Specifications.

Appendix B: Mountain Animal Hospital Tables.

Appendix C: What's on the CD-ROM.

Appendix D: Chapter Cross-Reference Guide.

Index.

Coupons.

Hungry Minds, Inc. End-User License Agreement.

Installation Instructions.

Product Details

ISBN:
9780764535963
Editor:
Croy, G.
Author:
Irwin, Michael
Author:
Irwin
Author:
Prague
Author:
Prague, Cary N.
Author:
Irwin, Michael R.
Publisher:
Wiley
Location:
New York
Subject:
Database Management - General
Subject:
Database Management - MSAccess
Subject:
Database management
Subject:
Microsoft Access
Subject:
Desktop Applications - MS Access
Subject:
Database design
Subject:
Personal Computers-Desktop Applications-Databases
Copyright:
Edition Description:
CD
Series:
Bible (IDG)
Series Volume:
73
Publication Date:
20010715
Binding:
TRADE PAPER
Language:
English
Illustrations:
Yes
Pages:
1392
Dimensions:
24 cm. +

Other books you might like

  1. Silence of the Hams (Jane Jeffry... Used Mass Market $2.95
  2. Quiche Before Dying (Jane Jeffry... Used Mass Market $3.50
  3. Photoshop 6 Killer Tips Used Trade Paper $5.95

Related Subjects

Computers and Internet » Networking » General
Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Personal Computers » Desktop Applications » Databases

Access 2002 Bible with CDROM (Bible) Used Trade Paper
0 stars - 0 reviews
$4.75 In Stock
Product details 1392 pages John Wiley & Sons - English 9780764535963 Reviews:
"Synopsis" by , Master Access 2002's database management capabilities and its Web features by using the step-by-step instructions, practical examples and advice. The CD contains "Check Writer" and its source code, EZ Access Developeer Suite Sampler plus example files, templates and source code from the book.
"Synopsis" by , Access 2002 Bible provides comprehensive coverage of all new features and capabilities, including vastly improved Data Access Pages which gives you more ways to provide information over the Web. In addition, Access 2002 carries several performance improvements and an enhanced new file format.
"Synopsis" by , If Access can do it, you can do it too! Client lists. Sales figures. Web research. Take charge of your data to better run your business or organization. With expert advice from Cary Prague and Michael Irwin, you'll quickly master Access 2002's top database management capabilities and its hot new Web features. Using step-by-step instructions and practical examples and advice, the authors demonstrate everything you need to know to organize, present, analyze, and share data on a network or over the Web.

Access 2002 Bible provides comprehensive coverage of all new features and capabilities, including vastly improved Data Access Pages which gives you more ways to provide information over the Web. In addition, Access 2002 carries several performance improvements and an enhanced new file format.

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.