Database Principles and Applications: Based on Access

Author: Li Chunbao Zeng Ping
Publisher:
Publish Date: 2005-01-01
Features: The book features an introduction to database principles and applications 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. Accompanied by exercises and hands-on practice questions, it comprehensively enhances students' comprehensive application and practical 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 basic requirement for various technical and management 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 database system overview, data models, relational databases, relational database normalization theory, 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 to exercises. The book is designed to progress from simple to complex, be comprehensive, and easy to understand, 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 personnel and enthusiasts.