Scribd
Upload
4 views2 pages

Y7 Computing Practical: MS Access Database

This document outlines a practical task for Year 7 Computing students at Pakistan International School Jeddah, focusing on data input, collection, and validation using MS Access. Students are instructed to create a database named 'School System', design a table for student information, and input specific records. The task includes taking screenshots of the design and datasheet views as evidence of completion.

Uploaded by

muhammad.shaheer9
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views2 pages

Y7 Computing Practical: MS Access Database

This document outlines a practical task for Year 7 Computing students at Pakistan International School Jeddah, focusing on data input, collection, and validation using MS Access. Students are instructed to create a database named 'School System', design a table for student information, and input specific records. The task includes taking screenshots of the design and datasheet views as evidence of completion.

Uploaded by

muhammad.shaheer9
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Pakistan International School Jeddah - English Section

Y7-Computing
Unit 8.5: Data Input: data collection and validation

Practical Task 6 – Final Term Total marks: 15 Obtained marks:

Name: Student ID: Y7 -____

Databases are built to store data and meet user requirements

1. Open MS Access.
2. Create a blank database and name it as School System and save it in your Z-drive.

Save
Views

3. Go to Create tab and make a new table. Save it with the name Students.
Data
4. From View tab in upper left corner, open Design View and add the following details.
dictionary

Field Name Data Type Field Size

Student ID Auto Number Long integer

Student Name Short Text 30

Gender Short Text 1


Field length

Y7-Computing 2023-24 Practical 6 Final term Page 1 of 2


Age Number Long integer

Telephone number Short Text 10

Email address hyperlink

Fee Currency

5. Apply Primary key on Student ID from Design Tab.


Who is the entity in
6. In Student ID field properties Assign Format “000” for
this database?
self-generating numbers.

__________

Evidence 1: Take the screenshot of the design view showing all fields

7. Now Open the table in Datasheet View and add the record given below

Student ID 001
Student Name Aleena Ahmed
Gender Female
Age 13
Telephone number 0539567887
Email Address AleenaAhmed@[Link]
Fee 650

8. Now enter 4 more record entries using names and data of your friends.

Evidence 2: Take the screenshot of the Datasheet view showing all 5 rows

9. Add header and print your evidence file.

Y7-Computing 2023-24 Practical 6 Final term Page 2 of 2

You might also like