You are previewing Pro Access 2007.
O'Reilly logo
Pro Access 2007

Book Description

Pro Access 2007M covers the features of Microsoft Access 2007, including working with SharePoint Office Server and customizing Ribbons. The book is aimed at professional developers and power users who are new to Access 2007. Among other topics, youll learn about the new Access menu structure, including customization, as well as new SharePoint features.

This book provides good, short, solid information with as little waffle as possible. And the book includes solid examples that thoroughly explain new features. Author Martin Reid is also a working Access developer who is respected by his peers and knows what working developers face, especially at the time of a new release.

What you'll learn

  • Creating custom menus using RibbonX

  • Get up and running building Visual Basic for Applications Classes

  • Learn about Microsoft Office SharePoint Server and how it fits into Access

  • Working with SQL Server and using the new Microsoft Access 2007 to SQL Server 2005 tools

  • Code examples provided to highlight real-world issues

  • Use Access and .NET to present information via the Internet

Table of Contents

  1. Title Page
  2. Dedication
  3. Contents at a Glance
  4. Contents
  5. About the Author
  6. About the Technical Reviewer
  7. Acknowledgments
  8. Introduction
    1. Who This Book Is For
    2. How This Book Is Structured
    3. Prerequisites
    4. Downloading the Code
    5. Contacting the Author
  9. CHAPTER 1: Access 2007: What's New?
    1. Access 2007 Interface
    2. Access 2007 Ribbons
    3. Access Options
    4. Access 2007 Tables
    5. Access 2007 Forms
    6. List Items
    7. Reports
    8. Macros
    9. Modules
    10. Working with SharePoint Server
    11. Security
    12. E-Mail Data Collection
    13. Summary
  10. CHAPTER 2: Text and Templates
    1. XML: A Really Brief Overview!
    2. Office XML
    3. Access Text Formats
    4. Built-in Access Templates
    5. Summary
  11. CHAPTER 3: Getting Up and Running with RibbonX
    1. Creating Your First Ribbon
    2. Adding Functionality to the Ribbon
    3. Putting Together a Simple Tab
    4. Adding VBA Callback Functions
    5. Creating Split Buttons
    6. Adding Custom Images
    7. Adding Additional Groups
    8. Removing the Built-in Ribbon Items
    9. Using Contextual Ribbons
    10. Manipulating Existing Groups and Controls
    11. Adding Other Group Controls
    12. Summary
  12. CHAPTER 4: Data Collection Using Microsoft Outlook 2007
    1. Getting Started with HTML Forms
    2. Processing the Collection
    3. Collecting Data Using an InfoPath Form
    4. Overview of the MSysDataCollection System Table
    5. Processing the Replies
    6. Populating MSysDataCollection Manually
    7. Working in Outlook
    8. Summary
  13. CHAPTER 5: Introduction to Classes in VBA
    1. Some Definitions
    2. What Is a Class?
    3. Working with Data
    4. Adding Functionality
    5. Full Code Listings for Class Examples
    6. Summary
  14. CHAPTER 6: RAD Development for SQL Server 2000/2005 Express
    1. Options When Working with SQL Server
    2. Comparing Access and SQL Server
    3. Upsizing to SQL Server 2000
    4. Upsizing to SQL Server 2005 Express
    5. Impact of Upsizing on Access Forms and Data
    6. Access Data Projects
    7. Upsizing to SQL Server Reporting Services
    8. Summary
  15. CHAPTER 7: Working with the SQL Server 2005 Express Tool Set
    1. SQL Server Express 2005 Overview
    2. SQL Server Express Security
    3. Working with Functions, Views, and Other Objects with Access 2007
    4. ADPs and SQL Server 2005 Express
    5. SQL Server Migration Assistant for Access
    6. Summary
  16. CHAPTER 8: DAO, Complex Data Types, and Macros
    1. Getting Started with DAO
    2. Access 2007 and DAO
    3. Complex Data Types
    4. New Macro Features
    5. Summary
  17. CHAPTER 9: Introduction to SharePoint Server
    1. What Is Windows SharePoint Services?
    2. Creating a Team Site
    3. Libraries, Lists, and Workspaces
    4. Summary
  18. CHAPTER 10: Access and SharePoint Applications
    1. Using WSS Lists with Access
    2. Migrating an Access Database to WSS
    3. Creating an Access View from WSS
    4. Linked Lists and VBA
    5. Working with WSS Data Offline
    6. List Management from Access
    7. Data Conflict Errors
    8. Reporting
    9. Summary
  19. CHAPTER 11: Access, SharePoint, and SharePoint Designer
    1. Getting Started: SharePoint Designer
    2. Web Parts and Workflows
    3. Summary
  20. CHAPTER 12: Getting Started with .NET Tools
    1. Creating Web Applications with Visual Web Developer 2005 Express
    2. Creating Data Grids with ASP.NET
    3. Creating the What's On Web Site
    4. Getting More Interactive
    5. Moving into Application Tiers
    6. Creating Windows Applications with Visual Basic 2005 Express
    7. Summary
  21. CHAPTER 13: Code You Can Steal!
    1. Summary
  22. APPENDIX: RibbonX and Custom Add-Ins
    1. Controlled Situation
    2. Uncontrolled Situation
    3. General UI Guidelines
    4. Summary
  23. Index