Database Principles and Applications (Access): Access

Author: Zhou Zhongrong
Publisher:
Publish Date: 2003-08-01
Features: This book incorporates new technical materials of Access and integrates the authors' extensive experience in database teaching and system development. Adhering to the principle of "essential and sufficient" in higher vocational education and students' cognitive abilities, the book emphasizes the cultivation of practical skills. To provide readers with a comprehensive understanding of database knowledge, Chapter 1 is specifically written, primarily using a combination of textual explanations and typical examples to introduce the basic principles, important concepts, and criteria for establishing a reasonable data model. The book breaks the traditional layout of computer-related books, briefly covering basic computer application and Office knowledge, while focusing on the introduction of key objects such as tables, queries, forms, reports, and macros. The content is organized according to human cognitive processes, progressing from simple to complex with appropriate depth and detail. Concepts, methods, and steps are illustrated with examples for easy comprehension. Detailed explanations of creation methods and steps for various objects are provided only where necessary, while other sections remain concise. Data types and expressions are comprehensively introduced in Chapter 2 and further reinforced in subsequent chapters to cultivate readers' ability to solve complex problems. This book is designed for higher vocational and technical colleges to teach the "Database Principles and Applications" course. Access, as a cutting-edge, user-friendly database development tool, is particularly convenient and efficient for solving small and medium-sized database management issues. This is why Access has become one of the most popular and powerful database management systems. The content of the book is broadly divided into four parts. Part 1 (Chapters 1 and 2) introduces the basic principles of databases, criteria for establishing data models, and the design methods of Access databases, as well as various objects. Part 2 (Chapters 3 to 7) covers the functions and creation methods of Access database main objects, along with using a switchboard to manage database operations uniformly. Part 3 (Chapter 8) discusses the main methods for maintaining and managing databases. Part 4 (Chapter 9) introduces several topics for database design, allowing students to choose from them for their course projects. This book serves not only as a teaching material for relevant higher vocational and technical college majors but also as a reference for instructors and a helpful guide for beginners with basic computer knowledge to self-study database concepts.