Exam 77-424: Microsoft Access 2013
2.0 Build Tables
2.4 Create and Modify Fields: Create and Modify Fields

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: Long Text

 

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...

 
graphic2

Create ->Tables->Table Design

graphic3
graphic1