7.3.9 Database Design In Microsoft Access Page

"Microsoft Access," Elara whispered.

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. 7.3.9 database design in microsoft access

By midnight, she had five lonely tables: Donors, Events, Volunteers, Inventory, and Pledges. They sat there, disconnected islands of data. "Microsoft Access," Elara whispered

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. she had five lonely tables: Donors