|
The Tables in a database can be linked by key data.
For example, a receipt includes key data on who (tblCustomers)
bought (tblReceipt) what (tblMovies). Beginning
Access Teaches One-to-One The
beginning
lessons show how to create and modify Tables. One Table will be used
for each Form.
Intermediate Access Teaches
One-to-Many The
intermediate lessons teaches how to capture one-to-many
relationships. In our little video store, one customer may rent many
movies. In Access, one-to-many is captured with a Form and Subform.
Advanced Access Teaches
Many-to-Many In a good
business, many customers would return many times and rent many
movies. The Advanced Access lessons show how to create Search Forms
and how to analyze the data. OK, that's
enough for the introduction. Let's get
started with Microsoft Access 2010.
Microsoft Access 2010: Sample Database
Relationships
|
|
| |
