Answer Happy

MIS 101 - Assignment 2 432 Open Dammam Studios Database. 1. Open the DVD table and create a report including all its fields. 2. Create the following report (fig-1) from the DVD table and name it DVD Report_Your name & ID. (2 marks) DVD DVD DVD Wednesday, April 26, 2017 12:19:43 PM DVD ID Title Genre Director Rental Cost 1 Blue Streak Action Les Mayfield Christopher Nolan Rating Year Released Starring 6 9/17/1999 Martin Lawrence 9 8/16/2010 Leonardo DiCaprio C.00 2 Inception Action €2.50 3 Toy Story 3 Animation Lee Unkrich 9 €2.50 4 Rush Hour 3 Action 6 21.00 5 50/50 Comedy Brett Ratner Johnathan Levine John Singleton 8 €3.00 6 Abduction Action 4 63.00 7 Warrior Action Gavin O'Conner 23.00 David Frankel 6 €3.00 8 The Big Year 9 Johnny English Reborn 10 in Time Comedy Adventure 6 03.00 8/19/2010 Tom Hanks 9/10/2007 Jackie Chan 9/30/2011 Seth Rogan 9/28/2011 Taylor Lautner 9/23/2011 Tom Hardy 12/2/2011 Jack Black 10/7/2011 Rowan Atkinson 11/1/2011 Justin Timberlake 10/7/2011 Owen Wilson 10/9/1991 Robby Benson 9/16/2011 Ryan Reynolds 1/13/2012 Emily Watson 1/27/2012 George Clooney 9/23/2011 Ryan Gosling Action 7 Oliver Parker Andrew Niccol Woody Allen Kirk Wise €3.00 Comedy 8 3.00 €0.50 11 Midnight in Paris 12 Beauty and the Beast 13 The Change-Up 14 War Horse David Dobkin 6 63.00 Animation Comedy Drama Comedy Steven Spielberg 7 6.50 15 The Descendants Alexander Payne 8 €3.50 16 Drive Thriller 8 8 3.00 Nicolas Winding Refn Bill Condon 8 11/18/2011 Robert Pattinson 63.00 17 Twilight Saga: Breaking Adventure Dawn - Part 1 18 Casino Royale Action 8 EL.00 Martin Campbell Martin Scorsese 11/17/2011 Daniel Craig 10/6/2006 Leonardo DiCaprio 19 The Departed Drama 8 €1.00 Fig -1- DVD Report 3. Group the DVDs according to their Ratings and sort them according the DVD ID. Save the new report as Sorted DVD Report_Your name & ID. (4 marks) 4. Filter the Rental Cost, so that only titles that are equal or less than 1 Pound are displayed. Save this as Less than 1 Report_your name & ID. (2 marks) 5. Open the DVD Report and format the Rental Cost so that all values between 2-3 are in red font. (2 marks)
6. Create a form by design based on the Booking Table. Ensure that all the fields in the figure below are inserted and you organize your form so it looks like the same as fig 2. Name your form as Booking Form_Your name & ID. (4 marks) > 1:14 OVOD so/ . и но Customer Number on Fig 2 - DVD Form Save your work as your First Names and your IDs and submit to blackboard