Access 2003 Bible
- The most comprehensive reference on this popular database management tool, fully updated with the new features of Access "X" including increased use of XML and Web services
- Explores the new, tighter integration with SharePoint and BizTalk in Office "X" that enables greater flexibility for gathering and manipulating data
- Written by an international bestselling author team with several books to their credit, including previous editions of Access Bible
- Gets Access beginners started with hundreds of examples, tips, and techniques for getting the most from Access
- Offers advanced programming information for serious professionals
- CD-ROM includes all templates and worksheets used in the book, as well as sample chapters from all Wiley Office "X" related Bibles and useful third party software, including John Walkenbach's Power Utility Pak
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.
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.
Michael 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 consulting 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.
Jennifer Reardon is considered a leading developer of custom database applications. She has over ten years’ experience developing client/server and PC-based applications. She has accumulated much of her application development experience working as lead developer for Database Creations. She has partnered with Cary Prague developing applications for many Fortune 500 companies.
Her most significant projects include a spare parts inventory control system for Pratt & Whitney’s F22 program, an engineering specifications system for ABBCombustion Engineering, and an emergency event tracking system for the State of Connecticut. She was also the lead developer of many of the Database Creations add-on software products including Business, Yes! I Can Run My Business, Check Writer, and the User Interface Construction Kit.
Table of Contents
Part I: Creating Desktop Applications.
Section I: Working with Data Tables and Queries.
Chapter 1: Understanding Data.
Chapter 2: Creating and Building Tables.
Chapter 3: Entering Data into Tables and Forms.
Chapter 4: Creating and Understanding Relationships.
Chapter 5: Displaying Selected Data with Queries.
Chapter 6: Using Operators and Expressions in Multi-table Select Queries.
Chapter 7: Working with External Data.
Section II: Building Forms and Reports.
Chapter 8: Understanding the Many Uses of Forms and Controls.
Chapter 9: Building and Manipulating Forms and Controls.
Chapter 10: Creating Bound Forms and Placing Controls.
Chapter 11: Adding Data-Validation Features to Forms.
Chapter 12: Creating Professional-Looking Forms and Reports.
Chapter 13: Understanding and Creating Reports.
Chapter 14: Working with Subforms.
Chapter 15: Creating Calculations and Summaries in Reports.
Chapter 16: Presenting Data with Special Report Types.
Chapter 17: Using OLE Objects, Graphs, Pivot Tables/Charts, and ActiveX Controls.
Section III: Automating Your Applications.
Chapter 18: Understanding Visual Basic and the VBA Editor.
Chapter 19: Introduction to Programming and Events.
Chapter 20: Working with Expressions and Functions.
Chapter 21: Working with SQL, Recordsets, and ADO.
Chapter 22: Automating, Searches, Filters, and Query Parameters.
Chapter 23: Calling Subprocedures and Functions.
Chapter 24: Effective Debugging and Error Handling in VBA.
Chapter 25: Creating Switchboards, Command Bars, Menus, Toolbars, and Dialog Boxes.
Chapter 26: Programming Continuous Forms, Tab Dialogs, and Command Buttons.
Part II: Creating Enterprise Applications.
Section IV: Upsizing to SQL Server and MSDE 2000.
Chapter 27: Upsizing Data to a SQL Server Database.
Chapter 28: Working with Access Projects.
Chapter 29: Working with Access Projects and SQL Server Tables and Queries.
Part III: Creating Web Applications.
Section V: Creating Data Access Pages and Using XML and InfoPath.
Chapter 30: Using and Creating Access Objects for Intranets and the Internet.
Chapter 31: Building and Working with Data Access Pages.
Chapter 32: XML, Access, and InfoPath.
Part IV: Advanced Access Database Topics.
Chapter 33: Exchanging Data with Office Applications.
Chapter 34: Adding Security to Applications.
Chapter 35: Creating Help Systems.
Chapter 36: Working with Advanced Select Queries and Other Query Topics.
Chapter 37: Working with Action and SQL Queries.
Chapter 38: Increasing the Speed of an Application.
Chapter 39: Preparing Your Application for Distribution.
Part V: Appendixes and Reference Material.
Appendix A: Access 2003 Specifications.
Appendix B: Access Auto Auction Tables.
Appendix C: Using the CD-ROM Included with the Book.
Appendix D: Using Standard Naming Conventions.
This handbook shines a light on the dark corners of advanced malware, both to educate as well as to spark renewed efforts against these stealthy and persistent threats. By understanding the tools being used by criminals, we can better defend our nations, our critical infrastructures and our citizens. This ebook will provide readers with a new understanding of the rapidly developing cyber threat landscape and practical insights into how they can protect their data and computing infrastructures. Download now.
CDex can extract the data directly (digital) from an Audio CD, which is generally called a CD Ripper or a CDDA utility.
Flash is quickly emerging as the preferred way to overcome the nagging performance limitations of hard disk drives. However, because flash comes at a significant price premium, outright replacement of HDDs with flash only makes sense in situations in which capacity requirements are relatively small and performance requirements are high. Learn how deployment approaches-including hybrid storage arrays, server flash, and all-flash arrays-that combine the performance of flash with the capacity of HDDs can be cost effective for a broad range of performance requirements.
- FTSenior Projects EngineerNSW
- FTTest Analyst (MS Environment) .netNSW
- FTTechnical Account Manager - MSP + CloudVIC
- FTTest Analyst (MS Environment) .netNSW
- FTTechnical Consulting ManagerNSW
- FTSenior Field Engineer - MSNSW
- FTTest EngineerVIC
- FTTest Manager - IMMEDIATE STARTNSW
- FT1st Line Support EngineerNSW
- FTR&D EngineerSA
- FTSnr Web Developer PHP/Magento/API integration into E-commerce sites. $100k+SuperNSW
- FTOS Web Applications DeveloperNSW
- FT.NET - Sitecore Developer - Melbourne - PermNSW
- FTSenior Python DeveloperNSW
- FTSenior Python Web Applications DeveloperNSW
- FT2nd Level Support EngineerNSW
- FTQuality ManagerSA
- FTSenior Python DeveloperNSW
- FTLead Software EngineerSA
- FTWeb Developer- Drupal and PHP. Exciting new position- #2 in Dev team.$100k+SuperNSW
- FTSenior E-Commerce PHP Developer- North Sydney- E-commerce Software $110kNSW
- Brocade’s Meyer appointed to OpenDaylight Project Committee
- Barracuda Networks raises free capacity of Copy.com to 15GB
- EXCLUSIVE: Cyan lays out Australian expansion plan
- EXCLUSIVE: Channel training integral to Intel smartphone/tablet growth
- Reseller network important in auxiliary sales of bookings: Expedia