Access Chapter 2

Question 1

special character that can represent one or more characters in the criterion of a query

Answer 1

wildcard

Question 2

characteristic of a field that determines how it looks and behaves

Answer 2

field property

Question 3

returns only records that meet all criteria

Answer 3

AND condition

Question 4

a row in the query design view that determines which records will be selected

Answer 4

criteria row

Question 5

determines the type of data that can be entered and the operations that can be performed on that data

Answer 5

data type

Question 6

used to create a more understandable label than a field name that displays in the top row in datasheet view and in forms and reports

Answer 6

caption property

Question 7

enables you to ask questions about the data stored in a database and provides answers to the questions in a datasheet

Answer 7

query

Question 8

the term access used to describe a blank field

Answer 8

null

Question 9

a number that automatically increments each time a record is added

Answer 9

autonumber

Question 10

the unnecessary storing of duplicate data in two or more tables

Answer 10

data redundancy

Question 11

when the primary key value in the primary table can match many of the foreign key values in the related table

Answer 11

one-to-many relationship

Question 12

a field in one table that is also the primary key of another table

Answer 12

foreign key

Question 13

an option that directs access to update all foreign key values in a related table when the primary key value is modified in a primary table

Answer 13

cascade update related fields

Question 14

rules in a database that are used to preserve relationships between tables when records are changed

Answer 14

referential integrity

Question 15

contains two or more tables, enabling you to take advantage of the relationships that have been set in your database

Answer 15

multitable query

Question 16

returns records meeting any of the specified criteria

Answer 16

OR condition

Question 17

provides a step-by-step guide to help you through the query design process

Answer 17

simple query wizard

Question 18

when the primary key value is deleted in a primary table, access will automatically delete all foreign key values in a related table

Answer 18

cascade delete related records

Question 19

uses greater than >, less than =, less than or equal to <=, etc. to limit query results that meet these criteria

Answer 19

comparison operator