CS 1100 Lecture Notes - Lecture 20: Dialog Box, Unique Key, Foreign Key

• School: Northeastern University
• Department: Computer Science
• Course: CS 1100
• Professor: Yang( G)

Document Summary

Cs1100 - lecture 20 - working with databases in access. Use access as an analysis tool for large data sets. Here one primary key is pointing to another primary key. Course table having course id , foreign key is present in another table. Here one primary key has one or more foreign key. Course table registrations table students table zipcode table. This option is used to remove duplicates. Click on required table name and click add and finally click close. Click on required query and then do right click on it. Change rquired settings to remove duplicates and run the query again. Go to create tab -> click on query design . Drag two tables into query for performing join option. Two tables should not be isolated each other. There should be at least one link connecting to each other. There should be always relationship being built up between two tables.