Buy Using Microsoft Access 97 Book by Thomas Armitage
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 97: (Using)
Using Microsoft Access 97: (Using)

Using Microsoft Access 97: (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 97, Second Edition, leads you through a quick series of chapters to get you up and running with Access quickly. Then youre presented with more in-depth concepts, such as table relationships, datatypes, and data entry techniques--all in real-world examples and tasks to help you become a more proficient user. Master your Access skills 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. What is Relational Database Theory? The Importance of a Good Design. Refining the Design. Naming Conventions. Syntax for Naming Objects. 2. Creating a Database with a Wizard. Whats a Wizard? About the Database Wizard. Modifying Objects in the Wizards Database. 3. Creating Tables with a Wizard. What are Tables? About the Table Wizard. Launching the Table Wizard. Using the Table Wizard. 4. Using the Query Wizards. What is a Query? The Query Wizards. What is a Simple Query? Launching the Query Wizards. Using the Simple Query Wizard. Whats a Crosstab Query? Using the Crosstab Query Wizard. Using the Find Duplicates Query Wizard. Using the Find Unmatched Query Wizard. 5. Form Creation Using a Wizard. A Short Form Orientation. About the Form Wizards. Using the Form Wizard. Using the Chart Wizard. Working with the PivotTable Wizard. 6. Creating Reports with the Report Wizard. A Short Report Orientation. The Report Wizards and Their Capabilities. Using AutoReports. Using the Report Wizard. Using the Chart Wizard. 7. Analyzing and Documenting the Database. The Database Performance Analyzer Wizard. Documenting the Database. 8. Using Wizards to Manage Data Imports and Input. Importing and Linking. Using the Import Spreadsheet Wizard. Using the Import Text Wizard. Running the Analyze Table Wizard. Importing a Fixed-Width Text File. Using the Input Data Mask Wizard. 9. Using Control Wizards and Setting Control Properties. About the Control Wizards. The List Box Control. Using the List Box Wizard. About the Combo Box Control. Using the Combo Box Wizard. About the Command Button Control. Using the Command Button Wizard. The Option Group Control. Using the Option Group Wizard. 10. Using the Mail Merge Wizard. Merging Access Data with Word Documents. 11. Using Add-Ins and Builders to Increase Efficiency. Installing and Using Add-Ins. Builders. Picture Builder. II. STORING AND CONTROLLING DATA IN TABLES AND FIELDS. 12. Creating Tables in the Design View. Designing Tables. The Table in Design View. Assigning Table Names That Describe Their Function. Tips for Making Tables Efficient Objects within the Database. Primary Keys. Indexes. 13. Creating Fields That Look Up Lists or Values in Tables. Whats a Lookup? Whats a Lookup Field? Using the DLookUp() Function. 14. Defining and Working with Relationships. Bringing the Information Together. How Relationships Between Objects Work. Primary Keys and Relationships. Using the Relationships Window. III. MANIPULATING DATA FOR PRACTICAL RESULTS. 15. Designing and Using Queries. Retrieving Data with Select Queries. Creating a Select Query without Using a Wizard. Grouping Data and Performing Calculations with a Crosstab Query. Creating a New Table with Selected Data Using a Make-Table Query. Creating a Make-Table Query. Adding Records to an Existing Table Using an Append Query. Deleting Selected Records from a Table Using a Delete Query. 16. Using the Query Design Grid. How to Use the Query Design Grid. Selecting Fields to Query. Setting Field Criteria. Using the Expression Builder for Complex Expressions. 17. Setting Parameters. Setting Parameters in the Criteria Section of the Query Design Grid. Setting Parameters in the Parameter Dialog Box. Using Wildcards in Parameters. 18. Advanced Uses of Queries. Querying Another Query. Using the Query Design Grid to Create an SQL Statement for a Macro RunSQL Action. Using the Query Design Grid to Create an SQL Statement for Use in VBA. IV. CREATING THE USER INTERFACE, INPUT, AND OUTPUT. 19. Adding Controls to Forms and Reports. Whats the Toolbox? Understanding the Grid. Inserting Controls. Positioning Controls. Sizing Controls. Selecting Multiple Controls. Selecting Multiple Controls with the Menu. An Introduction to the Control Wizards. Whats a Bound Control? 20. Creating Forms. The Form in Design View. The Sections of a Form. Assigning Form Properties. Standardizing Forms. Using Form Templates. 21. Using Forms to Enter and Review Data. Form View. Navigating Records. Controlling Navigation in Forms. Sorting in a Form. Searching in a Form. 22. 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. 23. The World of Subforms. When to Use a Subform. Linking a Subform to the Main Form. Creating a Subform. Referring to Subforms and Their Controls. A Subform Alternative - The Tab Control. 24. Advanced Form Techniques. Exploring the Form Module. Responding to Form Events. Using Form Events to Open Other Forms. 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. 25. Creating Effective Reports. Assigning Report Properties. Planning the Layout and Print Settings for a Report. Standardizing Your Reports and Using Report Templates. 26. Making Your Point with Reports. Grouping and Sorting Data. Calculating Totals with Controls. The Art of Page Numbering. Inserting Graphics. To Frame or Not to Frame. Working with OLE Graphics. Adding Lines and Circles to a Report. Drawing a Border Around the Report Page. 27. Displaying Detailed Data with a Subreport. Whats a Subreport and Why Do You Need One? Adding a Subreport to an Unbound Main Report. Linking a Subreports Data to the Main Report. Assigning Subreport Properties. 28. Creating Mailing Labels. Using the Label Wizard. Using Custom Labels. Printing Multiple Labels. V. AUTOMATING THE DATABASE. 29. Creating Macros. When to Use Macros. The Macro Design Window. Generating Multiple Macros. 30. Running Macros. Methods Used to Run Macros. Debugging Macros. Special Macros: AutoExec and AutoKeys. 31. An Introduction to VBA. When to Use VBA. The Programming Environment. Coding Tips. Documenting Code. Color in the Module Window. Using the Object Browser. 32. Programming Access with VBA. Getting Familiar with the Access Applications Model. Learning to Speak VBA. All About Variables and Data Types. Understanding Scope. Writing Procedures. 33. Something for the More Advanced VBA User. Passing Arguments to Your Code. Displaying Information with a Message. Soliciting Information with an Input Box. Letting the Code Make Decisions. When the Code Doesnt Work. Preventing Run-Time Errors. 34. Saving Your Database as an MDE File. MDB Files I Know About, But What Is an MDE File? Not So Fast! Benefits of Creating an MDE File. Restrictions. VI. BEYOND DESKTOP APPLICATION. 35. Replication. What Replication is and When to Use It. The Tools of the Trade. Access 97 Menus. What Has Changed and Why. User Tables. What Is Changing? Synchronization. Direct and Indirect Synchronization. Configuring Replication Manager for Indirect Synchronization. Partial Replication. Security and Replication. Good Housekeeping. Recovering a Design Master. 36. Useful Tools. Using Office Links. OLE Automation and ActiveX Controls. Using Third-Party ActiveX Controls. Link or Embed an Office Document. The Office Assistant. How to Use AutoCorrect. AutoCorrect in Action. Programming Command Bars. 37. Access on the Internet. How Access and the World Wide Web Unite. Hyperlinks within Access. Publishing Basics. Importing and Linking to Data from HTML Tables. 38. Applying Security to the Database. Why Have Security? Encrypting and Decrypting the Database. Setting a Database Password. Implementing User-Level Security. Creating and Using Workgroup Information Files. Defining User and Group Accounts. The User-Level Security Wizard. Setting User and Group Permissions. VII. APPENDIX. Appendix A. Sample Snippets of Useful and Common VBA. Simulating Green Bar Computer Paper. Printing a Border Around Your Report. Open Another Database. Requery Active Control. Displaying the Record Count. Executing Hyperlinks. Flagging Missing Records in a Report. Flashing Text. Capturing Keystrokes. Suppressing a Report When There Are No Records to Print. Returning a List of Objects. Launching the Windows Calculator. Assigning a Controls Value to a Variable. Opening a Recordset. Checking if a Particular Object is Open. Adding a New Item to the Combo Box List On-the-Fly. Loading a Combo Box. Using Conditional Colors in Reporting. Opening More Than One Copy of the Same Form. Printing an Adjusting Border. Creating a Recordset Object. Checking for an Empty Record Set. Acting on Controls in a Specific Form Section. Closing the Current Form. Glossary. Index.


Best Sellers


Product Details
  • ISBN-13: 9780789716347
  • Publisher: Macmillan Computer Publishing (a Pearson Education company)
  • Publisher Imprint: Que
  • Edition: Revised edition
  • Language: English
  • Series Title: Using
  • Width: 187 mm
  • ISBN-10: 0789716348
  • Publisher Date: 01 Jan 1999
  • Binding: Paperback
  • Height: 232 mm
  • Returnable: N
  • Weight: 1389 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

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