Remove a Field
added the Rating Field a couple of times as you were practicing.
Here are the steps to Remove a Field.
Before You Begin: Add Another Field
open in Design View.
Go to tblMovies.
Double-click a Field: Rating.
You See? There should be two copies of the Rating Field in the
Try it: Remove a Field
second Rating Field by clicking on the Field Header. The whole
column should be highlighted (black).
second Rating Field.
Query Tools ->Design->Query Setup.
You See, Now? The second Rating Column should be removed.