Expert One-on-One Microsoft Access Application Development

4 avg rating
( 2 ratings by Goodreads )
 
9780764559044: Expert One-on-One Microsoft Access Application Development

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.

"synopsis" may belong to another edition of this title.

From the Back Cover:

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.

About the Author:

Access so now dig into Version 2002 and really put your databases to work! This award-winning, supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and handy workarounds in concise, fast-answer format it s all muscle and no fluff. Discover the best and fastest ways to perform everyday tasks, and challenge yourself to new levels of Access.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Helen Feddema
Published by Wrox (2004)
ISBN 10: 0764559044 ISBN 13: 9780764559044
New Paperback Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Wrox, 2004. Paperback. Book Condition: New. 1. Bookseller Inventory # DADAX0764559044

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 29.30
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

2.

Feddema, Helen
Published by Wrox (2004)
ISBN 10: 0764559044 ISBN 13: 9780764559044
New Paperback Quantity Available: 2
Seller
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description Wrox, 2004. Paperback. Book Condition: New. Bookseller Inventory # P110764559044

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 44.98
Convert Currency

Add to Basket

Shipping: US$ 2.99
Within U.S.A.
Destination, Rates & Speeds

3.

Helen Feddema
ISBN 10: 0764559044 ISBN 13: 9780764559044
New Quantity Available: 1
Seller
Castle Rock
(Pittsford, NY, U.S.A.)
Rating
[?]

Book Description Book Condition: Brand New. Book Condition: Brand New. Bookseller Inventory # 97807645590441.0

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 44.78
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

4.

Feddema, Helen
Published by Wrox
ISBN 10: 0764559044 ISBN 13: 9780764559044
New PAPERBACK Quantity Available: 1
Seller
Cloud 9 Books
(Wellington, FL, U.S.A.)
Rating
[?]

Book Description Wrox. PAPERBACK. Book Condition: New. 0764559044 New Condition. Bookseller Inventory # NEW6.0411105

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 59.99
Convert Currency

Add to Basket

Shipping: US$ 4.99
Within U.S.A.
Destination, Rates & Speeds