Learn Microsoft SQL Server 7 by successfully completing hands-on projects You don't have to be a fortune teller to realize that Microsoft's SQL Server 7 is going to be the most widely used database product on the planet. This book, unlike typical reference books, shows you how to use SQL Server to add value to your business operations. Drawing inspiration from the lab manuals you used in biology and earth science classes, the authors provide step-by-step instructions for accomplishing the kinds of projects you'll want to do with SQL Server. Here's a taste of some of the projects: * How to build an e-commerce site with Site Server Commerce Edition * Implementing a data-driven Intranet with SQL Server and IIS * Creating both single-source and multisource data marts * Working with OLAP Services and a variety of OLAP clients * Writing Visual Basic applications that work with SQL Server Plus two CD-Roms! * CD-ROM 1 contains Microsoft SQL Server 7.0 120-Day Evaluation Edition * CD-ROM 2 contains all the code from the book, example applications, 18 third party Development tools, and links to related Web sites

Special Edition Using Access 2002 is a reader's authoritative guide to mastering the essential facets of this powerful database development platform. Detailed, step-by-step instructions guide the reader through the process of designing and using Access tables, queries, forms and reports. Special Edition Using Access 2002 will include comprehensive coverage of the transition to MSDE/SQL Server for all multi-user applications, expanded coverage of Web Applications, and expanded coverage of XML. This book contains elements such as Tips, Notes, cautions, cross-references and Troubleshooting information, giving the text a "Layered" quality that meets the needs of readers with different learning styles.

Master Everything Access 2002 Has to Offer Reap the benefits of the latest release of Microsoft Access with Mastering Access 2002 Premium Edition. Get clelear, in-depth coverage of the entire range of Access functionality, from basic to advanced. Special attention to new features makes the transition from an earlier version quick and painless, and 200 pages of bonus macro material teaches you ways to customize and automate Access to make it work for you. Establish Key Skills Create a database that meets your precise needs Design easy-to-use forms with effective visual elements Expand and collapse views to bring in supporting details Import and export data, including XML Examine data using subdatasheet views Summarize, analyze, and trend data with PivotTables and PivotCharts Filter data and create reports Publish Access data to a Web server Personalize Access menus and toolbars Keep your data secure Take advantage of improved integration with other Office applications Create custom error messages Then Tackle These Cutting-Edge Topics Recording and running macros Maintaining data with macros Handling complex macro navigation Using macros to work with groups of records Identifying and correcting macro errors Using Access as SQL Server's front end Using Access as the core of a database-driven Web site Managing replication and conflict resolution Using Visual Basic to get the most out of Access Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

"With MICROSOFT ACCESS Version 2002 CORE REFERENCE, developers learn how to quickly connect to structured data sources-and extend their solutions to the Web-with code and instruction, straight from the source. Highly regarded programming author Rick Dobson takes readers inside the enhanced capabilities of Access Version 2002, providing the expert guidance and rich, adaptable code samples they need to write, test, and debug extensible database applications faster and more intuitively than ever. The book covers ActiveX(r) Data Objects (ADO), ADO+, Microsoft SQL Server(tm), XML, and Web development in depth, using best practices and real-world examples to build comprehension and help expedite developer productivity. All the book's code appears on the companion CD-ROM so developers can study and reuse them for their own projects."--Publisher.

What Alison's book offers over most or all of the other books on the market is that Alison is able to take a highly technical topic and present it in a manner that is easy to comprehend. It is a book that the reader will often want to read from cover to cover, but it can also act as an excellent reference. The CD includes all source code from the book, sample databases, and complete applications.