Microsoft Office Tutorials and References
In Depth Information
Session 2.1
To define the Wage field:
1. Place the insertion point in the fourth row’s Field Name text box, type Wage in the text
box, and then press the Tab key to advance to the Data Type text box.
2. Click the Data Type list arrow, click Currency in the list box, and then press the Tab key to
advance to the Description text box.
3. Type Rate per hour in the Description text box.
Elsa wants the Wage field values to be displayed with two decimal places, and she does not
want any value to be displayed by default for new records. So, you need to set the Decimal
Places and Default Value properties accordingly. The Decimal Places property specifies
the number of decimal places that will be displayed to the right of the decimal point.
4. Click the Decimal Places text box to position the insertion point there. A list arrow appears
on the right side of the Decimal Places text box.
When you position the insertion point or select text in many Access text boxes, Access dis-
plays a list arrow, which you can click to display a list box with options. You can display the
list arrow and the list box simultaneously if you click the text box near its right side.
5. Click the Decimal Places list arrow, and then click 2 in the list box to specify two decimal
places for the Wage field values.
Next, notice the Default Value property , which specifies the value that will be automatically
entered into the field when you add a new record. Currently this property has a setting of 0.
Elsa wants the Wage field to be empty (that is, to contain no default value) when a new
record is added. Therefore, you need to delete the 0 so that Access, by default, will display
no value in the Wage field for a new record.
6. Select 0 in the Default Value text box either by dragging the pointer or double-clicking the
mouse, and then press the Delete key.
The next two fields in the Position table—HoursPerWeek and Openings—are number
fields with a field size of Integer. Also, for each of these fields, Elsa wants the values dis-
played with no decimal places, and she does not want a default value displayed for the
fields when new records are added. You’ll define these two fields next.
To define the HoursPerWeek and Openings fields:
1. Position the insertion point in the fifth row’s Field Name text box, type HoursPerWeek in
the text box, and then press the Tab key to advance to the Data Type text box.
2. Click the Data Type list arrow, click Number in the list box, and then press the Tab key to
advance to the Description text box.
3. Type Work hours per week in the Description text box.
4. Click the right side of the Field Size text box, and then click Integer to choose this setting.
Recall that the Integer field size stores whole numbers in two bytes.
5. Click the right side of the Decimal Places text box, and then click 0 to specify no deci-
mal places.
6. Move to the Caption property, and then type Hours/Week .
7. Select the value 0 in the Default Value text box, and then press the Delete key.
8. Repeat the preceding steps to define the Openings field as the sixth field in the Position
table. For the Description, enter the text Number of openings . You do not have to set the
Caption property for the Openings field.
 
Search JabSto ::




Custom Search