Book 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 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 UI 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
- Copyright
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Preface
- I. Introduction
-
II. Defining the Database Schema
-
2. Defining and Relating Tables
- 2.1. Considering Design Practices
- 2.2. Designing the Tables
- 2.3. Viewing the Relationships
- 2.4. Summary
- 3. Using Data Macros
-
4. Designing Queries
- 4.1. Creating Select Queries
- 4.2. Creating Action Queries
- 4.3. Creating a Crosstab Query
- 4.4. Summary
- 5. Creating PivotTables
-
2. Defining and Relating Tables
-
III. Creating Forms and Reports
- 6. Standard Forms
-
7. Creating a CheckOut Form
- 7.1. Implementing a Customer Search Feature
- 7.2. Providing a CheckOut Feature
- 7.3. Testing the Application
- 7.4. Summary
-
8. Creating a Customer Admin Form
- 8.1. Building the Customer Profile Tab
- 8.2. Building the Items on Loan Tab
- 8.3. Building the Loan History Tab
- 8.4. Summary
- 9. Enhancing Product Administration
- 10. Enhancing the User Experience
- 11. Branding with Themes and Styles
-
12. Reports
- 12.1. Exploring Access Reports
- 12.2. Creating a Simple Report
- 12.3. Creating the AllLoans Report
- 12.4. Creating a CheckOut Report
- 12.5. Generating InventoryItem Labels
- 12.6. Auto-Generating a DailyLoans Report
- 12.7. Summary
-
IV. Multiuser Considerations
- 13. Upsizing
- 14. Distributing the Application
-
15. Publishing to the Web
- 15.1. Preparing to Publish
- 15.2. Publishing the Access Database
- 15.3. Creating Web Forms
- 15.4. Adding an Item Web Form
- 15.5. Summary
-
V. Advanced Topics
- 16. Integrating Outlook
- 17. Using External Data
- 18. Miscellaneous Features
- 19. Security
- A. Northwind Web Database
Product information
- Title: Pro Access 2010 Development
- Author(s):
- Release date: June 2011
- Publisher(s): Apress
- ISBN: 9781430235781
You might also like
book
Pro Access 2007
Pro Access 2007M covers the features of Microsoft Access 2007, including working with SharePoint Office Server …
book
Alison Balter’s Mastering Microsoft® Office Access 2007 Development
Microsoft Office 2007 is a major upgrade from the last version of Office; Access will also …
book
Microsoft® Access® 2010 In Depth
Access 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their …
book
Microsoft® Access® 2010 Inside Out
You're beyond the basics, so dive right in and really put your database skills to work! …