Create a New Table
1. Try
This: Create a New Table
Go to
Create ->Tables->Table Design.
Enter the
following, please:
Field Name:
RentalPriceID
Data Type:
AutoNumber
Field Name:
Price
Data Type:
Currency
Field Name:
Description
Data Type:
Memo
Try
This, Too: Review the Field Properties
Select a
Field Name: Price
Review the
Field Properties on the bottom:
Format:
Currency
Decimal
Places: Auto
By
default, Currency has two decimal places. The Field will be
formatted with a dollar sign ($) as well. We're finally working with money
in our
Mighty Access database. Keep going.