Note: This Assignment accounts for 30% of the student's final grade. Instructions: Summer 1- 2020 Before you answer this Ms. Asal, Mr. Shady 1) Each student should work independently of the other students. 2) This assignment should be submitted on the due date, zero mark will follow late submission of an assignment 3) This assignment contains two separate questions the first related to the PowerPoint presentation and the second related to the database Access. 4) Student cannot use any example from the class or lab exercises already done, but he/she should suggest another different example. 5) You are required to submit three files (PowerPoint file for the first question, the Access file for the second question and the word file for the Answer Sheet) in softcopy through the Tumitin which is available at the Moodle Website https://ms.ectmoodle.ae. Question 1: PowerPoint presentation [10 Marks] Slide #1 Insert the screens 000 NISSAN Name: Saeed Mohammed 10:3M5.2006 NISSAN hot here 5) You are required to submit three file PowerPoint file for the finishe.com file for the second to the word file for the weight the Tumita which is able at the Moodle Website mesmediar Question 1: PowerPoint presentation no Martel NISSAN NISSAN Insert the Nissan GTR Nissan Sport Cars Offroad Cars Nissan shot here NISSAN the creme here the screenshot here mert the there Structure and Database 120 Marks Part 1 - File and data structure 1. Based on your answer for the best. A.2) below, explain bow the and tee them into Marke) Write your answer kere 2. Suppose you have a collection of data Ben similar data typendye have to we inted list data structure. Specify how you can access the elements in each of them dowie data we word in the main memory Marks) Write your answer here Part 2 - Database Access A Tables L. Create a new Access Sleeve will you mea. 25 Marko 2. Create with Gold win that you wees An Gelewa different date types. (Marka: 65 for primary key, 1 for each fell Insert the design view robot of the table 4. Strecord in the table. Mark) Insert the openview screenshot of the table Queries Crite the following quribde you wil 1. Quy that is all fields of your table that have e fiqul topis Query1 Mar 0.5 and 6.5 for Imert the design view screenshot of the query 2. A query that diaplan upacidic Finld of your table with Sind as avale is a great Save it Quy 2. Marka: 6.5 for fields and 0.5 for criterina) Insert the design view of the query 3. A quay that impecabice Side of your table that have two come with and", ce constant should be so dare. Save it as Query 3.2 Marks: 6.5 fue des Insert the design view of the A query that specifies fields of your table that have come with se construit should compare a string value to apo See as Queryt. Mures fields and for first criterio 0.5 forced crime and for the relatie Structure and Database 120 Marks Part 1 - File and data structure 1. Band as you www for the best wishes the file with a Marko Write your answer here 2. Suppose you have a collection of data from umilar det type and you have to lined list des struct Specify how you the elements in each of the end data and is the main mayMarks) Write your answer here Part 2 - Database Access A Tables 1. Create Accesie und mit walk you meandD25 Mark 2. Create a ble with frid to hold my dat you want. All field be different data types Marks: 25 for primary key. I for each fell Insert the design view of the white 4 en records in the table. (0.5 Mark) Imert the com View screenshot of the we Queries Create the following queries based on your table 1 Quary that vier's all fields of your table that have se field equal to paciente Soeka Query Mar 0.5 kl.footer) Ime the desigaviewer el tie query 2. A query that displays specific fields of your table with the file has a value is reales Save as Query 2. Marks: 0.3 for fields and 0.3 for criteria) Imert the desigaviewershot of the query 2. A query the views specific fields of your table that eve costs who de construit should be about de Save it Quy Marke: 5 funds Imert the design view shot of the way A query that specific fields of your table that he was with concomitent should comparing vale to patien. Seit Marke Gelded 6.5 for fint criteris, for sed criteria for the relatie Insert the design view of them C.Forms Cate a Tabular om at all code and other Of Mark: 6.25 for lys for file for change Insert the view role of the form D. Reports 1. Create a Block report and on your table that view all fienti chied by the many calories and son the records in ascending onder de specified Seebergen by you somer Marka: 6.5 for Layout 0.5 forfald, for the fores 2. forting and my car Imert the open view crochet of the sport Part 2 - Database Access A. Tables 1. Create a new Access file and save it with your name and ID. (0.25 Mark) 2. Create a table with S fields to hold any domain that you suggest. All fields should be with different data types. (5 Marks: 0.5 for primary key, 1 for each field) Insert the design view screenshot of the table 4. Insert 6 records in the table. (0.5 Mark) Insert the open view screenshot of the table Queries Create the following queries based on your table: 1. Query that views all fields of your table that have one field equal to pecific value Save it as Query 1. (1 Marks: 0.5 for fields and 0.5 for criterion) Insert the design view screenshot of the query 2. A query that displays specific fields of your table with the field has a value in a range of values. Save it as Query2. (1 Marks: 0.5 for fields and 0.5 for criterion) Insert the design view screenshot of the query 3. A query that views specifics fields of your table that have two constraints with relationship "and", one constraint should be about date. Save it as Query3. (2 Marks: 0.5 for fields and 0.5 Insert the design view screenshot of the query 4. A query that views specifics fields of your table that have two constraints with relationship"or". one constraint should compare a string value to a pattern. Save it as Query4 (2 Marks: 0.5 for fields and 0.5 for first criterion, 0.5 for second criterion and 0.5 for the relationship) Insert the design view screenshot of the query C. Forms 1. Create a Tabular Form that views all records based on one of the above queries. Save the form by "Query_form_yeuname". 1 Mark: 0.25 for layout, 0.25 for fields and 0.5 for change title) Insert the open view screenshot of the form D. Reports 1. Create a Block report based on your table that views all information classified by one field with any summary calculation and sort the records in ascending order according to a specific field Save the report by "your name_Report". (3 Marks: 0.5 for layout, 0.5 for fields, 0.5 for the title 0.5 for grouping, 0.5 for sorting and 0.5 for summary calculation) Insert the open view screenshot of the report Note: This Assignment accounts for 30% of the student's final grade. Instructions: Summer 1- 2020 Before you answer this Ms. Asal, Mr. Shady 1) Each student should work independently of the other students. 2) This assignment should be submitted on the due date, zero mark will follow late submission of an assignment 3) This assignment contains two separate questions the first related to the PowerPoint presentation and the second related to the database Access. 4) Student cannot use any example from the class or lab exercises already done, but he/she should suggest another different example. 5) You are required to submit three files (PowerPoint file for the first question, the Access file for the second question and the word file for the Answer Sheet) in softcopy through the Tumitin which is available at the Moodle Website https://ms.ectmoodle.ae. Question 1: PowerPoint presentation [10 Marks] Slide #1 Insert the screens 000 NISSAN Name: Saeed Mohammed 10:3M5.2006 NISSAN hot here 5) You are required to submit three file PowerPoint file for the finishe.com file for the second to the word file for the weight the Tumita which is able at the Moodle Website mesmediar Question 1: PowerPoint presentation no Martel NISSAN NISSAN Insert the Nissan GTR Nissan Sport Cars Offroad Cars Nissan shot here NISSAN the creme here the screenshot here mert the there Structure and Database 120 Marks Part 1 - File and data structure 1. Based on your answer for the best. A.2) below, explain bow the and tee them into Marke) Write your answer kere 2. Suppose you have a collection of data Ben similar data typendye have to we inted list data structure. Specify how you can access the elements in each of them dowie data we word in the main memory Marks) Write your answer here Part 2 - Database Access A Tables L. Create a new Access Sleeve will you mea. 25 Marko 2. Create with Gold win that you wees An Gelewa different date types. (Marka: 65 for primary key, 1 for each fell Insert the design view robot of the table 4. Strecord in the table. Mark) Insert the openview screenshot of the table Queries Crite the following quribde you wil 1. Quy that is all fields of your table that have e fiqul topis Query1 Mar 0.5 and 6.5 for Imert the design view screenshot of the query 2. A query that diaplan upacidic Finld of your table with Sind as avale is a great Save it Quy 2. Marka: 6.5 for fields and 0.5 for criterina) Insert the design view of the query 3. A quay that impecabice Side of your table that have two come with and", ce constant should be so dare. Save it as Query 3.2 Marks: 6.5 fue des Insert the design view of the A query that specifies fields of your table that have come with se construit should compare a string value to apo See as Queryt. Mures fields and for first criterio 0.5 forced crime and for the relatie Structure and Database 120 Marks Part 1 - File and data structure 1. Band as you www for the best wishes the file with a Marko Write your answer here 2. Suppose you have a collection of data from umilar det type and you have to lined list des struct Specify how you the elements in each of the end data and is the main mayMarks) Write your answer here Part 2 - Database Access A Tables 1. Create Accesie und mit walk you meandD25 Mark 2. Create a ble with frid to hold my dat you want. All field be different data types Marks: 25 for primary key. I for each fell Insert the design view of the white 4 en records in the table. (0.5 Mark) Imert the com View screenshot of the we Queries Create the following queries based on your table 1 Quary that vier's all fields of your table that have se field equal to paciente Soeka Query Mar 0.5 kl.footer) Ime the desigaviewer el tie query 2. A query that displays specific fields of your table with the file has a value is reales Save as Query 2. Marks: 0.3 for fields and 0.3 for criteria) Imert the desigaviewershot of the query 2. A query the views specific fields of your table that eve costs who de construit should be about de Save it Quy Marke: 5 funds Imert the design view shot of the way A query that specific fields of your table that he was with concomitent should comparing vale to patien. Seit Marke Gelded 6.5 for fint criteris, for sed criteria for the relatie Insert the design view of them C.Forms Cate a Tabular om at all code and other Of Mark: 6.25 for lys for file for change Insert the view role of the form D. Reports 1. Create a Block report and on your table that view all fienti chied by the many calories and son the records in ascending onder de specified Seebergen by you somer Marka: 6.5 for Layout 0.5 forfald, for the fores 2. forting and my car Imert the open view crochet of the sport Part 2 - Database Access A. Tables 1. Create a new Access file and save it with your name and ID. (0.25 Mark) 2. Create a table with S fields to hold any domain that you suggest. All fields should be with different data types. (5 Marks: 0.5 for primary key, 1 for each field) Insert the design view screenshot of the table 4. Insert 6 records in the table. (0.5 Mark) Insert the open view screenshot of the table Queries Create the following queries based on your table: 1. Query that views all fields of your table that have one field equal to pecific value Save it as Query 1. (1 Marks: 0.5 for fields and 0.5 for criterion) Insert the design view screenshot of the query 2. A query that displays specific fields of your table with the field has a value in a range of values. Save it as Query2. (1 Marks: 0.5 for fields and 0.5 for criterion) Insert the design view screenshot of the query 3. A query that views specifics fields of your table that have two constraints with relationship "and", one constraint should be about date. Save it as Query3. (2 Marks: 0.5 for fields and 0.5 Insert the design view screenshot of the query 4. A query that views specifics fields of your table that have two constraints with relationship"or". one constraint should compare a string value to a pattern. Save it as Query4 (2 Marks: 0.5 for fields and 0.5 for first criterion, 0.5 for second criterion and 0.5 for the relationship) Insert the design view screenshot of the query C. Forms 1. Create a Tabular Form that views all records based on one of the above queries. Save the form by "Query_form_yeuname". 1 Mark: 0.25 for layout, 0.25 for fields and 0.5 for change title) Insert the open view screenshot of the form D. Reports 1. Create a Block report based on your table that views all information classified by one field with any summary calculation and sort the records in ascending order according to a specific field Save the report by "your name_Report". (3 Marks: 0.5 for layout, 0.5 for fields, 0.5 for the title 0.5 for grouping, 0.5 for sorting and 0.5 for summary calculation) Insert the open view screenshot of the report