Programming Microsoft Office Access 2003 - Softcover

Whether you’re extending an existing database or developing a complex custom solution, get the code and instruction you need to exploit the power and performance of Access 2003. The newest edition of this acclaimed reference packs even more real-world examples and best practices for writing, testing, and debugging extensible database applications. Access expert Rick Dobson shows you the most productive ways to work with the enhancements in Access 2003, including new security features, built-in XML capabilities, and interoperability with Microsoft SQL Server. You also get rich, adaptable code samples to extend the power and reach of your database solutions.

Discover how to:

• Employ ADO to access enterprise data sources, such as files on a Web server
• Design and manage tables and queries using the ADOX object library and Jet SQL * Create data forms and reports programmatically—and extend them to Microsoft SQL Server 2000
• Present data interactively with PivotTable and PivotChart dynamic views
• Program Microsoft Office objects to search for files and manipulate menus and toolbars
• Customize solutions by integrating Access with other Microsoft Office programs
• Learn techniques to help lock up proprietary code
• Explore the new Access Jet SandBox and macro security features
• Use Access to build and help safeguard SQL Server solutions
• Extend your solutions to the Web using data access pages, Office Web Components, Microsoft Office FrontPage, and XML

Rick Dobson is the author of the Microsoft Press® titles Programming Microsoft Access Version 2002 and Programming Microsoft SQL Server 2000 with Microsoft Visual Basic .NET. He is the founder and chief technologist of CAB. He has more than a dozen years’ experience delivering professional computer services and is an accomplished author, speaker, and developer. His work regularly appears in many publications, including Byte, Microsoft Office & Visual Basic for Applications Developer, DBMS, Visual Basic Developer, Microsoft Web Developer, Visual Developer, and Smart Computing. He has led training classes in the United States and abroad, teaching developers from companies including Proctor & Gamble, Bell Laboratories, and Cincinnati Gas & Electrics. CAB's offices are in Louisville, Kentucky.

Since 1999, Rick's company has sponsored its own national tour. Over the years the content of the tours has changed to reflect Rick's books as well as the most recent software releases from Microsoft. His 2002 tour was titled "The Access/SQL Server/VB.NET Development Seminar." The seminar attracts independent as well as corporate organizations such as Bank of America, Ford, DaimlerChrysler, State Farm Insurance, Prudential, EDS, the U.S. Navy, and Panasonic. These annual seminars provide Access developers, SQL Server developers, and database administrators the information they require to deliver better solutions to their clients as well as helping Visual Basic developers put Visual Basic .NET to use for database applications. For specific locations and registration for the next seminar tour, visit http://www.programmingaccess.com.