Home > Computing and Information Technology > Databases > Database software > Microsoft Access 2000 Development Unleashed
Microsoft Access 2000 Development Unleashed

Microsoft Access 2000 Development Unleashed

          
5
4
3
2
1

Out of Stock


Premium quality
Premium quality
Bookswagon upholds the quality by delivering untarnished books. Quality, services and satisfaction are everything for us!
Easy Return
Easy return
Not satisfied with this product! Keep it in original condition and packaging to avail easy return policy.
Certified product
Certified product
First impression is the last impression! Address the book’s certification page, ISBN, publisher’s name, copyright page and print quality.
Secure Checkout
Secure checkout
Security at its finest! Login, browse, purchase and pay, every step is safe and secured.
Money back guarantee
Money-back guarantee:
It’s all about customers! For any kind of bad experience with the product, get your actual amount back after returning the product.
On time delivery
On-time delivery
At your doorstep on time! Get this book delivered without any delay.
Notify me when this book is in stock
Add to Wishlist

About the Book

Access 2000 Unleashed provides the experienced Access user with information needed for high-end enterprise applications. This includes both Jet engine multi-user applications and SQL Server enterprise applications. This book will strengthen your existing Access knowledge and move you to a professional level of development. Written by respected Access professionals, this book also provides real world examples for business solutions and advice from years of working experience. Topics include: Database Design; Data Access; VBA; Access Client/Server; User Interfaces; Interoperability; Multi-User Issues; and Web Publishing with Access 2000.

