I will upload the videos to many videos sites such as You Tube, Yahoo videos and Blip.tv. I make a new table called video sites and list these websites.
Because one video will be uploaded to many video sites and one video site will have many videos uploaded to it with this many to many relationship. I therefore need a table in the middle of the two to join them and have called this table video uploads. I make a lookup in the video uploads to look up the video name and the video site and then I go to the relationship window and join them using referential integrity.
Free Database Tutorials From VTC:
Access 2010
Access 2007
Access 2003
Access 2002
Access 2000
Access 97
Database Optimization
Data Modeling
Visual Basic for Access
For more free database, programming or software tutorials click here and do a search or click one of the categories.
