In this exercise, you use a Microsoft Access database named Calories. The database, which is stored in

Question:

In this exercise, you use a Microsoft Access database named Calories. The database, which is stored in the VB2015\Chap13\Access Databases\Calories.accdb file, keeps track of the calories consumed during the day. The database contains one table named tblCalories. Each record has the following six fields: Day, Breakfast, Lunch, Dinner, Dessert, and Snack. The Day field is a text field; the other fields are numeric. The user should be able to display the total number of calories consumed in the entire dataset. He or she should also be able to display the total calories consumed for a specific meal, such as the total calories consumed for breakfasts, lunches, dinners, desserts, or snacks. In addition, the user should be able to display the total calories consumed on a specific day, the number of days in which more than 1,200 calories were consumed, and the average number of calories consumed per day.

a. Create an application, using the following names for the solution and project, respectively: Calorie Counter Solution and Calorie Counter Project. Save the application in the VB2015\Chap13 folder.

b. Connect the application to the Calories database, and then drag the tblCalories object to the form. Make the appropriate modifications to the DataGridView control. The user should not be able to add, edit, delete, or save records.

c. Code the application. Use the application to answer the following questions: How many calories were consumed in the entire dataset? How many calories were consumed for desserts? How many calories were consumed on 12/21/2017? On how many days were more than 1,200 calories consumed? What is the average number of calories consumed per day?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: