Short description
This manual covers information from creating a database to publishing it on the Web. It describes building and working with a database, maintaining it, building tables and making queries, creating reports, and using Access 2000's many wizards and shortcuts.
Long description
Being a normal human being, you probably have work to do. In fact, you may have lots of work piled precariously around your office or even stretching onto the Internet. Someone, possibly your boss, suggested that Access 2000 may help you get more done in less time, eliminate the piles, and generally make the safety inspector happy. But if you're confused instead of organized, befuddled instead of productive, or just completely lost on the whole database thing, Access 2000 For Windows For Dummies is the book for you. You don't need to be a nerd to get the most out of Access 2000 For Windows For Dummies. If you know the basics of Windows 95, 98, or NT (whichever one you use) and have a desire to work with databases, you're ready to go. Everything you need to know is right here, just waiting for you to read it. Each part of Access 2000 For Windows For Dummies covers a general topic of Access 2000. Right off the bat, this book answers the lyrical question It's a data-what? By starting with an overview of both database concepts in general and Access 2000 in particular, this book provides the information you need to make sense of the whole database concept. Y ou'll also gain insight into Solving problems with Access 2000 Designing, building, using, changing, and generally coexisting in the same room with Access 2000 tables Using the Access 200 queries to unearth the answers you know are hiding somewhere in your data Committing your database to paper Doing stuff faster and seeking assistance from the wizards. You'll even venture into a bit of programming Now nothing's left to hold you back from the wonders of Access 2000. Cleave tightly to Access 2000 For Windows For Dummies, consign the Microsoft manuals to a suitable dark hole, and dive into Access 2000. Bon Voyage!
Review
Get total access to the power of database computing with the clear explanations and friendly expert advice you’ll find in Access 2000 For Windows For Dummies. Whether you’re looking for a plain-English description of database basics or the lowdown on Access 2000’s exciting new Web-based features, this superbly organized (and brilliantly written) reference gives you all the Access you need.
Discover how databases, tables, queries, and reports really work as you design powerful relational databases with Access 2000’s new tools and database guru John Kaufeld’s insider tips and tricks. Take advantage of Access 2000’s new Web-ready built-ins, and turn your database into an Internet or intranet information resource. Build a multilevel, multiuser database that gives colleagues and coworkers "snapshot" access to reports, even when they don’t have Access 2000 loaded on their PCs. Use the ready-made Wizards to automate database design and data entry; and save time and effort by recycling existing reports and forms or by importing data from other programs in the Office 2000 suite.
All this -- and more -- is packed between the covers of Access 2000 For Windows For Dummies. If you’re upgrading to the newest version of Access or discovering the joys of databases for the first time, this is the book for you.
Table of contents
- Introduction. PART I: Which Came First: The Data or the Base? Chapter 1: The 37-Minute Overview. Chapter 2: Finding Your Way Around like a Native. Chapter 3: Calling the Online St. Bernard and Other Forms of Help. PART II: Truly Tempting Tables. Chapter 4: Designing and Building a Home for Your Data. Chapter 5: Relationships, Keys, and Indexes (And Why You Really Do Care). Chapter 6: New Data, Old Data, and Data in Need of Repair. Chapter 7: Making Your Table Think with Formats, Masks, and Validations. Chapter 8: Making Your Datasheets Dance. Chapter 9: Table Remodeling Tips for the Do-It-Yourselfer. PART III: Finding the Ultimate Answer to Everything (Well, Not Everything). Chapter 10: Quick Searches: Find, Filter, and Sort. Chapter 11: Pose a Simple Query, Get 10,000 Answers. Chapter 12: Searching a Slew of Tables. Chapter 13: Lions AND Bears OR Tigers? Oh, My! Chapter 14: Teaching Queries to Think and Count. Chapter 15: Calculating Your Way to Fame and Fortune. Chapter 16: Automated Editing for Big Changes. PART IV: Turning Your Table into a Book. Chapter 17: AutoReport: Like the Model-T, It's Clunky but It Runs. Chapter 18: Wizardly Help with Labels, Charts, and Multilevel Reports. Chapter 19: It's Amazing What a Little Formatting Can Do. Chapter 20: Headers and Footers for Groups, Pages, and Even (Egad) Whole Reports. PART V: Wizards, Forms, and Other Mystical Stuff. Chapter 21: Spinning Your Data into (And onto) the Web. Chapter 22: Making Forms That Look Cool and Work Great. Chapter 23: If Love Is Universal, Why Can't I Export to It? Chapter 24: The Analyzer: Your Data's Dr. Freud, Dr. Watson, and Dr. Jekyll. PART VI: The Part of Tens. Chapter 25: Ten Timesaving Keyboard Shortcuts. Chapter 26: Ten Common Crises and How to Survive Them. Chapter 27: Ten Tips from the Database Nerds. Index. Book Registration Information.