1. Some people like to store their information in Excel files. What are the advantages of storing...
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?
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?