|
Programming Office Access 2003 Core Reference
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
CONTENTS:
Data access models
The ADOX library
Jet SQL, the ADOX library, & queries
Forms & controls
Reports & data
Using PivotTables & PivotCharts
Office objects
Database security
Using Access to build SQL server solutions
Access does the web
XML & Access
|
