Exam 77-424: Microsoft Access 2013 3.0 Create Queries 3.2 Modify a Query: Add New Fields

Add a Field This Select Query shows three Fields from tblMovies: MovieID, Year and Movie. Say you wanted to Add a Field. Here are the steps to add the Rating Field.   1. Try it: Add a Field MovieSQ is open in Design View. Go to tblMovies. Double-click a Field: Rating.   What Do You See? The Rating Field has been added to QBE Grid.   Keep going... Query Tools ->Design