Access 2003 Beginner's Guide and Practical Exercises

Author: Li Junde
Publisher:
Publish Date: 2005-11-01
Features: In today's crowded market of application books, finding a book that truly meets your needs is like searching for a needle in a haystack. This book solves that problem for you. Based on numerous examples, it introduces complex database knowledge through illustrated explanations, saving you time while helping you truly master the essence of Access and achieve twice the result with half the effort. Since this book focuses on building application systems, it covers most concepts of creating an application system in one volume, unlike other books that simply introduce one aspect of Access. Through this book, you can directly advance to programming. The content is presented in a progressive manner, from basic constants, variables, operations, and wizard operations to more advanced topics like form, macro, and table design, making it suitable for both beginners and intermediate readers. This book is compatible with multiple versions of Access 2000/2002/2003, with detailed steps and rich examples, making it the best introductory book for beginners and intermediate readers to learn and master Access databases.
Key Features:
- Combines theory and practice, tailored for beginners and intermediate readers in content and writing style.
- Focuses on application system development, covering 218 examples including form and report technologies.
- Is one of the most in-depth, comprehensive, and detailed books on macros, fully utilizing macros to complete practical application systems.
- Contains over 200 carefully selected exercises throughout the book to help readers reinforce and practice what they've learned.
- The accompanying CD-ROM includes source files for all examples in the book, including a complete employee management system, library management system, and student information management system.
Access is an application software in the Office suite specifically designed for database management, offering the advantages of ease of learning and use. It is also an open database management system that not only shares data resources with other Office applications but also with other programs. Upon deeper exploration, you'll discover that macros can be used to complete small and medium-sized application systems, and when combined with VBA, even professional application systems can be developed.
This book focuses on application system development, using illustrations and detailed steps to explain how to build three application systems—Student Basic Information Management System, Employee Management System, and Library Management System—using macros. This equips you with the ability to develop application systems. Additionally, the book includes topics like database normalization and new features in Access 2003, making it easier for beginners to learn database systems and stay updated with the latest functionalities.
Beyond the above features, the book provides 218 examples, with 94 related to form design and 124 to data table queries, additions, modifications, and deletions. The abundance of examples is designed to help readers better understand the concepts and integrate them seamlessly.
The book is divided into 14 chapters, covering topics from basic constants, variables, expressions, and wizard operations to more advanced subjects like relationships, macros, form design, and pivot tables. The basic content of each chapter is as follows:
- Chapter 1: Introduces Access environment settings and employee database descriptions.
- Chapter 2: Covers Access basics and the seven major database objects.
- Chapter 3: Discusses opening, creating, and backing up databases.
- Chapter 4, Chapter 6, and Chapter 9: Explain table creation, advanced table operations, data types, and field attributes.
- Chapter 5: Covers query creation, expressions, and parameter queries.
- Chapter 7: Explores database design and normalization theory.
- Chapter 8: Discusses table relationships, including normalization issues, relationship creation, and referential integrity.
- Chapter 10, Chapter 11, and Chapter 13: Introduce form wizards, automatically generated forms, basic control operations, the preliminary design of the employee management system, and form objects.
- Chapter 12: Deep dives into macros, including creating macro groups and using them to build menus.
- Chapter 14: Covers form and label creation, including report setup and completing the employee management system reports.
For general readers, this book is ideal for beginners to learn step by step, starting from basic constants, variables, expressions, and wizard operations, ensuring a smooth learning experience. For readers with some background, it also provides advanced topics like relationships, macros, form design, and pivot tables, making it suitable for both beginners and those looking to clarify concepts. We believe this book will be the best starting point for you to enter the field of databases.