Microsoft access database management Help (questions 17-25) It's broken up into 5 posts for chegg's "sub-parts guidelines': Will upvote all 5 answers on each of the 5 posts for your help!
1. Open Access and create a database called, "Movie Favorites." Create the Film Favorites table in Design view using the structure shown below: Structure of Film Favorites table Field Name Primary Key Description VideoID Yes Data Type Field Size Short Text Short Text 25 Short Text 4 Short Text 15 Primary Key Name of Movie Movie Title YrRisd Year Movie Released FirstName Lead Actor's First Name LastName Short Text 25 Lead Actor's Last Name PurchasePrice Currency Price of Movie 4. Save the Film Favorites table Open the Film Favorites table in datasheet view. Enter the following information in the Film Favorites Table under the appropriate fields VideoID 01 02 First Name your first name Daniel Reese Drew 03 04 Yr Risd 2016 2000 1999 1993 1998 1998 1999 1999 Tom Neve Movie Title Access 2016 Harry Potter Legally Blonde ET Castaway Scream Leaving Normal Titanic Independence Day Mulan Jurassic Park III Men In Black Tarzan Moulin Rouge Meg 05 06 07 08 09 10 11 12 13 14 Last Name Purchase Price your last name $65 Radcliffe $29.95 Witherspoon $20.00 Barrymore $9.99 Hanks $14.99 Campbell $10.00 Tilly $32.95 Winslet $35.99 Smith $29.95 Close $9.99 O'Neill $29.99 Jones $29.99 Driver $19.99 Kidman $49.99 Kate Will 1998 2001 2000 1999 2000 Glenn Sam Tommy Lee Minnie Nicole Run spell check on the table. 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 Name Data Field Primary Key Description Type Size CustID Yes Primary Key VideoID Movie ID Short Text Short Text Short Text Short Text Customer FirstName First Name of Customer Customer LastName tetomerlast Name Last Name of Customer MovieTitle Short Name of Movie Text PurchasePrice Quantity Currency Number Price of Movie Number of items ordered 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: CustID VideoID 01 Customer Customer First Name Last Name your first name your last name John Smith Mary Jackson Belle Stevens 02 07 11 Purchase Price $65 29.95 $32.95 $9.99 Movie Title Access 2016 Harry Potter Leaving Normal Jurassic Park III 13. 14. Run spell check on the table. Sort the table in ascending order by Title of the movie. Adjust the columns to best fit the data. Close and save the Orders table. 16. 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. Save the one-to-many relationship. 18. 19. Using the Film Favorites table, create a query for all movies released after 1997 and costing >$20.00. Show the Movie Title, Year Released, and Purchase Price. 20. 21. Adjust the columns to best fit the data. Save this query as Movies Released After 1997. Close the query. 22. Modify the existing Movies Released After 1997 query for movies released before 1997 and costing $20.00. Show the Movie Title, Year Released, and Purchase Price. 20. 21. Adjust the columns to best fit the data. Save this query as Movies Released After 1997. Close the query. 22. Modify the existing Movies Released After 1997 query for movies released before 1997 and costing
