In this exercise, you use a Microsoft Access database named Trips. The database, which is stored in the VB2015Chap13Access DatabasesTrips.accdb
In this exercise, you use a Microsoft Access database named Trips. The database, which is stored in the VB2015\Chap13\Access Databases\Trips.accdb file, keeps track of a person’s business and pleasure trips. The database contains one table named tblTrips. Each record has the following four text fields: TripDate, Origin, Destination, BusinessPleasure. The user should be able to display the number of trips from a specific origin to a specific destination, such as from Chicago to Atlanta. He or she should also be able to display the total number of business trips and the total number of pleasure trips.
a. Create an application, using the following names for the solution and project, respectively: Trips Solution and Trips Project. Save the application in the VB2015\ Chap13 folder.
b. Connect the application to the Trips database, and then drag the tblTrips 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. (Hint: You can use a logical operator in the Where clause.) Use the application to answer the following questions: How many trips were made from Chicago to Nashville? How many trips were made from Atlanta to Los Angeles? How many business trips were taken? How many pleasure trips were taken?
This problem has been solved!
Step by Step Answer: