Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills

Bob Schneider9780321245458, 0321245458

Millions of people use Microsoft Access, but only a small fraction of them are really comfortable with it. If you’re ready to go “beyond the wizards”and become a confident, highly effective Access userHands-On Microsoft Access was written for you.In plain English, Bob Schneider helps you master crucial principles for building flexible, powerful databases. Discover how to enter data more easily, retrieve it more freely, manipulate it more successfully, analyze it with greater sophistication, and share it more effectively. Schneider’s dozens of hands-on examples thoroughly demystify Access, and his friendly, conversational style makes it more approachable than ever before.Hands-On Microsoft Access presents solutions for the challenges you’re most likely to encounter, includingHow do Access objects and interfaces fit together, and when should I use each one?What’s the best way for me to organize my fields into tables?How can I modify the tables, forms, and reports an Access wizard created for me?How can I design forms and reports for people to use more effectively?How do primary keys and relationships work, and why are they so important?How do I make sure my data stays consistent and accurate?How do I build queries that give me the right informationquickly, efficiently, and reliably?How do I use data from other sources, or deliver Access data to other people or programs?What are PivotTables and PivotCharts, what can I do with them, and how do I use them?Written for Access 2003, this book also contains special instructions for Access 2002 users and extensive coverage of issues relevant to Access 95, 97, and 2000.