Access 2003 Beginner's Guide and Practical Exercises (Includes one CD-ROM)

Author: Li Junde
Publisher:
Publish Date: 2005-11-01
Features: In today's era of abundant application books competing for attention, finding a book that truly meets your needs is like searching for a needle in a haystack. This book solves this 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 introduced from basic to advanced levels, starting from fundamental constants, variables, operations, and wizard operations, to more in-depth topics like form, macro, and table design, and reports. Therefore, this book is 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 of the Book:
- Combines theory and practice, tailored for beginners and intermediate readers in terms of 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 by the author to help readers reinforce and practice what they have 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 within 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 of Access, you will discover that macros can also be used to complete small and medium-sized application systems, and when combined with VBA, you can develop professional application systems.
This book focuses on application system development, using illustrations and detailed steps to introduce the construction of three application systems—Student Basic Information Management System, Employee Management System, and Library Management System—using macros, enabling you to develop the ability to create application systems. Additionally, the book includes content on database normalization and new features of Access 2003, making it easier for beginners to learn database systems and understand the latest features.
Besides the above features, the book provides 218 examples, with 94 related to form design and the remaining 124 to data table queries, additions, modifications, and deletions. The book offers so many examples to help readers better understand the concepts and integrate them effectively.
The book is divided into 14 chapters, covering topics from basic constants, variables, expressions, and wizard operations to more advanced content like relationships, macros, form design, and pivot tables. The basic content of each chapter is as follows:
- Chapter 1 introduces Access environment setup and employee database descriptions.
- Chapter 2 covers Access basics and the seven major database objects.
- Chapter 3 discusses database opening, creation, and backup.
- Chapters 4, 6, and 9 cover table creation, advanced table operations, data types, and field attributes.
- Chapter 5 introduces query creation, expressions, and parameter queries.
- Chapter 7 explains database design and normalization theory.
- Chapter 8 covers table relationships, including normalization issues, relationship creation, and referential integrity.
- Chapters 10, 11, and 13 discuss form wizards, automatic form generation, basic control operations, the preliminary design of the employee management system, and form object creation.
- Chapter 12 delves into macros, including macro grouping and using groups to create menus.
- Chapter 14 covers form and label creation, including report setup and completing the employee management system reports.
For general readers, this book is highly suitable 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 foundation, the book also provides content on relationships, macros, form design, and pivot tables, making it equally suitable for beginners or those with some knowledge but needing to clarify concepts. We believe this book will be the best starting point for you to enter the field of databases.