graphic2
graphic1

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

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 Quick Start-> Phone.


Keep going...

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