Buy Using Microsoft Access 2000 by Ken Hansen at Bookstore UAE
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology > Databases > Database software > Using Microsoft Access 2000: (Using)
Using Microsoft Access 2000: (Using)

Using Microsoft Access 2000: (Using)


     0     
5
4
3
2
1



Out of Stock


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

Using Microsoft Access 2000 leads you through a quick series of chapters to get you up and running with Access and its new interface quickly, avoiding intimidation with a complex product and providing quick satisfaction. Then youll review more in-depth concepts, such as table relationships, datatypes, data entry techniques, and data access pages in real-world examples and tasks. Finish by learning complex database design strategies, interacting with a server, publishing to Web, and programming for customized applications.

Table of Contents:
I. LEARNING THE ACCESS ESSENTIALS. 1. Starting with a Properly Normalized Design. The Importance of a Good Design. Refining the Design. 2. Understanding Access Objects. What Are Objects? What Are Tables? What Are Queries? What Are Forms? What Are Reports? What Are Modules? Reviewing the Screen Object. Reviewing the DoCmd Object. Naming Conventions. 3. New User Features in Access 2000. Converting to Prior Versions. Announcing the New Database Window. Using the File Dialog Box. Enhancing the Windows Clipboard. Updating with Name AutoCorrect. Improved Conditional Formatting. Reviewing Unicode. Working with Subdatasheets. Printing the Relationships Window. Compacting Access Data on Closing. II. CREATING A DATABASE AND ITS OBJECTS. 4. Creating a Database. Getting Started. Whats a Wizard? Reviewing the Database Wizard. Documenting the Database. 5. Creating Tables. Designing Tables. Working with the Table in Design View. Assigning Table Names That Describe Their Function. Making Tables Efficient Objects Within the Database. Setting Primary Keys. Indexes. Using the Table Wizard. 6. Creating Queries. Reviewing Queries. Working with the Query Design Grid. Using the Simple Query Wizard. Using the Crosstab Query Wizard. Using the Find Duplicates Query Wizard. Using the Find Unmatched Query Wizard. 7. Creating Forms. Understanding Forms. Working in Design View. Standardizing Forms. Quickly Creating Forms with a Wizard. 8. Creating Reports. Introducing Reports. Using the Report Wizards. Viewing Reports in Design View. Setting Report Properties. Standardizing Reports. Creating a Report Template. Inserting a Chart into a Report with the Chart Wizard. Printing Your Report. 9. Creating Controls and Setting Properties. Reviewing Control Wizards. Reviewing Control Properties. The List Box Control. Using the List Box Wizard. Creating the List Box from Scratch. Working with Combo Box Controls. Using Command Button Controls. Working with the Option Group Control. III. STORING, CONTROLLING, AND MANIPULATING DATA. 10. Looking Up Values and Lists. Whats a Lookup? Using the DLookUp() Function. 11. Defining and Working with Relationships. Bringing Your Information Together. Using the Relationships Window. 12. Managing External Data. Importing and Linking. Using the Import Spreadsheet Wizard. Using the Import Text Wizard. 13. Designing and Using Queries. Creating a Sample Database for This Chapter. Creating a Select Query Without Using a Wizard. Grouping Data and Performing Calculations with Crosstab Queries. Working with Action Queries. 14. Building Parameter Queries. Setting Parameters in the Query Design Grids Criteria Section. Creating an Input Box for User-Requested Criteria. Using Wildcards in Parameters. 15. Advanced Uses for Queries. Querying Another Query. Creating a SQL Statement for a Macro RunSQL Action. Creating a SQL Statement for Use in VBA. IV. CREATING THE INTERFACE: INPUT AND OUTPUT. 16. Adding Controls to Forms and Reports. Working with the Toolbox. Working with the Grid. Inserting Controls. Positioning Controls. Sizing Controls. Selecting Multiple Controls. Working with Bound Controls. 17. Using Forms to Enter and Review Data. Working in Form View. Navigating Records. Controlling Navigation in Forms. Sorting in a Form. Searching in a Form. 18. Refining Forms: Efficient Data Entry and Beyond. Verifying Data. Forcing an Entry. Formatting Data with the Format Property. Applying Input Masks. Controlling Access. Using Expressions in Controls to Display Additional Data. Inserting Custom Controls. 19. The World of Subforms. Working with Subforms. Creating a Subform. Referring to Subforms and Their Controls. A Subform Alternative: The Tab Control. 20. Advanced Form Techniques. Working with the Form Module. Responding to Form Events. Linking Forms with VBA Code. Linking Forms with a Macro. Printing Form Data Without the Form. Reducing Data-Entry Tasks. Working with Pop-Up Forms. 21. Making Your Point with Reports. Grouping and Sorting Data. Calculating Totals with Controls. The Art of Page Numbering. Inserting Graphics. 22. Displaying Detailed Data with a Subreport. Whats a Subreport and Why Do You Need One? Adding a Subreport to an Unbound Main Report. 23. Creating Labels and Mail-Merge Documents. Using the Label Wizard. Printing Multiple Labels. Merging Access Data with Word Documents. V. AUTOMATING THE DATABASE. 24. Creating Macros. When to Use Macros. The Macro Design Window. Generating Macros with Multiple Actions. 25. Running Macros. Methods Used to Run Macros. Debugging Macros. Working with the AutoExec and AutoKeys Macros. 26. Introducing Visual Basic for Applications. When to Use VBA. Understanding Modules. The VBA Programming Environment. Using the Visual Basic Editor. 27. Programming Access with VBA. Familiarizing Yourself with the Access Applications Model. Using the Object Browser. Learning to Speak VBA. Working with Variables and Data Types. Understanding Scope. Writing Procedures. 28. Using VBA for Interactive Input. Passing Arguments to Your Code. Letting the Code Make Decisions. Displaying Information with a Message Box. Soliciting Information with Input Boxes. Looping in VBA. When Your Code Doesnt Work. 29. A Primer on ADO. The ADO Advantage. Using ADO Objects. Using Recordsets. VI. BEYOND THE DESKTOP. 30. Using Builders, Utilities, and Add-ins to Increase. Efficiency. Using the Expression Builder for Complex Expressions. Using Access Database Utilities. Database Splitter. Installing and Using Add-ins. 31. Access on the Internet. How Access and the Web Unite. Hyperlinks Within Access. Web-Publishing Basics. 32. Applying Security to the Database. Why Have Security? Securing Native Access Databases (*.mdb). Securing an Access Project. 33. Multiuser Considerations. Sharing Your Data. The Client/Server Database Environment. Performance Issues. 34. Using Access Projects. Understanding Access Projects. Comparing an Access Project and a Database. Working with a Projects Objects. Securing an Access Project. 35. Taking the Next Step. Whats a Class Module? Creating Your Own Objects. Understanding ActiveX Technology. Glossary. Index.


Best Sellers


Product Details
  • ISBN-13: 9780789716040
  • Publisher: Macmillan Computer Publishing (a Pearson Education company)
  • Publisher Imprint: Sams Publishing
  • Height: 232 mm
  • Returnable: N
  • Weight: 1213 gr
  • ISBN-10: 0789716046
  • Publisher Date: 01 Jan 1999
  • Binding: Paperback
  • Language: English
  • Series Title: Using
  • Width: 187 mm


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Using Microsoft Access 2000: (Using)
Macmillan Computer Publishing (a Pearson Education company) -
Using Microsoft Access 2000: (Using)
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.

Using Microsoft Access 2000: (Using)

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

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!