Expert One-on-one Microsoft Access Application Development

Expert One-on-one Microsoft Access Application Development

4 (4 ratings by Goodreads)
By (author) 

List price: US$39.98

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks

Description

What is this book about? If you are developing databases for your own use, the process need not be complicated. But when you build databases for clients, many of whom may not be familiar with Access or comfortable with databases in general, you have a lot more work to do. "Expert One-on-One Microsoft Access Application Development" makes that process easier. In these pages, you discover how to set up tables and relationships to ensure that the database is properly normalized. Then you write VBA code to create the connective tissue that turns a bunch of tables, queries, forms, and reports into a complete and coherent application. You also find out about the important but often inadequately documented area of Automation code, which is used to communicate with other Office applications. Over years of working with Access, the author has created some add-ins to save time when developing applications.She shows you how to use them to create a main menu for an application, automatically apply a naming convention to database objects, and ensure a consistent and professional appearance of the application's forms.
This book helps you write VBA code that unites database components into an application that works. What does this book cover? Here's what you'll discover in this book: how to build integrated Access-based applications that support multiple clients and databases; tips for streamlining application creation; maintenance required throughout an application's life cycle, including migrating data from legacy systems and upgrading Office; how to use Automation code to exchange data among Office components and even some non-Office programs; and, ways to avoid glitches when building Access applications that work with Excel, Word, and Outlook.Who is this book for? This book is for experienced Access users who are familiar with creating Access objects and writing VBA code, but who need help transitioning from competent users/programmers to full-fledged Access developers.
show more

Out of ideas for the holidays?

Visit our Gift Guides and find our recommendations on what to get friends and family during the holiday season. Shop now .

Product details

  • Paperback | 624 pages
  • 184 x 232 x 36mm | 920.79g
  • WROX PRESS
  • Indianapolis, IN, United States
  • English
  • 0764559044
  • 9780764559044
  • 2,359,878

Back cover copy

If you are developing databases for your own use, the process need not be complicated. But when you build databases for clients, many of whom may not be familiar with Access or comfortable with databases in general, you have a lot more work to do. I hope this book will make that process easier. In these pages, I will teach you how to set up tables and relationships to ensure that the database is properly normalized. Then I'll help you write VBA code to create the connective tissue that turns a bunch of tables, queries, forms, and reports into a complete and coherent application. We'll pay special attention to the important but often inadequately documented area of Automation code, which is used to communicate with other Office applications. Over years of working with Access, I've created some add-ins to save time when developing applications. I'll show you how to use them to create a main menu for an application, automatically apply a naming convention to database objects, and ensure a consistent and professional appearance of the application's forms. This book helps you write VBA code that unites database components into an application that works. What you will learn from this book How to build integrated Access-based applications that support multiple clients and databases Tips for streamlining application creation Maintenance required throughout an application's life cycle, including migrating data from legacy systems and upgrading Office How to use Automation code to exchange data among Office components and even some non-Office programs Ways to avoid glitches when building Access applications that work with Excel, Word, and Outlook Who this book is for This book is for experienced Access users who are familiar with creating Access objects and writing VBA code, but who need help transitioning from competent users/programmers to full-fledged Access developers. Wrox Expert One-On-One books present the wisdom accumulated by an experienced author who is recognized as an expert by the programming community. These experts challenge professional developers to examine their current practices in pursuit of better results.
show more

Table of contents

Acknowledgments.About the Author.Introduction.Part One: Creating an Access Application.Chapter 1: Creating a Database for an Application.Chapter 2: Using Forms to Work with Data.Chapter 3: Selecting the Right Controls for Forms.Chapter 4: Sorting and Filtering Data with Queries.Chapter 5: Using PivotTables and PivotCharts to Interact with Data.Chapter 6: Printing Data with Reports.Chapter 7: Writing VBA Code in Modules.Part Two: Modifying, Updating, and Maintaining Access Applications.Chapter 8: Managing the Application Life Cycle.Chapter 9: Reworking an Existing Application.Chapter 10: Moving Old Data into a New Database.Part Three: Working with Other Office Components (and More).Chapter 11: Working with Word.Chapter 12: Working with Outlook.Chapter 13: Working with Excel.Chapter 14: Working Outside of Office.Index.
show more

About Helen Feddema

Helen Feddema is an internationally known expert on Microsoft Access, and a regular contributor to Pinnacle's Smart Access and Office Developer journals. She edits the Woody's Access Watch e-zine and writes its "Access Archon" column. Helen's writings and seminars have been helping Access developers since the beta of Access 1.0, one of many she has tested.
show more

Rating details

4 ratings
4 out of 5 stars
5 25% (1)
4 50% (2)
3 25% (1)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X