Mastering Access 2002, Premium Edition (eBook)

Celeste Robinson, Alan Simpson (Autoren)

eBook Download: PDF

2006 | 1. Auflage
1178 Seiten
John Wiley & Sons (Verlag)
978-0-7821-5304-0 (ISBN)

Infos

Master Everything Access 2002 Has to OfferReap the benefits of the latest release of Microsoft Access withMastering Access 2002 Premium Edition. Get clelear, in-depthcoverage of the entire range of Access functionality, from basic toadvanced. Special attention to new features makes the transitionfrom an earlier version quick and painless, and 200 pages of bonusmacro material teaches you ways to customize and automate Access tomake it work for you.Establish Key Skills* Create a database that meets your precise needs* Design easy-to-use forms with effective visual elements* Expand and collapse views to bring in supporting details* Import and export data, including XML* Examine data using subdatasheet views* Summarize, analyze, and trend data with PivotTables andPivotCharts* Filter data and create reports* Publish Access data to a Web server* Personalize Access menus and toolbars* Keep your data secure* Take advantage of improved integration with other Officeapplications* Create custom error messagesThen Tackle These Cutting-Edge Topics* Recording and running macros* Maintaining data with macros* Handling complex macro navigation* Using macros to work with groups of records* Identifying and correcting macro errors* Using Access as SQL Server's front end* Using Access as the core of a database-driven Web site* Managing replication and conflict resolution* Using Visual Basic to get the most out of AccessNote: CD-ROM/DVD and other supplementary materials arenot included as part of eBook file.

Autor

Celeste Robinson has worked as a systems engineer, smallbusiness consultant, technical trainer, and database developer in acomputing career that spans more than 20 years. She has co-authored(with Alan Simpson) Mastering Access 97, MasteringWordPerfect Office 2000, and Mastering Access 2000, allfrom Sybex.Alan Simpson is a software consultant, best-sellingauthor, and teacher, who has been active in the computer industryfor over two decades. His books include dozens of popularly,critically, and technically acclaimed titles.

Inhalt

Introduction.PART I: AN OVERVIEW OF ACCESS.Chapter 1: Getting Started and Getting Around.Chapter 2: Understanding Databases.Chapter 3: Access in an Evening.Chapter 4: About Access, Office, Windows, and the Internet.PART II: CREATING A DATABASE PROJECT.Chapter 5: Creating a Database.Chapter 6: Creating Access Tables.Chapter 7: Linking, Importing, and Exporting Data.Chapter 8: Adding, Editing, and Viewing Data.Chapter 9: Sorting, Searching, Filtering, and Printing.Chapter 10: Querying Your Tables.Chapter 11: Creating Forms with Form Wizards.Chapter 12: Creating Reports with Report Wizards.Chapter 13: Creating Custom Forms and Reports.Chapter 14: Creating Data Access Pages.Chapter 15: Creating Charts and PivotTables.PART III: DATABASE TUNING AND ADMINISTRATION.Chapter 16: Personalizing Access.Chapter 17: Speeding Up Your Database.Chapter 18: Administering Your Database.Chapter 19: Networking and Security.PART IV: BUILDING A CUSTOM APPLICATION.Chapter 20: Creating a Custom Application.Chapter 21: Using Macros to Create Custom Actions.Chapter 22: Creating Custom Switchboards.Chapter 23: Creating Custom Dialog Boxes.Chapter 24: Creating Custom Toolbars.Chapter 25: Creating Custom Menus.PART V: REFINING A CUSTOM APPLICATION.Chapter 26: Introducing Visual Basic.Chapter 27: Creating Custom Error Messages.Chapter 28: Interacting with Other Programs.Chapter 29: Pulling It All Together.Chapter 30: Working with Projects.PART VI: MACRO PROGRAMMING FROM INDUSTRY EXPERT SUSANNNOVALIS.Chapter 31: Macro Basics.Chapter 32: Dealing with Errors in Macros.Chapter 33: Navigation with Macros.Chapter 34: Data Maintenance with Macros.Chapter 35: Working with Groups of Records Using Macros.PART VII: APPENDICES.Appendix A: Checking Your Hardware.Appendix B: About the CD-ROM.Appendix C: Installing and Using Fulfill 2002.Index.

Produkt-Details

• Erscheint lt. Verlag: 26.7.2006
• Sprache: englisch
• Themenwelt: Mathematik / Informatik ► Informatik ► Datenbanken
• Themenwelt: Informatik ► Office Programme ► Access
• Schlagworte: Access 2002 • Computer-Ratgeber • End-User Computing • Microsoft Access
• ISBN-10: 0-7821-5304-6 / 0782153046
• ISBN-13: 978-0-7821-5304-0 / 9780782153040