7.3.9 Database Design In Microsoft Access -

Elara hated spreadsheets. For three years, the annual “Harvest Festival Charity Drive” had been run off a single, monstrous Excel file named FINAL_REAL_FINAL_v7.xlsx . It had columns for donors, pledges, event tickets, volunteer shifts, and bake sale inventory, all crammed together like a clown car.

She added more lines. Events to Pledges . Volunteers to Shifts . The diagram looked like a constellation. She ran the : 7.3.9 database design in microsoft access

Elara turned her monitor. The showed a tidy list: Queries, Forms, Reports. She clicked a Report she’d made using the Report Wizard —a professional, printable summary of the drive’s health. Elara hated spreadsheets

Finally, she tested the query that had broken everything last year: "Total Pledges for the Harvest Dinner, grouped by Donor City." She added more lines

"tbl_Donors (1) <-----> ( ) tbl_Donations"*

Elara cracked her knuckles. "Time for a split."

"That," Elara said, sipping cold coffee, "is 7.3.9. Normalized tables. Referential integrity. A query with an inner join. No spreadsheets. No fear."