Remove a Field Say you 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 MovieSQ is open in Design View. Go to tblMovies. Double-click a Field: Rating.   What Do You See? There should be two copies of the Rating Field in the QBE Grid.   2. Try it: Remove a Field Select the second Rating Field by clicking on the Field Header. The whole column should be highlighted (black).   Delete the second Rating Field. Go to Query Tools ->Design->Query Setup. Click on Delete Columns.   What Do You See, Now? The second Rating Column should be removed. Keep going, please... Query Tools ->Design->Query Setup->Delete Columns Exam 77-885: Microsoft Access 2010 4. Creating and Managing Queries 4.3. Manipulate fields: Remove Fields from a Query