Create this Document!

Data File: MyClasses_Chap3_Complete.zip (209.0K)

Exercise 1

1. Create a form using the Form Wizard
1. Open MyClasses from Chapter 2
1. Click "Forms"
2. Click New, then Form Wizard, then Select GradeList from the table or query box.
3. Add only the Grade Field by click Grade, then the > button.
4. Click Next
5. Look at all the different layouts available, then Click Tabular
6. Look at all the different styles available, then Click International
7. Click Finish and you should see your form showing grades from the GradeList Table.
2. Create a form using the Auto-Form
1. Click "Forms"
2. Click New, then Auto Form: Tabular, then Select GradeList from the table or query box.
3. Click OK.
4. You should now see your new form showing all elements from the GradeList Table. You will also see the field "GradeID" even though it is an AutoNumber field and can’t be edited.
5. Close the form, call it AutoFormGradeList.
3. Create another form using the Auto-Form (Tabular)
1. Click "Forms"
2. Click New, then Auto Form: Tabular, then Select NewClassQuery from the table or query box.
3. Click OK.
4. You should now see your new form showing all elements from the query created in Chapter 2
5. Close the form and call it "ClassQueryForm".
4. Create another form using the Auto-Form (Columnar)
1. Click "Forms"
2. Click New, then Auto Form: Columnar, then Select NewClassQuery from the table or query box.
3. Click OK.
4. You should now see your new form showing all elements from the query created in Chapter 2
5. Close the form and call it "ClassQueryColumnar".
5. Modify the "ClassQueryColumnar" form
1. Clock Forms
2. Open the form "ClassQueryColumnar" in Design View
3. Copy the field called: "ClassDate"
4. Paste the copied field back into the same form and position it somewhere on the form. Hint: You may have to enlarge the form to make it fit.
5. Edit the label to say: "How Many Days Ago"
6. Double click the text box to bring up its properties.
7. Click the ellipse button to the right of the Control Source field.
8. In the Expression Builder, modify the control source to use the function called "DateDiff". Display the difference in days between now (date()) and [ClassDate].
9. Change the Format to "Standard" and "Decimal Places" to 0
10. Safe the newly modified form.
6. Now open the form in Form View and make sure you can add some records to the database.

Exercise 2

1. Modify the database you created in Chapter 2, Exercise 2.
1. Use the same type of forms.
2. Use the same type of queries.
3. Add a text box to the form to display how old in years.