Fields: Number or Text?

When you add a Field for the customer's phone number you may be tempted to add a Number Field. Indeed, there are many Number Formats (Currency, Percent, Decimals). But, a phone number is really a Text Field: it uses punctuation to separate the Area Code from the number. For example: (810) 555-1212, where (810) is the Area Code. Can a Text Field be formatted for phone numbers?

 

2. Try it: Find More Fields

Go to Table Tools ->Fields->Add & Delete.

Go to More Fields.

 

What Do You See? The list includes:

Basic Types

Number

Date and Time

Yes/No

Quick Start

 

Try This, Too: Add the Phone Fields

Go to Table Tools ->Fields->Add & Delete.

Go to More Fields-->Quick Start-> Phone.

Keep going.

Table Tools ->Fields->Add & Delete->More Fields

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.2. Create and Modify Fields: Add a Phone Field