Course | August 27 | 1:30-4 p.m. | 239 Campus Shared Services (1608 4th Street, Berkeley)
This course details the concepts and practices of designing a relational Microsoft Access database. Emphasis is placed on Table normalization strategies, defining multi-table relationships, and understanding the implications and benefits of a relational environment on other database objects such as Queries, Forms, and Reports. Learning Objectives * Understand the purpose and interdependencies of the six major database object types. * Contrast flat file data storage against relational database management systems. * Apply Table normalization strategies to mitigate data anomalies. Use the Table Analyzer to verify normalization efforts. * Define one-to-many, many-to-many, and one-to-one relationships between multiple Tables. * Enforce referential integrity between related Tables, defining cascading update and deletion policies. * Modify join properties between Tables to define database-level inner or outer joins. * Insert Table Subdatasheets to visualize and manage records in related Tables. * Understand the implications of database relationships on Table, Query, Form, and Report objects.