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?

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?

3. In our Wilmington University database, why is your student number considered a primary key in the student table, but a foreign key in other tables?

4. What are 3 advantages of using Excel in conjunction with Access when working with a database?

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“front end” decrease network traffic, improve user response time, and make updates more efficient?

Answer rating: 100% (QA)

1 There are many advantages of storing data in database management the detail is given below Easy ac... View the full answer