Each question must have your name on it and it must be correctly numbered.

The deadline is one week from receipt of the questions.

 

Design query files to answer the following questions. You MUST save your queries as detailed in each question.

 

Unless specifically stated you must list all the data fields in the STUDREC table.

 

Submit an electronic screencopy of the design view of each query. (this can be done by having WORD open and using the "Print Screen" key to copy the screen to the clipboard. Simply paste to Word, add your name & print). Please save each answer using the file names given below (this is important as we'll refer to these files later in this course).

Please save each answer to disk.

 

Question No.

 Question Save Query file as:

1

List all students from Barnsley

Barnsley
2 List all students who are female Female
3 List all students who are resident Resident
4

List all students who live more than 10 miles away

GT 10
5

List all students who are not from Barnsley

Not Barnsley
6

List all male students from Barnsley or Leeds

Men from Barnsley or Leeds
7

List resident students with children (list only INIT, SNAME, RES, KIDS)

Res with Kids
8

List all students who live less than 15 miles away and who are not resident.

Res less 15
9 List all men who have children Men with kids
10

List all students who are over 40 years old as of 1st August 2001. (list only INIT, SNAME, DOB). Order the data by Date of Birth .

Older than 40
11 Construct a parameter query to list students by a particular family name. You should prompt the user to enter the first few letters of the name. List the fields init, sname, gender and dob. By Name (P)