7.3.9 Database Design In Microsoft Access -

Let us expand the “3” in 7.3.9 because this is where most Access databases break down.

Before opening Access, define exactly what you are tracking and the outputs you need. A well-designed database should be built with the final reports in mind—knowing which fields are required for a "Monthly Sales Report" or "Customer List" dictates how you structure your tables. 2. Organizing Tables and Fields 7.3.9 database design in microsoft access

A table Students with fields Subject1 , Subject2 , Subject3 . Solution: Create a separate Enrollments table with rows for each subject. Let us expand the “3” in 7

curriculum. It is a simulated lab environment where students practice the foundational steps of building a relational database. 7.3.9 database design in microsoft access