Apress

Pro Access 2010 Development

By Mark Collins

Pro Access 2010 Development Cover Image

Pro Access 2010 Development is a fundamental resource for developing business applications that take advantage of the features of Access 2010. You'll learn how to build database applications, create Web-based databases, develop macros and VBA tools for Access applications, integrate Access with SharePoint, and much more.

Full Description

  • ISBN13: 978-1-4302-3578-1
  • 604 Pages
  • User Level: Intermediate to Advanced
  • Publication Date: June 13, 2011
  • Available eBook Formats: EPUB, MOBI, PDF
  • Print Book Price: $44.99
  • eBook Price: $31.99
Buy eBook Buy Print Book Add to Wishlist

Related Titles

Full Description

Pro Access 2010 Development is a fundamental resource for developing business applications that take advantage of the features of Access 2010 and the many sources of data available to your business. In this book, you'll learn how to build database applications, create Web-based databases, develop macros and Visual Basic for Applications (VBA) tools for Access applications, integrate Access with SharePoint and other business systems, and much more.

Using a practical, hands-on approach, this book will take you through all the facets of developing Access-based solutions, such as data modeling, complex form development, and user interface customizations. You'll then deploy your solution to the web and integrate it with other external data sources. This book is full of handy tricks to help you get the most out of what Access has to offer, including its comprehensive set of features and tools for collecting, using, and acting on business data, whether your data is in Access or stored on another platform. You'll also see how to smoothly integrate your applications with SQL Server databases and other Office programs, such as Outlook.

What you’ll learn

  • How to build business applications that integrate local data, web-generated data, and data available from SQL Server and other sources
  • How to develop VBA routines and macros to enhance the automation of your database
  • How to deploy databases to your users and "web-ify" your application for access from anywhere
  • How to secure access to your data and maintain its integrity
  • How to integrate Access with SharePoint and other business applications

Who this book is for

This book is for intermediate to advanced Access developers who want to get up to speed with the new features available in Access 2010. Experienced Access users who want to begin developing code-based applications and project solutions in Access will also find this book useful.

Table of Contents

Table of Contents

  1. Introduction
  2. Defining and Relating Tables
  3. Using Data Macros
  4. Designing Queries
  5. Creating PivotTables
  6. Standard Forms
  7. Creating a CheckOut Form
  8. Creating a Customer Admin Form 
  9. Enhancing Product Administration
  10. Enhancing the User Experience
  11. Branding with Themes and Styles 
  12. Reports
  13. Upsizing
  14. Distributing the Application
  15. Publishing to the Web
  16. Integrating Outlook
  17. Using External Data
  18. Miscellaneous Features
  19. Security 
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

If you think that you've found an error in this book, please let us know about it. You will find any confirmed erratum below, so you can check if your concern has already been addressed.

* Required Fields

On page Macro chapter:
We cannot get the macro to work properly from the source code. There are errors througout with the mispelling of "meda" which should read "medial" and then the over due fees do not calculate correctly in chapter 3

On page 36:
clicking "finish" in the lookup wizard, i'm getting message to save before relationships created. But after clicking yes i get two errors
"You can't modify the structure of table 'Item', because it is already in use by other person or process."
and
"Microsoft Access couldn't launch the Lookup Wizard, or this wizard has been disabled. ..."
Regarding first message, i tried restarting access and ever the computer but did not help.
Regarding second message i checked in my add-ins, and the wizard add-in is always active.