Case 3: The Room and Board Database

3 THE ROOM AND BOARD DATABASE Designing a Relational Database to Create Tables, Forms, CASE Queries, and Reports PREVIEW In this case, you will design a relational database for a senior home that provides free room and board for select local university students who volunteer to work with the senior residents. After your design is completed and correct, you will create database tables and populate them with data. Then you will produce one form with a subform, six queries, and two reports. The queries will show which students work one- on-one with the seniors, the amount of time students have worked with a particular senior, which students play music for the seniors, the amount of time each student has worked with seniors, and which volunteer jobs are the most popular at the home. You will produce two reports: One lists students' room assignments and their home addresses, and the other is based on a query that displays the volunteer job summary PREPARATION Before attempting this case, you should have some experience in database design and in using Microsoft Acces .Complete any part of Tutorial A that your instructor assigns Complete any part of Tutorial B that your instructor assigns, or refer to the tutorial as necessary Refer to Tutorial F as necessary 3 THE ROOM AND BOARD DATABASE Designing a Relational Database to Create Tables, Forms, CASE Queries, and Reports PREVIEW In this case, you will design a relational database for a senior home that provides free room and board for select local university students who volunteer to work with the senior residents. After your design is completed and correct, you will create database tables and populate them with data. Then you will produce one form with a subform, six queries, and two reports. The queries will show which students work one- on-one with the seniors, the amount of time students have worked with a particular senior, which students play music for the seniors, the amount of time each student has worked with seniors, and which volunteer jobs are the most popular at the home. You will produce two reports: One lists students' room assignments and their home addresses, and the other is based on a query that displays the volunteer job summary PREPARATION Before attempting this case, you should have some experience in database design and in using Microsoft Acces .Complete any part of Tutorial A that your instructor assigns Complete any part of Tutorial B that your instructor assigns, or refer to the tutorial as necessary Refer to Tutorial F as necessary