Expert One-on-One Microsoft Access Application Development (with source code)

If you are developing databases for your own use, you may not mind opening forms or printing reports directly from the database window, and you know what query to run before printing which report or exporting data to Word. However, if you are planning to create applications for the use of others, particularly for clients who aren’t familiar with Access, and don’t understand databases in general, you have to do a lot more work, mostly in the form of writing VBA code to automate the application’s processes.

As a rule of thumb, it’s generally true that the easier the application is for the end user, the harder (and more time-consuming) it is to develop. In this book I concentrate on teaching you how to set up your tables and relationships to ensure that the database is properly normalized, and write VBA code to create the connective tissue that turns a bunch of tables, queries, forms and reports into a complete and coherent application.

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.

The book is divided into three parts, each centered around a separate case application. The first shows best methods for building a relatively simple Access application using the developer's own data. The next section shows how to build a distributed application serving multiple clients and types of data. The chapters in this section cover each step in the application lifecycle — from gathering application requirements from clients to migrating data from legacy systems to the new Access database system.

The last section of the book shows how to build Access applications that work with other Office applications, inlcuding Word, Excel, and Outlook, as well as non-Office applications. These integration issues cover some of the thorniest problems an Access developer will face. Feddema's years of experience as an author, consultant, and trainer ensure that she can provide highly original solutions and workarounds.

TABLE OF CONTENT:
Chapter 01 - Creating a Database for an Application
Chapter 02 - Using Forms to Work with Data
Chapter 03 - Selecting the Right Controls for Forms
Chapter 04 - Sorting and Filtering Data with Queries
Chapter 05 - Using PivotTables and PivotCharts to Interact with Data
Chapter 06 - Printing Data with Reports
Chapter 07 - Writing VBA Code in Modules
Chapter 08 - Managing the Application Life Cycle
Chapter 09 - Reworking an Existing Application
Chapter 10 - Moving Old Data into a New Database
Chapter 11 - Working with Word
Chapter 12 - Working with Outlook
Chapter 13 - Working with Excel
Chapter 14 - Working Outside of Office

Download here

Password:ganelon