Database Principles and Applications - Based on Access

Author: Li Chunbao
Publisher:
Publish Date: 2005-04-01
Features: This book introduces the principles and applications of databases based on Access, meeting teaching requirements. It progresses from simple to complex, is comprehensive, and easy to understand. It includes a selection of numerous examples with detailed solutions, helping students grasp key points and overcome difficulties. It is accompanied by exercises and hands-on practice questions to comprehensively improve students' practical application and operational skills. Database technology is one of the fastest-growing fields in the IT industry and has been widely applied in various types of data processing systems. Understanding and mastering database knowledge has become a fundamental requirement for all types of technical and administrative personnel. This book discusses the principles and application methods of databases based on the Access system. The book is divided into two parts: Chapters 1 to 5 introduce the general principles of databases, including an overview of database systems, data models, relational databases, normalization theory for relational databases, and database design. Chapters 6 to 15 introduce the use of Access system technology for developing database application systems, including an overview of the Access database system, creating Access databases, creating tables, using Access tables, SQL language, and the design of queries, forms, macros, reports, and Access's programming tool VBA. Each chapter is accompanied by exercises. The appendix includes 4 hands-on practice questions and reference answers for exercises. The content of this book is presented in a simple, progressive, and easy-to-understand manner, making it suitable for self-study. It can serve as a textbook for candidates preparing for the Level 2 exam, as well as a teaching resource for "Database Principles and Applications" courses in various colleges, universities, and training programs. It is also a practical self-study reference book for computer application professionals and enthusiasts.