More Fields: Phone Numbers

3. What Do You See? The Quick Start added four new Fields for the customer's phone:

Business Phone

Home Phone

Mobile Phone

Fax Number

 

Design Consideration: What is the purpose of collecting this data? In our Front Row Video store, a clerk can use the phone number to look up a customer. How many phone numbers are needed? And, how many numbers are your customers willing to share?

 

Keep going...

Table Tools ->Fields->Add & Delete->More Fields->Quick Start->Phone

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.2. Create and Modify Fields: Add a Phone Field