Complete Idiot's Guide to Microsoft Access 2000

I. GETTING YOUR FEET WET WITH ACCESS. 1. Databases, Access, and You. The Almost Unspeakable Question: What Is a Database? Relating to Access. A Database with a View: Access Objects. Planning Your Database. 2. Putting Access Through Its Paces. One Giant Step for Humankind (Launching Microsoft Access). Opening a Database File. Taking a Look Through the Access Window. Getting to Know Your Objects. Relationships Are Where It's At. A Plea from Your Author-Spend Quality Time with Your Sample Database. Closing a Database. Signing Off-Exiting Access. 3. Help, I Need Somebody... Your Faithful Servant-The Office Assistant. Getting Help Without the Assistant. Using the Answer Wizard. Using the Index. Getting Help on the Web. II. CATCHING THE BRASS RING: CREATING DATABASES. 4. Database Creation: More Fun, Less Filling. Creating a New Database. A Walk with the Wizard. Psyching Out the Switchboard. A Database with a View. 5. Turning the Tables: Table Design. Tabling the Discussion. It's the Wonder of New: New Tables for a New Database. Fields of Dreams. The (Primary) Key to Success. Down in Front-Moving Your Field. Who Is That Masked Field? Using the Table Wizard to Design Your Database. And Now for Something Completely Different. Creating a Table in Datasheet View. 6. Going On Record: Adding and Editing Data. Working in Datasheet View. Entering Your Data. Editing Your Data. Navigating the Tossing Sea of Your Table. Saving Your Work. Adding a Field to Your Table. Adding a New Record to a Table. Where's My Record? Viewing Your Table Updates. 7. Being Manipulative: Different Ways to View Your Records. Out of Sorts. Basic Sorts of the Big Kahuna-Northwind. Sorting Out the Details (Advanced Sorts). Using Find (I'm Lost!). The World of Filter Feeders. Hiding Out (Hiding Fields in a Table). 8. Between You and Me and Access: Table Relationships. Creating Table Relationships. Viewing Related Records. The Types of Relationships. The Importance of Good Relationships. III. SO WHAT'S THE OBJECT? 9. It's All in Your Form. Creating a Form. Customizing Forms. Taking Control of the Form Controls. It's Always the Details. 10. Reforming Your Forms. Putting Your Foot(er) in Your Form. Controls Unbound. Express Yourself with the Expression Builder. Is It a Date? Adding a List Box or Combo Box to a Form. Creating the Combo Box. Adding Command Buttons to Forms. Adding a Subform to a Form. Drag and Drop to Create a Subform. Dressing Up Your Forms with Color and Borders. 11. Not a Stupid Question-Designing Simple Queries. Understanding Queries. Creating a Select Query. The Query Design Window. Doing the Math-Formulas in Queries. Expressing Yourself: Creating the Expression. Quick-Fix Statistical Queries Using the Totals Section in the Query Grid Box. 12. More Questions-Designing Advanced Queries. Creating a Query from More Than One Table. I'm Joining Up. A Good Crosstab Query Will Never Double-Cross You. Using Append and Delete Queries. A Query Well Run. Creating a Delete Query. 13. From Soup to Nuts-Creating Delicious Reports. Reporting Your Database Information. Creating a Report from One Table. Previewing the Report. Report Design View. Reports Created from Multiple Tables. 14. No Need for a Calculator- Doing Math in Reports. Placing a Total in a Report. Adding a Group Subtotal to a Report. Setting the Group Properties. 15. Pride of Ownership-Enhancing Your Reports. Adding a Subreport to a Report. Adding Page Breaks to a Report. Charting Your Course. Creating Mailing Labels. 16. All the News That's Fit to Print. It Might Look Good, But Is It Right? A Word About Reports and Your Other Database Objects. Quickly Printing a Database Object. Using the Print Dialog Box. Are You Setting Me Up? Is It Just Resting or Is It Dead? Spelling It Out. IV. EXPANDING YOUR DATABASE BRAIN POWER. 17. OLE-Taking the Bull Out of Object Linking and Embedding. What Is OLE? To Link or Embed-That Is the Question. Working in the Oil OLE Field. Insert Object Here. Have Your Object and See It, Too. Placing an Excel Chart in Access. Pasting the Excel Chart into a Report. Editing the Chart. 18. Imports and Exports-Moving and Sharing Data. You Always Externalize Everything. Freud Would Have Been Proud-Analyzing Your Table. Working with the Table Analyzer Wizard. Exporting Data from Access to Other Applications. Copycat or Cutup. OfficeLinks Is Not Corporate Golf. This Data Door Swings Both Ways. 19. Keeping Your Databases Running Smoothly. An Award-Winning Performance- The Performance Analyzer. Diagnosis and Treatment-Optimizing an Object. Other Performance Enhancers. Documenting a Database Object. A Quick Weight-Loss Plan for Your Database. My Database Has Fallen, and It Can't Get Up. Access in Intensive Care. The Care and Feeding of Your Database Files. 20. What's the Password? Choosing a Database Security Blanket. Adding a Database Password. Opening a Password-Protected Database. Assigning User Levels to a Database. Joining a Group. Using the User-Level Security Wizard. 21. The Little Engines That Can-Making Macros. Macros Revealed. Designing a Macro. Creating Macro Actions for Menu Commands. A Word About Modules. 22. Have It Your Way-Customizing Access. Adding a Button to a Toolbar. Adding a Macro to a Toolbar. Tying It On with the Toolbars. Creating a New Toolbar. Setting Options in Access. Stepping Out of the Crowd. 23. Surf's Up, Dude-Access on the Internet. Weaving a Database for the Web. Going Hyper with HTML. Exporting an Access Report to HTML. Dressing Up Your HTML Objects with Templates. Your Web Page at a Standstill-Static HTML. Creating Dynamic Web Objects in Access. A Short History Lesson. Creating a Data Access Page. Going Hyper with Hyperlinks. Access and the Global Network. Appendix A. Installing Access 2000. A Very Easy Installation. Getting a Custom Installation. Final Notes on Software Installation. Speak Like A Geek: The Complete Reference. Index.