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