Scribd
Upload
14 views3 pages

ICT - Mock Paper2 - Grade 8 - AE - QP

The document is a mock paper for Grade 8 students on MS Access, focusing on creating a database for a pet store. It outlines tasks such as creating tables for pets and owners, inserting records, establishing relationships between tables, and generating queries and forms. Students are required to provide screenshots of their work as evidence.

Uploaded by

meera.harshal.shah
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
14 views3 pages

ICT - Mock Paper2 - Grade 8 - AE - QP

The document is a mock paper for Grade 8 students on MS Access, focusing on creating a database for a pet store. It outlines tasks such as creating tables for pets and owners, inserting records, establishing relationships between tables, and generating queries and forms. Students are required to provide screenshots of their work as evidence.

Uploaded by

meera.harshal.shah
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Grade 8

Mock Paper on MS Access

Q. 1 The manager of a local pet store needs to keep track of information about the pets sold

and their owners. (Use the Word document- “Pet Store” for answering the questions).

a) Create a database and name it as “Pet Store”.

b) Create following two tables in the above database.

(i) Create a table named Pets with the following fields.


Field Name Datatype

PetID Number

PetName Short Text

Species Short Text

Age Number

(ii) Make PetID field the primary key.

(iii) Insert the following records in the above table.

PetID PetName Species Age

101 Whiskers Cat 3

102 Fido Dog 5

103 Polly Parrot 7

104 Shelly Turtle 10

105 Goldie Goldfish 1


(iv) Create a table named Owners with the following fields.
Field Name Datatype

OwnerID Number

PetID Number

CustomerNam Short Text


e

Phone Short Text

(v) Make OwnerID field the primary key.

(vi) Insert the following records in the above table.


OwnerID PetID CustomerName Phone

1001 101 John Doe (555) 555-1212

2002 102 Jane Smith (555) 555-2222

3003 103 Michael Lee (555) 555-3232

4004 104 Sarah Garcia (555) 555-4242

5005 105 David Hernandez (555) 555-5252

c) Create relationship between the above created tables by linking the field “PetID” from
“Pet” Table and “PetID” from “Owners” Table.

d) Create a query to display the data from both the tables

(i) With following fields: PetID, PetName, Species, Age, CustomerName and Phone.

(ii) Having criteria Age > 5.

e) Create form using the Owners table.

Please take the screen shorts of both the tables -Pet & Owners, relationship,
query output and the form created and paste it in the evidence document.

You might also like