DIS XYZ Spring 2003 Exam

First Name: Last Name: PIN:
Semester: Class:
Section: Exam Number:

This exam is base on Chapters x to y of the book, plus any material covered in class or in the PowerPoint presentations.
This exam is open book, open notes. No emailing or instant messaging is allowed.
You must use software to complete this exam, you are allowed and encouraged to use the available Help.
Please download a copy of the Exam.mdb file from \\store\classes to your local computer or J: drive.
Do not save or print a copy of this exam. Doing so will be considered cheating.

 

1. Use the appropriate item and change the following properties.

(10) Color
(20) Width
(10) Height
(10) Weight

2. Use the xyz table to answer the following questions.

Create a cool that will do the following:

(25) Apple statement:

(25) Heat results:

3. Answer the following questions.

(10) What data type should be used?
(25) What is the meaning of life?
(10) What is the key to success?


4. Use the aardvark report to answer the following questions.

(25) What is the expression for the 'DateOfBirth' field?
(25) Run the thing, paste results here:

5. Create a new table with field named 'Stuff'.
Answer the following questions:

(25) What is the expression that satisfies these requirements?
(25) Why would you want to store data in the table?

6. Use the 'Category' report.
Add a new calculated field that accomplishes the following:
Answer the following questions:

(25) What is the expression that will accomplish this?

7. Use the file to answer these questions.

(10) What is the s returned?
(25) What are the ?
Now modify the file to determine the following:
(25) Total
(50) Paste the statement :

8. Use the file to answer these questions.

(25) Place your here:

9. Answer the questions regarding the following statement block in the space provided below.

(10) What does the preceding block of statements represent?
(25) In what ?

In this section complete the following statements. Type your answers in the space provided.

10. (10) To
11. (10) normal .
12. (10) A(t was not.
13. (10) A
14. (10) s, the task or the ____________________.
15. (10) wn as .
16. (10) When the
17. (10) The process of returning
18. (10) Converting the nown as ____________________.
19. (10) What is the column?

 

This exam is best completed by placing your answer in the form TextArea Box Properties 'Initial Value' field as shown below from FrontPage2002. Do not delete these TextArea boxes!
You can choose to simply

This method will keep your answer in your .html file when you publish / ftp your homework to your studentwebsite. Never change the Name field!

Once you are satisfied that your exam has been done correctly make sure to fill in the form fields for First Name, Last Name, Section and PIN. These fields are located at the top of this exam.
You will be assigned a special PIN number for this exam.
Once this is done, press the submit button. This sends a copy of your exam answers to the professor.
If all goes well, you will see a confirmation page. At this point your exam has been submitted. Until you see the confirmation page, your exam has not been submitted.
Please remember that your submission time of your exam is being recorded. The exam is due at the end of class on the day of the exam.

If you are late, you will lose points. If you try to submit another copy of the exam later, you will lose credit for this exam and jepoardize your grade in this class.
Caution: Press the Submit button only once!
Pressing the Submit button more than once sends additional copies of your answers to the instructor and records the time of submission.