Date/Time data type
The Date/Time data type is a specialized number field for holding dates or times (or dates and
times). When dates are stored in a Date/Time field, it is easy to calculate days between dates and
other calendar operations. Date data stored in Date/Time fields sort and filter properly as well.
49
Creating Access Tables 2
Currency
The Currency data type is another specialized number field. Currency numbers are not
rounded during calculations and preserve 15 digits of precision to the left of the decimal point and
4 digits to the right. Because the Currency data type uses a fixed-decimal-point position, they are
faster in numeric calculations than doubles.
AutoNumber
The AutoNumber field is another specialized Number data type. When an AutoNumber field is
added to a table, Access automatically assigns an integer value to the field (beginning at 1) and
increments the value each time a record is added to the table. Alternatively (determined by the New
Values property), the value of the AutoNumber field is a random integer that is automatically
inserted into new records.
Pages:
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259