Access Database Design & Programming - Info and Reading Options

"Access Database Design & Programming" Table Of Contents:

• 1- Table of Contents; Preface; Preface to the Third Edition; Preface to the Second Edition; The Book's Audience; The Sample Code; Organization of This Book; Part I, Database Design; Part II, Database Queries; Part III, Database Architecture; Part IV, Visual Basic for Applications; Part V, Data Access Objects; Part VI, ActiveX Data Objects; Part VII, Programming Problems; Part VIII, Appendixes; Conventions in This Book; Obtaining Updated Information; Request for Comments; Acknowledgments; Part I; Introduction; Database Design; Why Use a Relational-Database Design?; Redundancy.
• 2- Multiple-value problemsUpdate anomalies; Insertion anomalies; Deletion anomalies; Complications of Relational-Database Design; Avoiding data loss; Maintaining relational integrity; Creating views; Summary; Database Programming; The Entity-Relationship Model?of?a?Database; What Is a Database?; Entities and Their Attributes; Keys and Superkeys; Relationships Between Entities; Types of Relationships; Implementing Entity-Relationship Models:?Relational?Databases; Implementing Entities; Implementing Entity Classes-Table Schemes; Implementing Entity Sets-Tables; A Short Glossary.
• 3- Implementing the Relationships in?a?Relational?DatabaseImplementing a One-to-Many Relationship-Foreign Keys; Implementing a One-to-One Relationship; Implementing a Many-to-Many Relationship- New Entity Classes; Referential Integrity; Cascading Updates and Cascading Deletions; The LIBRARY Relational Database; Setting Up the Relationships in Access; Index Files; Example; NULL Values; Database Design Principles; Redundancy; Normal Forms; First Normal Form; Functional Dependencies; Second Normal Form; Third Normal Form; Boyce-Codd Normal Form; Normalization; Decomposition; Part II.
• 4- Query Languages and the Relational?AlgebraQuery Languages; Relational Algebra and Relational Calculus; Details of the Relational Algebra; Renaming; Union; Intersection; Difference; Cartesian Product; Projection; Selection; Joins; Equi-join; Natural join; q-Join; Outer Joins; Implementing Joins in Microsoft Access; Semi-Joins; Other Relational Algebra Operations; Optimization; Access Structured Query Language?(SQL); Introduction to Access SQL; Access Query Design; Access Query Types; Why Use SQL?; Access SQL; Syntax Conventions; Notes; The DDL Component of Access SQL.
• 5- The CREATE TABLE StatementColumn definition; Constraints; Notes; The ALTER TABLE Statement; Notes; The CREATE INDEX Statement; Note; The DROP Statement; Note; The DML Component of Access SQL; Updatable Queries; Joins; Inner joins; Outer joins; Nested joins; Self-joins; Notes; The SELECT Statement; Predicate; ReturnColumnDescription; FROM TableExpression; WHERE RowCondition; GROUP BY GroupByCriteria; HAVING GroupCriteria; ORDER BY OrderByCriteria; The UNION Statement; Example; Notes; The UPDATE Statement; Example; The DELETE Statement; The INSERT INTO Statement; Note; The SELECT ... INTO Statement.

"Access Database Design & Programming" Description:

Read “Access Database Design & Programming”:

Read “Access Database Design & Programming” by choosing from the options below.