You can, however, specify which records you wish to retrieve.For example, you can retrieve only those students who live in DE, only the student whose student number is 5, or only those students whose birth date is 2/16/88. en" finds all three character field entries where the second and third characters are You can apply multiple criteria to the same table.Use the Insert Rows button to insert a row in the criteria area.Click anywhere in the row before which you want to insert a new row and then click the Insert Rows button. Click anywhere in the column before which you want to insert a column and then click the Insert Column button .
This option appears on the field line on the drop-down menu as the table name followed by a period and an asterisk ( Tip: You can also click the Design button in the lower-right corner of the Access window to change to Design view.Use the Delete Rows button to delete a row in the criteria area.Click anywhere in the row you want to delete and then click the Delete Row button. Click anywhere in the column you want to delete and then click the Delete Column button . This is useful when you want to create a new table that includes the fields and data from an existing table.You can use an Access query to retrieve a single column of data.Instead of choosing the You can use an Access query to retrieve multiple columns of data.Alternatively, if you want to know which students live in DE, you can restrict your list to those students. A query can be based on tables or on other queries.