Excel/Access in Data and Information Management (Includes one CD-ROM)

Author: Li Lingxuan
Publisher:
Publish Date: 2006-01-01
Features: Specifically designed for the characteristics of data and information involved in business office operations, utilizing two software tools—Excel and Access—to manage, query, and analyze complex company data. Suitable for multiple versions of Excel and Access 2000/2002/2003, this book serves as a reference guide for administrative, financial, marketing, sales, and corporate planning office personnel to learn Excel and Access software and improve their work efficiency.
The accompanying CD-ROM includes example materials for each chapter, final completed files, and answers to chapter exercises, making it convenient for readers to study and use. The book's greatest feature is the practical application of data in corporate management scenarios. It first explains abstract concepts in Excel 2003, such as templates, functions, macros, pivot tables, data tables, and Solver, through real-world applications. Then, it introduces the most commonly used desktop database software, Access 2003, and provides a detailed explanation of how to create a complete company information management database using Access. Through the comprehensive application section, readers will learn how to organically integrate the two software tools, further enhancing their efficiency in office operations and management.
The book is richly illustrated with numerous images and examples, offering an in-depth yet easy-to-understand introduction to various fundamental concepts and operations. It also covers advanced application techniques for both software tools. Therefore, whether you are a beginner or an experienced user of Excel and Access, you will find great value in this book and significantly improve your work efficiency.