|
Most
offices enter customer and product information separately. There may
be a spreadsheet for the customers (who) and another
spreadsheet for the products (what). In our sample business the customers rent
movies, so there will be a list of movies. Who
Bought What? A
receipt lists who bought what. Question:
how do you show that in Excel? A
spreadsheet can record one-to-one relationships. Picture the
receipt spreadsheet. Each row would have one answer in each column:
receipt no, date, customer, movie, price. So far, so good. However
one customer may get many movies, say 3 or 5 titles. At some point
you need to document that many customers bought many
products on many days. Databases
do many-to-many relationships. Keep
going, please.
Microsoft Excel 2010: Sample Customer and Movie
Data
|
|
| |
