New Perspectives Access 2010 Tutorial 3Quick Check Answers

Session 3.1

1. In navigation mode, the entire field value is selected, and anything you type replaces the field value; in editing mode, you can insert or delete characters in a field value based on the location of the insertion point.

2. A select query is a general query in which you specify the fields and records you want Access to select.

3. The field list contains the table name at the top of the list and the table’s fields listed in the order in which they appear in the table; the design grid displays columns that contain specifications about a field you will use in the query.

4. A table datasheet and a query datasheet look the same, appearing in Datasheet view, and can be used to update data in a database. A table datasheet shows the permanent data in a table, whereas a query datasheet is temporary and its contents are based on the criteria you establish in the design grid.

5. oldest to most recent date

6. False

7. filter

Session 3.2

1. condition

2. in the same Criteria row; in different Criteria rows

3. expression

4. Expression Builder

5. a function that performs an arithmetic operation on selected records in a database

6. Group By

7. Object Type