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