close menu
Bookswagon-24x7 online bookstore
close menu
My Account
Home > Computing and Information Technology > Databases > Access 2002 Programming by Example
Access 2002 Programming by Example

Access 2002 Programming by Example

          
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
X

About the Book

Microsoft Access provides a comprehensive platform that makes it easy to design, build and manage database solutions. This manual teaches programmers to start writing programs using Microsoft Access 2002 development concepts through hands-on examples. It provides practical solutions for pitfalls that are experienced by programmers who are new to Access, and should bring the reader up to an intermediate level of proficiency. It is written by an experienced developer and Access teacher.

Table of Contents:
(NOTE: Each chapter concludes with a What's Next? section.) Introduction. Why By Example? What This Book Should Accomplish. What I Assume You Know. What I Assume You Dont Know. Source Files and How to Access Them. Conventions Used Throughout the Book. I. TABLES AND QUERIES. 1. Planning and Designing Your Access Database. Consider Your Data Before Designing Your Database. Why Relational Tables? Database Design and Normalization. Normalizing in Access. 2. Joins and Cascades. Cascades. 3. The Table—The Heart of Any Database. Fields—The Building Blocks of Tables. Access 2002 Data Types. Testing and Using Custom Formats. Building an Access 2002 Table. Entering Data. Explanation of Limitations. The Table Is the Center. 4. Unleashing the Power of Queries. Queries Ask Questions. Queries Access Records. The Query Grid. Understanding Query Types. Introduction to SQL. Understanding “Ands” and “Ors” in the Query Grid. Understanding Wildcards. Understanding Grouping and Sorting. Understanding Dynasets and Their Underlying Tables. Dynasets Versus Snapshots for Query Optimization. II. FORMS FOR INPUT AND REPORTS FOR OUTPUT. 5. Exploring Forms and Controls. Forms Versus Reports. Defining Events. Using a Wizard to Help Design Your Form. Examining Your Form's Properties. Changing the Form's Color. Introduction to Controls. How to Control a Control. Creating a Calculated Control. Another Way to Create Calculated Controls. Creating a Command Button. Dealing with the Underlying Records. Designing a Relational Form. 6. Exploring Reports. Reports Versus Spreadsheets. Report Basics. Creating a Report from Scratch. Taking Charge of Report Controls. Setting Up Spreadsheet-like Calculations in Report Controls. Taking Charge of Grouping and Sorting. Understanding Sections. The On Open Event. Working with the Record Source Property. Designing a Relational Report Using a Wizard. Conditional Formatting. Creating a Group of Controls. III. AUTOMATE YOUR ACCESS DATABASE USING CODE. 7. Exploring Objects. Defining Objects. Defining Object Properties. Object Models. Setting a Reference in the Reference Library. The Power of Controls Revisited. Three Sources. Lookup List. 8. Writing Your Own Visual Basic for Applications Code. Function Procedures, Sub Procedures, and Modules. Access String Functions. The Access Immediate Window. Using Arrays with String Functions. 9. Macros, Modules, and Messages. Visual Basic Versus Macros. Printing the Current Record Using a Macro. 10. Using Procedures to Customize Your Database. Exploring Procedures. Functions Versus Subs. What Is Scope? Creating Procedures. More Than One Way to Loop. More than One Way to Handle Conditions. Using Functions to Fulfill Your Wish List of Features. Access Forgot. Using Functions to Customize Your Applications. Using the Immediate Window to Test Your Functions. Using Functions for Pattern Matching in Queries. 11. Handling Access Error Codes. What To Do When Errors Occur. Determining which Errors Occur. Error-Checking Sub Routines. Fixing Errors After Trapping Them. Resume Statements. The Err.Raise Method. 12. Access Visual Basic Tools, Tips, and Techniques. Comparing DAO and ADO. Using VBA to Run Queries. Manipulating Recordsets Using Collections Versus Manipulating Recordsets Using Queries. DAO Collections and Objects. ADO Collections and Objects. Cursors and Cursor Types. How to Use DAO and ADO to Manipulate Data. How to Use DAO and ADO to Enumerate Objects. Creating a List of Objects. Creating a List of Fields. IV. TAKING ADVANTAGE OF THE LATEST ACCESS FEATURE. 13. Publishing Your Access Database. Converting Objects to Web Pages. Introduction to Data Access Pages. Creating a Data Access Page. Active Server Pages. Hyperlinks in Access Objects. 14. SQL Server Integration. MSDE Upgraded. Comparing MSSQL Server 2000 Desktop Engine to Jet. Installing and Starting the Server. Installing a Sample Northwind Application. Exploring Your Northwind Project. 15. User-Friendly Enhancements. The Paradox of Databases. Compact Improvements. Converting from Previous Versions of Access. Sharing and Integrating with Other Applications. V. OVERCOMING ACCESS DEVELOPMENT OBSTACLES. 16. Overcoming the Limitations of Queries. Query Challenges. Using Query by Table Example for If Then Scenarios. Using Subqueries to Unleash the Power Of Queries. Using Functions with Queries, Revisited. 17. Getting the Most from Your Queries. Making Your Database More Efficient. Query Optimization. Queries Versus Filters. Special SQL Specific Queries. 18. Working with Data from External Sources. Using Automation to Meet Performance Demands. Importing and Exporting Data. Scalability. 19. Bringing Together and Separating Data. The Art of Concatenation. The Art of Parsing. 20. Conquering Big Problems that Come In Small Packages. Using Quotes and Pounds. Testing Quotes and Pounds. Controlling Nulls. Conquering Dates. 21. Taking Charge of Forms. Using a Parameterized Query As a Form's Record Source. Pop-Up Forms Go Beyond the Message Box. How to Tell Whether a Form Is Open. Go Multidimensional with PivotTables. Using Forms to Control Editing and Save Records. Using Forms to Optimize Large Tables. Tab Control Benefits. 22. Taking Charge of Reports. Handling Grouping and Sorting Programmatically. Using Table Relationships to Include or Preclude Entire Sections of Report Data. What to Do with Pesky Blank Lines. Multicolumn Reports. Print Extra Copies. 23. Using Replication. Database Replication. How Replication Works. Index.


Best Sellers



Product Details
  • ISBN-13: 9780789725943
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Que Corporation,U.S.
  • Language: English
  • Spine Width: 33 mm
  • Width: 232 mm
  • ISBN-10: 0789725940
  • Publisher Date: 05 Feb 2002
  • Binding: Paperback
  • No of Pages: 576
  • Weight: 961 gr


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
Access 2002 Programming by Example
Pearson Education (US) -
Access 2002 Programming by Example
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.

Access 2002 Programming by Example

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