Fields: Delete a Field

A database has only one job: keep the data. Microsoft Access is very emphatic when you delete something. So, you will see some in-your-face screens when you delete a Field.

 

4. Try it: Delete A Field

Select a Field: Fax Number.

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

Click on Delete.

 

What Do You See? Access will prompt you that deleting a Field is permanent: no Undo.

 

Click Yes to delete the Field.

 

Try This, Too: Delete Another Field

Select a Field: Business Phone

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

Click on Delete.

Click Yes to delete the Field.

 

Keep going...

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.2. Create and Modify Fields: Delete a Field

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