7.3.9 Database | Design In Microsoft Access

It was beautiful.

She checked the box. This was the soul of 7.3.9. It meant Access would never let her create an orphan record—a donation with no donor. It was a promise of order. 7.3.9 database design in microsoft access

"tbl_Donors (1) <-----> ( ) tbl_Donations"* It was beautiful

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. It meant Access would never let her create

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.

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

The next morning, Marcus walked by. "You look terrible. Did you fix the..."