Home > Computing and Information Technology > Databases > Database software > F. Scott Barker's Microsoft Access 2002 Power Programming
14%
F. Scott Barker's Microsoft Access 2002 Power Programming

F. Scott Barker's Microsoft Access 2002 Power Programming

          
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

F. Scott Barker's Access 2002 Power Programming gives many practical techniques for the corporate and independent developer. The main topics covered are: The Root of Power Programming; Manipulating and Presenting Data; Extending Access with Interoperability; Adding the Professional Look and Distributing Applications; Managing Databases; Adding Finishing Touches. New features of Access 2002 will be covered thoroughly, including: A whole new chapter devoted to Data Pages, which is Microsoft's way of bringing the Web interface into everyday office solutions. A new chapter clarifying the confusion over ADP/MDB and DAO/ADO. Including when and where to use each. There are a number of new additions to VBA which developers will need good exposure to in order to take advantage of them. A number of changes have been implemented in the form design with control features added.

Table of Contents:
(NOTE: Each chapter concludes with a Summary.) A Letter from the Author. I. THE ROOT OF POWER PROGRAMMING. 1. Macros Are for Weenies; Code Is Cool! Understanding Where Macros End and Code Begins. Looking at Macro-to-Code Changes. Converting Existing Macros to VBA Code. 2.Coding in Access 2002 with VBA. Getting Started with Programming. Getting Started with VBA. Programming with Objects. Using Properties and Methods. Using Collections. Customizing a Form. Coding Class Modules. 3. Making Access Project and Data Technologies Choices. Using Microsoft Database Versus Access Database Project. Using DAO Versus ADO Versus XML. 4. Working with Access Collections and Objects. Creating Custom Collections. Comparing Custom Collections to Arrays. Accessing the Access Object Model. Programming Multiple Copies of the Same Form. 5. Introducing ActiveX Data Objects. Looking at ADO's Object Models. Referencing the Type Libraries. Opening a Connection to a Database. Creating a Recordset. Working with Queries. Working with Tables. 6. Using XML with Access 2002. Getting to Know XML. Working with XML with the Access User Interface. Coding with XML and VBA in Access 2002. Taking Advantage of the Other Office Applications' _XML Support. 7. Handling Your Errors in Access with VBA. Examining Access's Runtime Error Handling. Working with the Err and Error Objects. Working with the ADO Errors Collection. Creating User-Defined Errors. Using Custom Error Logs to Track Errors. Creating a Centralized Error-Handling Routine. A Last Look at Error-Handling Issues. II. MANIPULATING AND PRESENTING DATA. 8. Using Queries to Get the Most Out of Your Data. Understanding Where Queries Are Used in Access. Working with Select Queries. Working with Action Queries. Performing Advanced Query Operations. Adding More Power with VBA. Driving Reports and Forms with Queries. Solving Problems with Queries. Examining the Architecture of the Query Resolution Process. Optimizing Queries with Jet. Understanding Optimization Techniques. Using Unconventional Optimization Techniques. Using the Analyzer Wizards. Looking at Access 2002's New Query Feature. 9. Creating Powerful Forms. Increasing Form Performance. Looking at Access 2002's New Form Features. Looking at Access 2002's New Form Features. Taking Advantage of Other Form Features. Reusing Forms to Perform Standard Tasks. Increasing Tabbed Form Performance. 10 Expanding the Power of Your Forms with Controls. Setting Up a Field's Lookup Properties for Use on Forms. Tapping into the Power of Combo Boxes. Working with the Access Tab Control. Morphing Access Controls. Programming Multiselect ListBox Controls. Getting Relief with the Subform/Subreport Wizard. Giving Controls Spreadsheet-Type Cursor Movements. Manipulating Controls Through Code. 11. Creating Powerful Reports. Creating Summary, Detail, and Summary/Detail Reports _from the Same Report. Creating Dynamic Groupings for the Same Report with QBF. The Elusive Feature: Creating Snaking Reports. Printing Multiple Topics Through a MultiSelect List Box. Creating a Wizard-Like Interface for Selecting Group-By Items. Formatting Reports Dynamically. 12. Working with Data Access Pages. Why Data Access Pages? Saving Time with the Data Access Page Wizards. Creating and Enhancing Simple Data Access Pages. Grouping Data Access Pages: Reports for the Web. Finding Additional Resources. III. EXTENDING ACCESS WITH INTEROPERABILITY. 13. Driving Office Applications with Automation. Working with Automation. Running Other Applications from Access with Automation Driving Access from Another Application with Automation 14. Programming for Power with ActiveX Controls. Understanding the ActiveX Common Controls. Using the TabStrip Control. Taking a Closer Look at the ImageList Control. Emulating the Windows Explorer with the ListView Control. Displaying a Task's Progress with the ProgressBar Control. Sizing Text Boxes at Runtime with the Slider Control. Telling It Like It Is with the Rich Textbox Control. Creating Status Bars for Individual Forms with the _StatusBar Control. Docking Toolbars on Forms Using the _ToolBar Control. Viewing Data File Manager Style with the TreeView Control. 15. Extending the Power of Access with API Calls. Understanding Dynamic Link Libraries. Examining the Syntax for API Calls. Finding API Declarations. Viewing the Possible API Calls. Considering Some Issues When Using API Calls. Looking at Some Examples of API Calls. Displaying Pertinent Folders from Within Your Application. Using the Open File Dialog API Call. 16. Extending Your VBA Library Power with Class _Modules and Collections. Setting Up a Bookmark Tracker. Managing Multiple Instances of the Same Form. 17. Creating Your Own Wizards and Add-ins. Understanding Access Wizards, Builders, and Add-Ins. Looking at the Wizards and Add-In Registry Entries. Creating Your Own Add-Ins. Using Access Code Libraries. 18. Manipulating the Registry with VBA. Looking at the Windows Registry's History. Using VBA's Registry Commands. Performing Tasks with Registry API Calls. 19. Using Access with the Internet.What's New in Access 2002 for the Internet? Using the Access Hyperlink Features. Easily Importing and Exporting Access Objects to _HTML Documents. Publishing to Other Web File Formats. IV. MANAGING DATABASES. 20. Securing Your Application. Understanding the Purpose of Securing Applications. Understanding Access Security. Looking at the Security User Interface. Making Life Easier with Access Security Tools. Avoiding Common Pitfalls Found in Access Security. Managing Security Through Code. Using the Secured Sample Database: Chap20s.mdb. 21. Handling Multiuser Situations. Understanding Multiuser Terminology. Understanding Multiuser Handling in Access. One or Two Database Containers: Knowing Where to _Put the Pieces. Looking at the Built-In Locking Modes. Working in VBA with Unbound Forms. Coding for Multiuser Error Handling. 22. Welcome to the World of Database Replication. Understanding Database Replication Concepts. Working with Jet Replication Tools. Converting Databases to Replicas. Synchronizing Replicas. Understanding Replica Set Topologies. Distributing Replicable Applications. Replicating Back-End and Front-End Applications. Handling Replication Conflicts. Understanding Replication Synchronizers. Upgrading Replica Sets to Access 200x. Securing Replicated Applications . Using MDE Files with Replicated Databases. Creating Successful Replication Applications. 23. Moving Workgroup Applications to Client/Server. Understanding Client/Server/. Factoring for Client/Server Migration. Planning for Client/Server. Knowing What to Watch for in Application Development. Converting Existing Applications. Distributing a Client/Server Solution. Keeping Certain Issues in Mind with Access and SQL Server. 24. Developing SQL Server Projects Using ADPs. Understanding Project File Architecture. Working with Projects. Building a Client/Server Application. Working with Views. Working with Stored Procedures. V. ADDING FINISHING TOUCHES. 25. Startup Checking System Routines Using ADO. Performing Startup System Checks. Setting and Retrieving System Settings. Notifying and Logging Users Out of an Application. Testing Table Links at Startup. Testing and Repairing Corrupted Jet Back-End Databases. Checking and Notifying Users of a New Version. 26. Creating Maintenance Routines. Creating an Export Dialog to Export Tables. Compacting and Repairing the Back End on Demand. Creating a Generic Code Table Editor. Replicating Tables from Back End to Front End for _Better Performance. Index.


Best Sellers


Product Details
  • ISBN-13: 9780672321023
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Sams Publishing
  • Height: 232 mm
  • No of Pages: 960
  • Series Title: Sams White Books
  • Weight: 1545 gr
  • ISBN-10: 0672321025
  • Publisher Date: 26 Sep 2001
  • Binding: Paperback
  • Language: English
  • Returnable: N
  • Spine Width: 50 mm
  • Width: 186 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
F. Scott Barker's Microsoft Access 2002 Power Programming
Pearson Education (US) -
F. Scott Barker's Microsoft Access 2002 Power Programming
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.

F. Scott Barker's Microsoft Access 2002 Power Programming

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