Question 1:
Some people like to store their information in Excel files. What are the advantages of storing data in a database management system like Access over Excel? Name 3.
Question 2:
In Access, we can implement "cascading deletes" when specifying how tables relate to each other. When a record is deleted from a master table (the table on the "one" side of the relationships), what happens to related records in the other tables to which the master table has one-to-many relationships with "cascading deletes" specified?
Question 3:
In our University database, why is your student number considered a primary key in the student table, but a foreign key in other tables?
Question 4:
What are 3 advantages of using Excel in conjunction with Access when working with a database?
Question 5:
When dealing with databases that are shared among many people, we store the data in a central location and utilize a "front end" to present the data to each user. How does using a "front end" decrease network traffic, improve user response time, and make updates more efficient?