Scribd
Upload
130 views2 pages

Practical Task

The document outlines a practical task for Grade 8 students at Greenwood High to create a database for the College for Advanced Studies. Students are instructed to create a database named after their last name, design a 'Student List' table with specific fields, and input sample data. Additionally, students must write SQL queries to retrieve student details based on city and term attended criteria.

Uploaded by

iitguru2011
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
130 views2 pages

Practical Task

The document outlines a practical task for Grade 8 students at Greenwood High to create a database for the College for Advanced Studies. Students are instructed to create a database named after their last name, design a 'Student List' table with specific fields, and input sample data. Additionally, students must write SQL queries to retrieve student details based on city and term attended criteria.

Uploaded by

iitguru2011
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

GREENWOOD HIGH

GRADE 8
DATABASE
Worksheet 4

Name:……………………………Section …………….Date:………………….

Practical Task

In this exercise, you will create a database that includes a table and queries

The College for Advanced Studies seeks to provide a quality education to each of its students.
In order to do this, the college administration needs an efficient way to keep track of the vast
amounts of information associated with each student served. A college administrator has asked
you to create and update a database to help with this task.

Assignment Instructions:
1. Create a New blank database

2. Name the Access file as your last name in all lowercase


letters. (For example, Janet Learner would save her file as
“[Link]”) (Be sure to name the database before hitting
the “Create” button)

3. In Design View, create a table using the structure shown below:


a. Name the table: Student List
b. Set the “Student #” field as the Primary Key

Field Name Data Type Field Size Other field properties


Student # Short Text 5
(Primary Key)
Last Name Short Text Default
First Name Short Text Default
Address Long Text Default
City Short Text Default
State Short Text 2 Format: Upper case
Default value: IL
Zip Code Short Text 5
Balance Currency Default
First Term Attended Yes/No
Department Look up wizard

Page 1 of 2
4. In Datasheet View, add the data below to the “Student List” table:
Note: For “First Term Attended” the last two characters are numbers, not letters. For
example,
‘SP01’ is an abbreviation of “Spring 2001.” Thus the ‘01’ should both be numbers – not
the letter “O” and number “1.”

Student Last First Address City State Zip Balance First


# Name Name Cod Term
e Attended
54783 Williams Jack 62 Smith Chicago IL 60605 42 SP01
Lane

64589 Metheny Alexa 125 Burlington IA 60606 26 FA02


Fairview
95874 Van Alison 100 Chicago IL 60605 25 SP03
Wegan Quantico
23895 Jackson Ryan 2320 Decatur IL 60641 46 FA02
Hills
Circle
96312 Berstein Krista 126 South Chicago IL 60605 15 FA00
Street
54387 Wylliams Karen 43 Jones Lovington IL 60605 28 FA00
Ave.

54123 (Your (Your (type in Your city Your Your 54 FA00


name) name) any street state zip
address) code

5. Query

a. Write a SQL query to find the details of the students where the city is Chicago. Take the screen
shot of both design and datasheet view and paste it in the word document.
b. Create a grid view query where the First Term attended is FA00. Take the screen shot of both
design and datasheet view and paste it in the word document.

***************

Page 2 of 2

You might also like