This book provides experienced Access users who are novice programmers with frequently overlooked concepts and techniques necessary to create effective database applications. Unlike other Access books, it takes the reader behind the details and focuses on core concepts in three major areas:
- Database design: examines the principles of sound relational database design and shows how to normalize tables to eliminate data redundancy without losing data.
- Queries: examines multi-table queries and shows how to implement them indirectly by using the Access interface or directly by using Access SQL.
- Programming: introduces the Data Access Object (DAO) and Microsoft Access object models, which allow a developer to place a database under program control.