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.


Create ->Tables->Table Design

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.2. Create and Modify Fields: Modify Data Types