Open the Trips Solution (Trips Solution.sln) file contained in the ClearlyVB2012 Chap25Trips Solution folder. The application is connected to a Microsoft Access database named Trips, which keeps track of a person’s business and pleasure trips. The database contains one table named tblTrips. The table has 10 records. Each record has the following four text fields: TripDate, Origin, Destination, and BusinessPleasure. The application should allow the user to display the number of trips from a specific origin to a specific destination, such as from Chicago to Atlanta. (Hint: You can use a logical operator in the Where clause.) It should also allow the user to display (in a message box) either the total number of business trips or the total number of pleasure trips.
a. Open the Code Editor window and code the application.
b. Save the solution and then start the application. Use the application to answer the following questions:
How many trips were made from Nashville to Chicago?
How many trips were made from Atlanta to Los Angeles?
How many business trips were taken?
How many pleasure trips were taken?
c. Close the Code Editor window and then close the solution.
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
