Master everything Access 2002 has to offer. Reap the benefits of the latest release of Microsoft Access with "Mastering Access 2002 Premium Edition". Get clear, in-depth coverage of the entire range of Access functionality, from basic to advanced. Special attention to new features makes the transition from an earlier version quick and painless, and 200 pages of bonus macro material teaches you ways to customize and automate Access to make it work for you. Establish key skills such as - 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 and PivotCharts; 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 Office applications; and, create custom error messages.
Then 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; and, using Visual Basic to get the most out of Access.
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Editions-Typ
Maße
Höhe: 227 mm
Breite: 192 mm
Gewicht
ISBN-13
978-0-7821-4008-8 (9780782140088)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
Celeste Robinson has worked as a systems engineer, small business consultant, technical trainer, and database developer in a computing career that spans more than 20 years. She has co--authored (with Alan Simpson) Mastering Access 97, Mastering WordPerfect Office 2000, and Mastering Access 2000, all from Sybex. Alan Simpson is a software consultant, best--selling author, and teacher, who has been active in the computer industry for over two decades. His books include dozens of popularly, critically, and technically acclaimed titles.
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 SUSANN NOVALIS. 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.
