front 1 The area directly below the ribbon that displays information such as security alerts. | back 1 Message bar |
front 2 An area where you can view the security and privacy settings for your Access installation. | back 2 Trust Center |
front 3 An association that you establish between two tables based on common fields. | back 3 Relationship |
front 4 A relationship between two tables, where one record in the first table corresponds to many records in the second table. | back 4 One-to-many relationship |
front 5 In the query design window, in the table area, the list of field names in a table. | back 5 Field list |
front 6 The primary key field is connected to this field in the related table to create a relationship. | back 6 Foreign key |
front 7 A set of rules that ensures that the data between related tables is valid. | back 7 Referential integrity |
front 8 The visual cue in the Relationships window that indicates tables are related by connecting common fields. | back 8 Join line |
front 9 In Datasheet view, clicking the plus sign (+) displays the related records in this format. | back 9 Subdatasheet |
front 10 The process of arranging data in a specific order based on the data in a field. | back 10 Sorting |
front 11 A sorting order that arranges text alphabetically (A to Z) and numbers from the lowest number to the highest number. | back 11 Ascending |
front 12 A sorting order that arranges text alphabetically (Z to A) and numbers from the Highest number to the Lowest number. | back 12 Descending |
front 13 In Datasheet view, when sorting using multiple fields, the field that is used for the first level of sorting. | back 13 Outermost |
front 14 In Datasheet view, when sorting using multiple fields, the field that is used for the second level of sorting. | back 14 Innermost |
front 15 The process in which Access looks for records in a table based on the fields and criteria in the query design, finds those records, and then displays the records in a datasheet. | back 15 Run |
front 16 Relationship options that enable you to update records in related tables when referential integrity is enforced are known as: | back 16 Cascade options |
front 17 The lower area of the query design window where criteria is entered is the: | back 17 Design grid |
front 18 Min, Max, Avg, and Sum are examples of: | back 18 Aggregate functions |
front 19 Conditions in a query that identify the specific data for which you are looking are known as: | back 19 Criteria |
front 20 A criteria that searches for fields that are empty is: | back 20 Is Null |
front 21 The symbols of =,>,and<, are known as: | back 21 Comparison operations |
front 22 A comparison operator that searches for values within a range is: | back 22 Between...And |
front 23 the logical operator that requires all criteria to be met is: | back 23 AND |
front 24 A wildcard character that serves as a placeholder for one or more unknown characters is the: | back 24 * |
front 25 A field that stores the value of a mathematical operation is: | back 25 A calculated field |
front 26 For a calculated field, the new field name must be followed by: | back 26 A colon |
front 27 A query that uses an aggregate function and displays data grouped by two types of information is: | back 27 A crosstab query |
front 28 A query that prompts you for criteria when it is run is a: | back 28 Parameter query |
front 29 Criteria that can be changed when a query is run is a: | back 29 Parameter |
front 30 A good parameter for a City field is: | back 30 [Enter a City] |