Table of Contents:
I. DATABASE DESIGN UNLEASHED. 1. What's New For Developers In Access 2000. New User Interface. Changes to the VBE. Data Access Pages. Subdatasheets. Name AutoCorrect. ADO Is the Default Data Access Method. Online Collaboration. Access as a Front-End to SQL Server. Summary. 2. Planning The Development Process. Gathering Requirements. Architecture. Development Planning. Construction. Summary. 3. Database Design And Normalization. Relational Database Management Systems (RDBMS). The Relational Design Theory. Summary. 4. Advanced Queries. Understanding Queries in Access 2000. Creating Advanced Queries. Using the Query Object. Understanding Query Properties. Understanding the QBE Grid. Understanding the Table Pane. Understanding the Query Grid. Mastering Totals Queries. Using Crosstab Queries. Using Parameter Queries. Understanding Pass-Through Queries. Understanding Data Definition Queries. Optimizing Queries. Summary. 5. The Microsoft Jet Database Engine 4.0. The History of Microsoft Jet. Using the New Jet 4.0 Features in Your Applications. Summary. II. DATA ACCESS. 6. Introduction To ActiveX Data Objects. History of Data Access. Microsoft's Universal Data Access Initiative. ActiveX Data Objects (ADO). The ADO Object Model. ADO Recordset Object. The Error Object. Moving from DAO to ADO. The ADO Object Model Compared to DAO. Summary. 7. Advanced ADO. Using the OLE DB Provider for Jet in Access 2000. Accessing Nonrelational Data with ADO. Advanced Data Manipulation with ADO. Data Definition with ADOx. Summary. III. USER INTERFACES UNLEASHED. 8. Advanced Form Design. Form Properties. Access Form Controls. Summary. 9. Enhancing Forms With ActiveX Controls. How to Use ActiveX Controls. Using ActiveX Controls. 21. ActiveX Controls. Distributing ActiveX Controls. Summary. 10. Reporting Unleashed. Approaching Reports. Understanding the Architecture of Access Reports. Building a Single Table Report Using the Report Wizard. Customizing Reports. Working with Subreports. Creating Simple Mailing Labels. Publishing a Report. Modifying a Report at Runtime. Building Reports Programmatically. Tips and Tricks. Summary. IV. VBA UNLEASHED. 11. Creating Objects With Class Modules. Exploring the Benefits of Using Objects. Reviewing Objects, Properties, and Methods. Creating Classes. Creating Properties. Creating Methods. Creating Events. Using Objects. Creating Multiple Instances of an Object. Examining More Object Examples. Implementing an Error Handler Object. Using Objects with VBA Collections. Summary. 12. Debugging Access Applications. Eliminating Logic Errors. Working with the Visual Basic Development Environment (IDE). Working with the Debug Object. Using the Immediate Window. Using the Debugger. Using Conditional Compilation. Application Testing. Practice Debugging Techniques. Summary. 13. Professional Error Handling. Eliminating Syntax Errors. Eliminating Logic Errors. Eliminating Runtime Errors. Errors in Various Applications. Error Handling With Nested Procedures. Advanced Error Topics. Summary. 14. Application Optimization. Strengthening the Foundation: Hardware and Windows \tOptimization. Installing the Application for Optimal Performance. Optimizing the Configuration of the Jet Database Engine. Tools to Measure Performance. Looking Behind the Scenes. Optimizing the Database from the Start. Boosting Query Performance. Increasing the Speed of Queries. Getting Your Forms to Run Faster. Writing Fast Code. Summary. V. ACCESS CLIENT/SERVER. 15. Introducing Access Data Projects And The Visual Tools. Introducing Access Data Projects. Using ADPs. Working with ADPs and Existing SQL Server Databases. Creating a Project Based on a New Database. Summary. 16. Developing Access Front-Ends To Microsoft SQL Server. Client/Server Architecture: OLE DB Versus ODBC. Setting Up Your SQL Server Front-End Connection. Stored Procedures and SQL Pass-Through Queries. Reporting Against SQL Server in Access 2000. Using Forms in Your Application. Advanced Features of the SQL Server OLE DB Provider. Executing Commands with Parameters. Using a Connection Class. Summary. 17. Access 2000 Front-Ends to Oracle. Accessing Oracle Data with Access. Functions in Oracle Versus Access. Understanding Views and Stored Procedures. Creating an Unbound Interface to Oracle. Summary. VI. INTEROPERABILITY. 18. Using ActiveX Automation. What Is ActiveX Automation? Why Use Automation? Distinguishing Automation Server Versus Automation Client. Determining Automation Resource Requirements. Understanding the Big Picture. Creating and Setting a Reference to Another Application. Assigning an Object Variable to an Application. Creating an Instance of the Application. Using the Automation Object's Properties and Methods. Releasing the Automation Object. Putting It All Together. Closing the Automation Server Application. Using the UserControl Property to Determine How an \tApplication Was Opened. Using WithEvents to Expose Events of the Automation Server. Using the Automation Tips and Techniques. Summary. 19. Integration With Office 2000. Why Integrate with Office 2000? Using the Right Tool. VBA Everywhere. Using the Macro Recorder to Write Code. Using Auto Macros. Microsoft Forms. Object Browser. Class Arguments for Office Applications. Automation Example. Automating Word. Automating Excel. Automating PowerPoint. Automating Outlook. Automating Graph. Automating MapPoint. Automating FrontPage. Automating Binder. Securing Documents, Templates, and Code. Summary. 20. Using Visual Basic With Access. Creating ActiveX Code Components. Creating ActiveX Controls. Summary. VII. MULTIUSER ISSUES. 21. Multiuser Issues/File Server/Locking. Contention. Configuration. Access and Jet Locking. Oracle/SQL Server Locking. Summary. 22. Replication and JRO. When to Use Replication. When Not to Use Replication. Making a Database Replicable. Replication Using the Briefcase. Using the Access User Interface. Jet and Replication Objects Model. JRO Properties and Methods Explained. Replica Objects. Filters Collection. Summary. 23. Security. Elements of Security. Workgroup Creation. Users and Groups. Security Implementation Using Startup Options. Security Concerns with Replication. Security for Split Databases. Security for Client/Server. Securing a Database Step by Step. Common Security Errors. VIII. WEB PUBLISHING WITH ACCESS 2000. 24. Configuring A Web Site For Web Publishing. Development Versus Production Environment. Choosing Your Platform. What Is the Option Pack? Setting Up Your Web Server. Managing and Configuring Your Web Server. Securing Your Web Applications. What Is the Difference Between a Site and a Virtual Directory? Summary. 25. Web Enabling Access 2000 With Office Web Components. What Are the Office 2000 Web Components? Using the Office Spreadsheet Control. Using the Office Chart Control. Using the Office PivotTable Control. Summary. 26. Using Data Access Pages. Creating Your First Data Access Page. Implementing Interactive Drill-Downs. Incorporating the Office Web Components with DAPs. Scripting Data Access Pages. Summary. 27. Web Publishing With Access 2000 and Active Server Pages. Using Active Server Pages. Understanding Active Server Pages. Getting Started with Active Server Pages. Active Server Pages 101. Real-Life Example: Establishing a Self Maintaining \tMembership-Based Web Page. Access 2000 Web Publishing with XML. Creating Charts with the Chart Control. Summary. Appendix A. References For Further Reading. Recommended Books. Online Resources. Index.


Best Sellers


Product Details
  • ISBN-13: 9780672312915
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Sams Publishing
  • Height: 231 mm
  • No of Pages: 912
  • Weight: 1494 gr
  • ISBN-10: 0672312913
  • Publisher Date: 22 Jul 1999
  • Binding: SA
  • Language: English
  • Spine Width: 50 mm
  • Width: 187 mm


Similar Products

How would you rate your experience shopping for books on Bookswagon?

Add Photo
Add Photo

Customer Reviews

REVIEWS           
Click Here To Be The First to Review this Product
Microsoft Access 2000 Development Unleashed
Pearson Education (US) -
Microsoft Access 2000 Development Unleashed
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.

Microsoft Access 2000 Development Unleashed

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!
    ASK VIDYA