* Deliverable: One MS Access le only. Ensure that you submit only one database which will contain all the required database objects. * For Each database object you create (e. g., table, query, or report), right click on its icon in the Navigation pane, click 'View properties' [or 'Object Properties' or 'Table Properties'], and then in the 'Description' window, enter a short description of about 40 words regarding how you created that database object. Setting: This is a ctitious body of students set in 2015. These students are set to go on trips (vacations) to various destinations. As can be seen from the two tables in the Microsoft Excel document, each trip has its destination, departure date, return date, and cost, and furthermre, each student has made a deposit towards the nal cost of their trip. Carry out the following 5 tasks using the Microsoft Access application: 1. Import the data from the excel spreadsheet 'Travel 4. Create a report based on the balance of the students great only the below 6 fields]: Students Outstanding Balance greater Wednesday, December 12, 20 15 than $2000 10:21:56 AM Trip ID First Name Last Name Deposit Paid Cat of Trip Outstanding Balance T-02 Florence Zimmerman $1,000 $5,000 $4,000.00 T-02 Jama Hardy $1,500 $5,000 $3,500.00 T-02 Marianne Berguin $2,500 $5,000 $3,500.00 T-02 Moniquin Let $2,500 $5,000 $3,500.00 T-03 Donald Hanby $2,000 $4,500 $3,500.00 T-06 Marilyn Youron $3,000 $5,000 $3,000.00 T-07 Carlito Ramos $2,700 $5,400 $3,700.00 T-08 Prince Flite of t $1,600 $4,300 $3,700.00 T-10 Hendrick Themis $2,500 $7,250 $4,750.00 T-10 Kirsten Riccardi $4,500 $7,250 $2,750.00 T-10 Llord Murphy $5,000 $7,250 $3,250.00 T-11 Andrew Le $3,000 $5,600 $3,600.00 T-11 Caitlyn Hardy $2,800 $5,600 $3,800.00 T-12 Christopher Danko $5,500 $7,580 $3,080.00 T-12 Zack Rowe $2,000 $7,580 $5,580.00 T-13 Shawn Boulward $2,600 $4,950 $2,150.00 T-14 Kevin Leopoldo $3,500 $5,000 $3,500.00 T-15 Darrin Campbell $1,000 $4,750 $3,780.00 T-15 Stephan Elraheb $2,500 $4,750 $3,250.00 $107,520 $56,920 PageStudents Outstanding Balance greater Wednesday, December 12, 2018 than $2000 1021:35 AM Tup ID First Name Last Name Deposit Paid Cat of Tap Outstanding Balance 7-03 Flareice $1,000 $4,000.00 T-02 Jamal Hardy $1,500 $5,00 $3,500.00 T-02 Marianme Berguin $2,500 $5,000 $2,500.00 7-02 Left 32,500 $5,000 13,500.00 7-03 Donald Manby $3,000 $4,500 $2,500.00 T-05 Maryz Youson 33,000 $6,00 $3,000.00 T-07 Carlo Ramos 32,700 35,400 $2,700.00 Prince Flite of $1,600 $4,300 $2,700.00 T-10 Hendrick Themis $2,300 57 ,250 $4,750.00 7-10 Kins tens Riccard $4,300 57 ,250 $3,750.00 T -10 Lord $5,000 52,250.00 7-11 Andrew Le $3,000 $5,800 $3,600.00 Hardy $3,800 $5, 600 $3,800.00 T-12 Ches topher Danko $5,300 57,580 $2,080.00 T-12 Zack Rome $3,000 57 ,580 $5,580.00 Bod ward 52,800 $4,950 $2,150.00 T - 14 Kens $3,300 $5,000 $2,300.00 T-15 Darsia Campbell 51,000 34,780 13,780.00 T-15 Stephan $2,500 $4,730 $2,280.00 $107,820 $36,9 20 Page 5. Using Queries for Calculations. Perform a calculation of your choice and create a new field in which to store it. [This portion of the assignment will be unique to you] See the section, "Calculating by using queries" in the Microsoft Access Reference book previously referred to (see pages 212-217 of the file, 'access2013.pdf' available in the 'Files' section of canvas). Use an expression [of your choice] in a query to compute the desired information from the table(s) you have imported for this assignment. Use the MS Access 'Expression Builder' function which has Expression Elements, Expression Categories and Expression Values. Clearly state what information you intended to derive, the MS Access expression(s) you needed, and how you went about performing the calculation(s). Save the query as 'firstnamelastnamepersonalquery5' and save it in the same database. Running the query should create a new field, using one or more of the existing fields in your calculation (for example, an employee database can be used to calculate yearly bonus or number of years in the company, based on data already in the database).* Deliverable: One MS Access le only. Ensure that you submit only one database which will contain all the required database objects. * For Each database object you create (e. g., table, query, or report), right click on its icon in the Navigation pane, click 'View properties' [or 'Object Properties' or 'Table Properties'], and then in the 'Description' window, enter a short description of about 40 words regarding how you created that database object. Setting: This is a ctitious body of students set in 2015. These students are set to go on trips (vacations) to various destinations. As can be seen from the two tables in the Microsoft Excel document, each trip has its destination, departure date, return date, and cost, and furthermre, each student has made a deposit towards the nal cost of their trip. Carry out the following 5 tasks using the Microsoft Access application: 1. Import the data from the excel spreadsheet 'Travel Information.xlsx' (two sheets); Create two Tables: E Travel Information\\ Field Name Data Type Trip ID Short Text Destination Short Text Cost of Trip Currency _ Departure Date Date/Time Return Date Date/Time Contact Last Name Short Text _ Contact First Name Short Text Phoneiit Short Text [ E Students ' Field Name Data Type 3 rStudentlth Short Text _First Name Short Text Last Name Short Text VTrip ID Short Text 7' Deposit Paid Currency Date Paid Date/Time H 2. [In regard to the upcoming trips] Create a query that shows only the students' outstanding balance(s) greater than $2000. Students Outstanding Balance greater than 2000 Trip ID . First Name . Last Name . Deposit Paid . Cost of Trip . Outstanding . T-02 Florence Zimmerman $1,000 $5,000 $4,000.00 T-02 Jamal Hardy $1,500 $5,000 $3,500.00 T-02 Marianne Berguin $2,500 $5,000 $2,500.00 T-02 Moniquin Lett $2,500 $5,000 $2,500.00 T-03 Donald Hanby $2,000 $4,500 $2,500.00 T-06 Marilyn Youson $3,000 $6,000 $3,000.00 T-07 Carlito Ramos $2,700 $5,400 $2,700.00 T-08 Prince Flitcroft $1,600 $4,300 $2,700.00 T-10 Hendrick Themis $2,500 $7,250 $4,750.00 T-10 Kirsten Riccardi $4,500 $7,250 $2,750.00 T-10 Lloyd Murphy $5,000 $7,250 $2,250.00 T-11 Andrew Lee $3,000 $5,600 $2,600.00 T-11 Caitlyn Hardy $2,800 $5,600 $2,800.00 T-12 Christopher Danko $5,500 $7,580 $2,080.00 T-12 Zack Rowe $2,000 $7,580 $5,580.00 T-13 Shawn Boulward $2,800 $4,950 $2,150.00 T-14 Kevin Leopoldo $2,500 $5,000 $2,500.00 T-15 Darxia Campbell $1,000 $4,780 $3,780.00 T-15 Stephan Elraheb $2,500 $4,780 $2,280.00 Total $50,900 $107,820 $56,920.00 3. Create a query that shows the following student travel statistics: Total Number of Trips; Total Cost of all Student Trips; Total Amount of Deposits Paid; Total Outstanding Balance; Average Trip Cost. 4. Create a report based on the query of outstanding balance of the students greater than $2000. [Show only the below 6 fields]: Students Outstanding Balance greater Wednesday, December 12, 20 15 than $2000 10:21:35 AM Trip ID First Name Let Name Deposit Paid Cat of Trip Outstanding Flaace Zimmerman $1,000 $5,000 $4,000.00 T-02 Jamal Hardy $1,500 $5,000 $3,500.00 T-02 Marianne Bergui $2,500 $5,000 $3,500.00 32,500 $5,000 $2,500.00 $3,000 $2,500.00 T-06 Maryz Youso $3,000 $6,000 $3,000.00 T-07 Carlito Ramos $2,700 $5,40 $2,700.00 T-05 Prince Flite oft $1,600 $4,300 $3,700.00 T-10 Hendrick $2,300 $7 ,250 $4,750.00 $4,300 $7,250 $3,750.00 T-10 Lord $5,000 $7 ,250 $3,250.00 Andrew $3,000 35,600 $2,600.00 T-11 Hardy $2,500 $5,600 $2,800.00Balance; Average Trip Cost. 4. Create a report based on the query of outstanding balance of the students greater than $2000. [Show only the below 6 fields] Students Outstanding Balance greater Wednesday, December 12, 20 18 than $2000 1021:36 AM Trip ID First Name Lut Name Deposit Paid Cat of Tap Outstanding Balance T-03 Fla mice $1,000 $5,000 $4,000.00 T-02 Jamaal Hardy $1,500 $5,000 $3,300.00 T-02 Marianne Bergwin $3,500 $5,000 $2,500.00 T-02 Momiquin Lett 52.500 $5,000 52,500.00 7-03 Donald Hamby $3,000 $4,500 $2,500.00 7-06 Youson $3,000 $6,000 $3,000.00 T-07 Carkto Ramos $2,700 $5,400 $2,700.00 T-08 Prince Flite of $1,600 $4,30 $2,700.00 T-10 Hendrick Themis 52,500 $4,730.00 T-10 $4,500 $2,750.00 7-10 Lord $5,000 $3,250.00 $3,000 85,800 $2,800.00 T-11 Hasdy 53,800 $5,600 $2,800.00 T- 12 Chez topher Danko $5,500 57,380 $2,080.00 7-13 Zack Rome $2,000 $7,580 $5,580.00 7-13 Boud ward 52,800 $4,950 $2,150.00 Leopoldo 53,300 $5,000 $3,500.00 T-15 Campbell $1,000 $4,780 $3,750.00 T-15 Suphas Exsheb $3,300 $4,750 $2,200.00 $107,820 $ 36,9 20 Page 5. Using Queries for Calculations. Perform a calculation of your choice and create a new field in which to store it. [This portion of the assignment will be unique to you] See the section, "Calculating by using queries" in the Microsoft Access Reference book previously referred to (see pages 212-217 of the file, 'access2013.pdf' available in the 'Files' section of canvas). Use an expression [of your choice] in a query to compute the desired information from the table(s) you have imported for this assignment. Use the MS Access 'Expression Builder' function which has Expression Elements, Expression Categories and Expression Values. Clearly state what information you intended to derive, the MS Access expression(s) you needed, and how you went about performing the calculation(s). Save the query as "firstnamelastnamepersonalquery5' and save it in the same database. Running the query