Programming Microsoft® Office Access 2003 (Core Reference) (Pro-Developer)

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