Complete Idiot's Guide to Microsoft Access 2000
Home > Computing and Information Technology > Databases > Database software > Complete Idiot's Guide to Microsoft Access 2000
Complete Idiot's Guide to Microsoft Access 2000

Complete Idiot's Guide to Microsoft Access 2000


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

Doe the thought of creating a database with Access 2000 fill you with the same dread as entering a crowded interstate? How do you maneuver through the traffic? How do you backtrack from the compound mistakes? The Complete Idiot's Guide to Microsoft Access 2000 promises a smooth course. Here, you will explore some of the new features related to queries and reports, the areas that often seem mysterious for new and casual users. You will learn the relationship between the software and the World Wide Web and be able to utilize it confidently. Pick up the book that makes Access 2000 extremely accessible--this one!

Table of Contents:
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.

About the Author :
Joe Habraken is a computer technology professional and author, with more than a dozen years of experience as and educator and consultant in the information technology field. A Microsoft Certified Professional, Joe has taught computer software seminars across the country. Currently, he serves as the lead instructor for the Networking Technologies program at Globe College in St. Paul, Minnesota. Joe's most recent book titles include The Microsoft Access 97 Exam Guide, Microsoft Office 2000 6 in 1, and Sams Teach Yourself OutlookA (R) in 10 Minutes.


Best Sellers


Product Details
  • ISBN-13: 9780789719003
  • Publisher: Dorling Kindersley Ltd
  • Publisher Imprint: Alpha
  • Height: 229 mm
  • No of Pages: 416
  • Weight: 675 gr
  • ISBN-10: 0789719002
  • Publisher Date: 11 May 1999
  • Binding: Paperback
  • Language: English
  • Spine Width: 23 mm
  • Width: 186 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Complete Idiot's Guide to Microsoft Access 2000
Dorling Kindersley Ltd -
Complete Idiot's Guide to Microsoft Access 2000
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Complete Idiot's Guide to Microsoft Access 2000

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!