How we did it:
For any feedback, any questions, any notes or just for chat - feel free to follow us on social networks
Ralph Kimball, Margy Ross
Ralph Kimball invented a data warehousing technique called ?dimensional modelling? and popularised it in his first Wiley bestseller The Data Warehouse Toolkit. Since then dimensional modelling has become the most widely accepted technique for data warehouse design. Since the first edition, Kimball has improved on his earlier techniques and created many new ones. In this second edition, he provides a comprehensive collection of all of them, from basic to advanced, and strategies for optimising data warehouse design for common business applications. He includes examples for retail sales, inventory management, procurement, orders and invoices, customer relationship management, accounting, financial services, telecommunication and utilities, health care, insurance and more. He also presents unique modelling techniques for e-commerce and shows strategies for optimising performance. A companion Web site provides updates on dimensional modelling techniques, links to related sites and source code where appropriate.
Rob Bovey, Stephen Bullen, Dennis Wallentin
A guide to the development aspects of Excel covers such topics as building add-ins, creating custom charts, using class modules, handling errors, controlling external applications, and programming with databases.
Paul Litwin, Ken Getz, Mike Gunderloy
Expert Instruction. Advanced Coverage. An Unbeatable Price. This two-volume set provides you with the two most advanced guides to Access development at a significantly reduced price. Inside, you'll find unparalleled instruction from three internationally recognized Access experts, covering the full range of Access desktop and enterprise applications. Filled with scores of practical examples illustrating effective, elegant solutions to real-world challenges, these books provide the skills you need to be a professional Access developer. Access 2002 Desktop Developer's Handbook Design and Build Access Databases for Single Users and Small Workgroups Design Forms and Reports That Meet Users' Exact Needs Take Full Advantage of the Latest Access Functionality, Including New PivotTable and Pivot Chart Views and New Programmability Features Access 2002 Enterprise Developer's Handbook Publish Data on the Web with Data Access Pages Take Advantage of Improved SQL Server Integration and XML Support Tackle the Toughest Replication and Security Challenges Put the New Office Web Components to Work in Your Access Applications
Paul Litwin, Ken Getz, Mike Gunderloy
DESIGN, BUILD, AND REFINE ACCESS APPLICATIONS THAT MEET YOUR ORGANIZATION'S SPECIAL NEEDS The latest from internationally recognized Access authorities Litwin, Getz, and Gunderloy, Access 2002 Desktop Developer's Handbook offers complete coverage of every aspect of building Access applications for single users and small workgroups. Inside, you'll find scores of practical examples, carefully devised by the authors to illustrate effective, elegant solutions to real-world challenges. Coverage includes * Understanding the Access event model * Using VBA class modules * Applying sound database design principles * Using Access SQL * Controlling controls * Using ActiveX Data Objects (ADO) * Designing effective forms and reports * Taking advantage of shared Office programmability * Controlling your printer * Using Access as an automation client and server * Debugging and handling errors * Optimizing your application * Accessing DLLs and the Windows API * Adding professional features offered by Access Wizards * Building COM add-ins and MDA files * Using Reddick VBA naming conventions
Paul Litwin, Ken Getz, Mike Gunderloy
Microsoft Access is a home and small office database, and is used as a front end to Microsoft's SQL Server database. This text covers forms, reports, database design, building add-ins, and working with the Windows API.
Teresa Hennig, Rob Cooper, Geoffrey L. Griffith
A comprehensive resource on the use of VBA for building Access applications furnishes real-world code examples to demonstrate each programming topic, including the Access Object Model, using VBA with ADO, VBA Execution and Error Handling, the Windows Registry, ADE Tools, security issues, and using VBA with SQL, among others. Original. (Intermediate)
Want to get the most out of Access? Then you need to know VBA. Access 2000 is here, and never has the power of Access depended so much on VBA programming. This makes the Access 2000 VBA Handbook essential reading if you want to use Microsoft's popular database product to its full advantage. If you're an Access user, you'll benefit from step-by-step coverage of VBA basics that will simplify your work. If you're a developer, you'll master the high-end techniques introduced in the latest release-so you can stay on top of your job. You'll learn how to: * Create databases and projects * View and print reports * Run queries to find specific records * Automate complex and time-consuming procedures * Synchronize forms and tables * Understand the ADO and DAO models * Customize the user interface * Access data using OLE DB and ODBC * Create VBA procedures for navigating a database or project * Use object properties and methods to write VBA procedures * Create relationships between forms * Execute commands using SQL statements in VBA code * Use ActiveX controls in your VBA procedures
This guide covers the upgraded features of Access 97, including Internet connections, Visual Basic for Applications (VBA) imnprovements, object linking and embedding (OLE) secrets, and error and debugging tools. The CD contains all examples from the book, including databases; reusable code; and subroutines and user-interface objects. Also included are freeware and shareware utilities, as well as demonstration versions of third-party utilities.
Still the Best Delphi Resource A Fully Revised Version of the Book That Won the Delphi Informant Readers Choice Award If you're looking to capitalize on the powerful capabilities of the latest release of Delphi, Mastering Delphi 6 is the one resource you can't do without. Practical, tutorial-based coverage helps you develop key skills, solve tough problems, and build and implement sophisticated functionality in your database, client/server, and Internet applications. The special insights of Delphi expert Marco Cantu you an extra advantage as you complete successful projects and progress towards Delphi mastery. Coverage includes: Getting to know the new run-time library (RTL) Learning to use the VCL and CLX visual libraries Developing custom components Creating data-aware controls and custom datasets Mastering database programming with BDE and dbExpress Mastering client/server programming with InterBase Interfacing with Microsoft's ADO using the dbGo component set Taking advantage of Delphi's support for COM, OLE Automation, and COM+ Programming for a multitiered application architecture Taking advantage of Delphi's support for XML and SOAP technologies Building practical, powerful Web applications Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Ken Getz, Paul Litwin, Mike Gilbert
Annotation This upgrade to the popular database product includes Internet connections, spectacular Visual Basic for Applications (VBA) improvements, Object Linking and Embedding (OLE) secrets, and error and debugging tools.