microsoft access 495245

DEPARTMENT OF ACCOUNTING, FINANCE & ECONOMICS 7150AFE Business Information Systems MS ACCESS PROJECT (DATABASES) (TOTAL MARKS = 10) This project requires you to demonstrate knowledge of databases using MS Access. It covers the following database concepts: ? Use of Primary and Foreign Keys ? Understanding and using cardinalities ? Understanding and defining relationships ? Developing queries using appropriate tools ? Creating forms for data entry ? Producing reports for use by management PREPARATION Review database lectures (weeks 9 and 10) and workshop materials (weeks 10 to 13) and complete any outstanding workshop activities prior to commencing with this project. Also review all supplementary videos and/or documents (available via the Course Activity Centre). PROJECT PART ONE (8 Marks) Task Activity Mark 1 Download the VideoRental_student database file from L@G Save your database file as lastname_student_id_project_3_videorental (NOTE: Regularly SAVE your database as you complete individual tasks). -2 Familiarize yourself with the tables and data provided. The following relationships apply to the Customers, VideoRentals and Movies tables: ? A customer can rent many movies ? A movie can be rented by many customers (Take note of the one-to-many relationships.) Using this information to establish appropriate relationships amongst the Customers, VideoRentals and Movies tables. Ensure that you Enforce 0.5 Task Activity Mark Referential Integrity for all relationships. 3 Create a query saved as Expired Credit Cards that shows the ID, Name, Address, Phone Number, and Credit Card Expiration date for all customers with credit cards expiring in January, February and March 2013. Sort by month in ascending order. (Hint: cc expiration field is text). 0.5 4 Create a query saved as Best of the Best New Movies that shows the ID, Title and IMDB Rating for all movies with an IMDB rating of 8.5 or higher, and were released after 2009. Sort by Year in descending order. 0.5 5 Create…