Buying Options
Fixing Access Annoyances
Print $19.99
Add to Cart
Print+Ebook $21.99
Add to Cart
Ebook $15.99
(PDF)
Add to Cart
Safari Books Online
Add to Cart
What is this?
Print £15.50
Add to Cart
What is this?
Description
Access is one of the easier and more flexible database management solutions for organizing data. You could grab other books for help, but do they solve problems from page one? Meet a book of a different stripe where newcomers start off right and learn valuable methods for building databases while seasoned pros gain efficiency. Fixing Access Annoyances saves time and bouts of hair pulling.
Full Description
Table of Contents
  1. Chapter 0 Access Basics

    1. The Database Window

    2. Wizards

    3. Design View and User Views

    4. Setting Properties

    5. Bound Versus Unbound Objects

    6. Multi-User Databases and Split Design

    7. How to Create an Event Procedure

    8. How to Add Code to Your Application

    9. DAO Versus ADO

  2. Chapter 1 General Annoyances

    1. CUSTOMIZING ACCESS

    2. ACCESS RUNS AMOK

    3. ERROR MESSAGES

  3. Chapter 2 Performance, Versions, Security, and Deployment

    1. PERFORMANCE

    2. VERSIONS, UPGRADES, AND CONVERSION

    3. SECURITY

    4. ENTERPRISE DEPLOYMENT AND NETWORKED DATABASES

  4. Chapter 3 Data, Tables, and Database Design

    1. DATABASE DESIGN AND DATA INTEGRITY

    2. IMPORTING, LINKING, AND EXPORTING DATA

  5. Chapter 4 Queries

    1. QUERY BASICS

    2. QUERY MISFIRES

    3. PARAMETER AND CROSSTAB QUERIES

    4. TECHNIQUES FOR DIFFICULT QUERIES

  6. Chapter 5 Forms

    1. WORKING IN DESIGN VIEW

    2. FORM DESIGN

    3. CREATE FORMS YOUR USERS WILL LOVE

  7. Chapter 6 Reports, Mailing Labels, and Charts

    1. GENERAL REPORT ANNOYANCES

    2. PAGE LAYOUT AND PRINTING

    3. SORTING, GROUPING, AND SUBREPORTS

    4. MAILING LABELS

    5. CHARTS AND GRAPHS

  8. Chapter 7 Expressions, Macros, Code Modules, and Custom Controls

    1. EXPRESSIONS

    2. MACROS AND CODE MODULES

    3. CUSTOM CONTROLS AND EXTERNAL APPLICATIONS

  1. Appendix A Appendix

    1. Installation Checklist

    2. Access Newsgroups

    3. Visual Basic Functions

    4. Macro Actions

    5. Events

  2. Glossary

  3. About the Authors

  4. Colophon

View Full Table of Contents
Product Details
Title:
Fixing Access Annoyances
By:
Phil Mitchell, Evan Callahan
Publisher:
O'Reilly Media
Formats:
  • Print
  • Ebook
  • Safari Books Online
Print Release:
February 2006
Ebook Release:
June 2009
Pages:
384
Print ISBN:
978-0-596-00852-9
| ISBN 10:
0-596-00852-X
Ebook ISBN:
978-0-596-10521-1
| ISBN 10:
0-596-10521-5
Customer Reviews
About the Authors
  1. Phil Mitchell

    Phil Mitchell is an Access wiz and instructor. He's been a software developer for a dozen years, focusing on data modeling and developing database applications. He also has a Ph.D. in cognitive psychology and a passion for design usability.

    View Phil Mitchell's full profile page.

  2. Evan Callahan

    Evan Callahan is President of Callahan Software Solutions, a consultancy focusing on database and other software solutions and technical communications. Clients have included Microsoft, General Dynamics, Online Training Solutions, and a variety of accounting, real estate, and environmental firms. He is the author of "Troubleshooting Your Web Page" and "Microsoft Access Visual Basic for Applications Step by Step", published by Microsoft Press. Evan worked for Microsoft Corporation from 1989 to 1995, where he created documentation and sample applications for Microsoft Access and Visual Basic. His background includes extensive experience in database design, technical communications, web-based marketing, and management.

    View Evan Callahan's full profile page.

Colophon

The cover fonts are Myriad and Myriad Pro. The text and heading fonts are Linotype Birka and Adobe Myriad Condensed; the sidebar font is Adobe Syntax; and the code font is LucasFont's TheSans Mono Condensed.

  • Book cover of Fixing Access Annoyances