default values for city and state remove quotes from beginning and end of date format add a new calculated field for units * cost. The currency one there now cannot be changed. delete it when you have your new one or delete it first and re-make it. This week we practice using the table properties discussed in the lecture, and a few more Data Types. Use the table you created last week and modify it to include the following fields, with appropriate data types, and the properties discussed in the lecture. Explanations are below the graphic. The new table should look like this. The mage above is shown in pieces so it fits on the screen and still be large enough to examine. The complete image is below. The fields in the structure of your table, when viewed in Design View, would look like this: is the student ID # as it is at City College because all (most) start with a W. When in datasheet view, make this field show as instead of W# is for Full-Time Student The rest is self-explanatory. Data Type choose . This will launch the wizard that
will prompt you to create a drop-down list of States to make data entry even easier. In the lecture I showed you how to manually create the drop-down list values on the fly by typing each value in. This time you will use the provided table of states to populate your state field. This State table is in the link on the opening page in the week 4 module/block. Download the database provided named States. Open the database, select the state table, copy, open database, right-click and choose paste. Thats it. Now you have a table with state names you can use over and over again. on field Field on and names for and and FT should show as and on Field Example make it so that the user has to enter a number between 1 and 5 for date field should have a W automatically added in front of the student ID, since all student IDs will have a W in front. So we could type 12345 and it will appear W12345 make it any number you wish for price per unit. Example 30.00 t should be a calculated field You can leave off smart tags or play with them if you like.