Practical Assignment ComputerAPPS.pdf

A type the slide title as tea health effects and

This preview shows page 6 - 9 out of 9 pages.

a)Type the slide title as, "Tea & Health effects" and format it as, 1. Immunity against intestinal disorders. 2. Prevention of dental caries. [10 marks]
Image of page 6

Subscribe to view the full document.

7 Q3 Code: P01 Index No:…………………………………. 5. In the third slide, add the following components. a) Type the slide title as, "Statistics" [02 marks] b) Insert the following table Country Percentage China 48% India 39% Sri Lanka 13 % [15 marks] 6. In the fourth slide, add the following components. a) Type the slide title as, "Production as a Chart". [02 marks] b) Draw a Pie chart as given below using the tabulated data given in the third slide. [10 marks] 7. Add the following animation effects to your presentation. a) Apply emphasis animation effect to each main point and sub point in the second slide. [04 marks] b) Apply sound effect when the second slide appears in the slideshow. [02 Marks] c) Hide the third slide from the slide show. [02 Marks] d) Save your presentation with the following file name < Your Index Number>_ P01 and upload it to the online e-testing system. [03 Marks]
Image of page 7
8 Q4 Code: A01 Index No:…………………………………. You are supposed to create and save a database with tables, relationships, queries and reports using MS Access 2007, according to the instructions given below. 1. You need to create a database for a public library to store book details. For this, create a blank database and save it with your index number and the Question code. Eg: <Your Index Number> _A01 [05 Marks] 2. Create a table called “ Books ” with the following fields. [20 Marks] Field Name Type Field size Constraints ID Number Primary Key Title Text field 50 characters Description Text field 30 characters Category Number No of copies Number 3. Create a form to enter details about books and save it as “ Books Form ”. [10 Marks] 4. Add following records to the “ Books ” table using the “ Books Form ”. [10 Marks] ID Title Description Category No of copies 1 Word Hard cover 2 2 2 Computers Hard cover 4 2 3 Access Paperback 2 2 4 Art Hard cover 1 1 5 Science Paperback 3 1 5. Create another table called “ Book Copies ” with the following fields. [15 Marks] Field Name Type ID Number Book _ID Number ISBN Number Version Number
Image of page 8

Subscribe to view the full document.

9 Q4 Code: A01 Index No:…………………………………. 6.Identify the Primary Key(s) of this table (if there is any). [05 Marks] 7. Insert following records to the “ Book Copies ” table. [05 Marks] ID Book_ID ISBN Version 1 1 1234 1 2 1 1235 2 3 2 1236 1 4 2 1237 3 5 3 1238 2 6 3 1239 3 7 4 1241 4 8 5 1242 7 8. Establish the Relationship between “ Books ” and “ Book Copies ” tables. [10 Marks] 9. Write a query called “ Query_Book category ” to display all books which belongs to given category; E.g. Category 02. [10 Marks] 10. Create a report called “ Book Details ” using the following format and save it. [10 Marks] 11. Save your database again and upload it to e-testing system. Make sure you have saved the document as follows: <Your Index Number>_A01
Image of page 9
  • Fall '16
  • Mwangi
  • Visual Basic for Applications, Academy Awards

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern