Unformatted text preview: Â∙ Microsoft Access uses metadata Â∙ Metadata is data about data Â∙ A database allows you to have multiple indexes Â∙ In a database it doesn't matter what the order is in the file. Primary Key- Uniquely identifies each row/record in a table Foreign Key- Connects a row in one table with one or more rows in another table. A table can have 0, 1, or many foreign keys. A record from the customer table can be related to 0 or many records in the order table One order can be related to one and only one customer (minimums on the inside and maximums are on the outside)....
View Full Document
- Searching, Foreign key, Search terms, Primary Key- Uniquely, Foreign Key- Connects