7.3.9 Database Design In Microsoft — Access
She added more lines. Events to Pledges . Volunteers to Shifts . The diagram looked like a constellation. She ran the :
In 0.3 seconds, perfect numbers appeared. No duplicates. No ghost compost offers.
She Googled it. 7.3.9 wasn't a spell. It was a section in an old tech manual about normalization —the art of removing redundancy.
She opened , added tbl_Donors , tbl_Pledges , and tbl_Events . She dragged fields into the grid: City , EventName , and PledgeAmount . She clicked the Sigma (∑) Totals button and changed "Group By" to "Sum" under PledgeAmount. 7.3.9 database design in microsoft access
She looked at the Excel monster. It had a column DonorName repeated next to every donation. If a donor changed their address, she had to update 50 rows. Chaos.
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.
That night, alone in the fluorescent glow of her cubicle, Elara opened Access 365. She stared at the blank screen. On the printout, Marcus had scrawled a cryptic note: “7.3.9 – Database Design.” She added more lines
She dragged a line from tbl_Donors.DonorID to tbl_Donations.DonorID . A small window popped up:
Her boss, Marcus, slammed a coffee-stained printout on her desk. "Fix it. You have one week. Use the company license for... what's that program called?"
Elara cracked her knuckles. "Time for a split." The diagram looked like a constellation
For the first time all year, the Harvest Festival Charity Drive didn't just survive. It thrived. And Elara learned a truth that all database designers know: chaos is just data waiting for a primary key.
It was beautiful.
Finally, she tested the query that had broken everything last year: "Total Pledges for the Harvest Dinner, grouped by Donor City."
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.