Skip to main content

Microsoft Access 2000 Bible

Microsoft Access 2000 Bible

Cary N. Prague, Michael R. Irwin

ISBN: 978-0-764-53286-3

May 1999

1272 pages

Select type: Paperback

Product not available for purchase

Description

  • Client lists.
  • Figure sales.
  • Web research.

Take charge of your data before it takes over your business. With expert advice from Cary Prague and Michael Irwin, you'll quickly master Access 2000's top database management capabilities -- and its revolutionary Web features. Using step-by-step instructions and practical examples, the authors demonstrate everything you need to know to organize, present, analyze, and share data efficiently over a corporate network or the Internet.

Part I: First Things First.

Chapter 1: What Is Access 2000?

Chapter 2: Installing and Running Access 2000.

Chapter 3: A Review of Database Concepts.

Chapter 4: A Hands-on Tour of Access 2000.

Chapter 5: A Case Study in Database Design.

Part II: Basic Database Usage.

Chapter 6: Creating Database Tables.

Chapter 7: Entering, Changing, Deleting, and Displaying Data.

Chapter 8: Creating and Using Simple Data-Entry Forms.

Chapter 9: Understanding and Using Simple Queries.

Chapter 10: Creating and Printing Simple Reports.

Chapter 11: Setting Relationships Between Tables.

Part III: Using Access in Your Work.

Chapter 12: Using Operators, Functions, and Expressions.

Chapter 13: Creating Relations and Joins in Queries.

Chapter 14: Creating Select Queries.

Chapter 15: Understanding Controls and Properties.

Chapter 16: Creating and Customizing Data-Entry Forms.

Chapter 17: Creating Great-Looking Forms.

Chapter 18: Adding Data-Validation Controls to Forms.

Chapter 19: Using OLE Objects, Graphs, and ActiveX Custom Controls.

Chapter 20: Creating and Customizing Reports.

Chapter 21: Presentation Quality Reports and Printing.

Chapter 22: Creating Calculations and Summaries in Reports.

Part IV: Advanced Database Features.

Chapter 23: Working with External Data.

Chapter 24: Advanced Select Queries.

Chapter 25: Creating Action Queries.

Chapter 26: Advanced Query Topics.

Chapter 27: Creating and Using Subforms.

Chapter 28: Creating Mailing Labels and Mail Merge Reports.

Part V: Applications in Access.

Chapter 29: An Introduction to Macros and Events.

Chapter 30: Using Macros in Forms and Reports.

Chapter 31: Creating Switchboards, Command Bars, Menus, Toolbars, and Dialog Boxes.

Chapter 32: Using Data Access Pages, Intranets, and the Internet.

Chapter 33: Using Access with the Microsoft Database Engine and SQL Server.

Chapter 34: Introduction to Applications with VBA.

Chapter 35: The Access 2000 Programming Environment.

Appendix A: Microsoft Access 2000 Specifications.

Appendix B: Mountain Animal Hospital Tables.

Appendix C: What's on the CD-ROM.

Appendix D: Object Cross-Reference Guide.

Appendix E: Chapter Cross-Reference Guide.

Index.

End-User License Agreement.

CD-ROM Installation Instructions.