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

Add All of the Fields There are two methods for selecting all of the Fields from the Table and adding them to the QBE Grid on the bottom of the query: the Wildcard (*) or double-click.   If you double-click the Wildcard(*) you should see one Field on the Grid that says *tblMovies, where * means "select everything."   If you double-click each Field separately, you will see the Field names lined up on the QBE Grid. This method works great for Parameter Queries because each Field can have a different Criteria if you wish. 2. Try it: Add Fields to the Query Go to tblMovies. Double click to select the following Fields: MovieID Movie Year Rating Genre Stars Keep going, please... Query Tools ->Design