1.Open Access and create a database called, "Movie Favorites." 2.Create the Film Favorites table in Design view using the structure shown below: Structure of Film Favorites table Field Name VideoID MovieTitle YrRisd FirstName Data Type Field SizePrimary KeyDescription Short Text 2 Short Text 25 Short Text 4 Short Text 15 Primary Key Name of Movie Year Movie Released Lead Actor's First es Name Lead Actor's Last Name Price of Movie LastName Short Text 25 PurchasePrice Currency Save the Film Favorites table Open the Film Favorites table in datasheet view Enter the following information in the Film Favorites Table under the 4 appropriate fields VideoID Movie Title Yr Rlsd 2016 2000 1999 1993 1998 1998 First Name your jirst nameyour last name Daniel Reese Drew Last Name 0 Access 2016 02 Harry Potter 03 Legally Blonde 04 ET 05 Castaway 06 Scream 07 Leaving Normal 08 Titanic 09 Independence Day 1999 Will 10 Mulan 11 Jurassic Park III 12 Men In Black 13 Tarzan 14 Moulin Rouge Purchase Price S65 S29.95 S20.00 9.99 $14.99 S10.00 S32.95 S35.99 S29.95 S9.99 S29.99 S29.99 S19.99 S49.99 Radcliffe Witherspoon Barrymore om Campbell Till Winslet Neve 1999 Meg 1999 1998 2001 2000 1999Minnie 2000 Kate Glenn Tommy Lee ose O'Neill Jones Driver Kidman icole Run spell check on the table. 7.Sort the table in ascending order by Title of the movie Adjust the columns to best fit the data. Close and save the Film Favorites table. 10. Create the Orders table in Design view using the structure shown below. Structure of Orders table Field Size Field Name Data Type Short Text Short Text Primary Key Description Primary Key Movie ID First Name of Customer Last Name of Customer CustID Yes VideoID CustomerFirstName Short CustomerLastName Short 15 Text 20 Text Short Text Currency Number MovieTitle 25 Name of Movie Price of Movie Number of items ordered Quantity 11.Save the Orders table 12. Open the Orders table in datasheet view Enter the following information in the Orders Table under the appropriate fields Customer Purchase Price S65 29.95 S32.95 S9.99 Customer CustID VideolD First Name Last Name Movie Title 20 21 25 27 0 your first name your last name ss 2016 02 John 07 Mary 1 Belle Smith Jackson Stevens Harry Potter Leaving Normal Jurassic Park 13.Run spell check on the table. 14. Sort the table in ascending order by Title of the movie 15.Adjust the columns to best fit the data. 16. Close and save the Orders table. 17. Define a one-to-many relationship between the Film Favorites table and the Orders table using the VideoID field. Select the Enforce Referential Integrity option and the Cascade Update Related Fields option for the relationship 18.Save the one-to-many relationship 19. Using the Film Favorites table, create a query for all movies released after 1997 and costing S20.00. Show the Movie Title, Year Released, and Purchase Price 20. 21. 22. Adjust the columns to best fit the data. Save this query as Movies Released After 1997. Close the query 23. Modify the existing Movies Released After 1997 query for movies released before 1997 and costing