Question

erms Matching Match the key terms with their definitions. Write the key term letter by the appropriate numbered definition k. Foreign key 1. Multitable query m. Nul a. AND condition b. Auto Number c. Caption property d. Cascade Delete Related Records e. Cascade Update Related fields f. Comparison Operator 8. Criteria row h. Data redundancy i. Data type 1. Field property o. OR condition p. Query q. Referential Integrity r. Simple Query Wizard 5. Wildcard Special character that can represent one or more characters in the criterion of a query. p. 179 Characteristic of a field that determines how it looks and behaves. p. 147 Returns only records that meet all criteria. p. 180 A row in the Query Design view that determines which records will be selected p. 174 Determines the type of data that can be entered and the operations that can be performed on that data. p. 145 Ulsed to create a more understandable label than a field name label that displays in the top row in Datasheet view and in forms and reports. p. 148 Enables you to ask questions about the data stored in a database and provides answers to the questions in a datasheet. p. 173 The term Access uses to describe a blank held. p. 180 A number that automatically increments each time a record is added. p. 146 The unnecessary storing of duplicate data in two or more tables. p. 143 When the primary key value in the primary table can match many of the foreign key values in the related table. p. 162 A field in one table that is also the primary key of another table. p. 147 An option that directs Access to automatically update all foreign key values in a related table when the primary key value is modified in a primary table. p. 162 Rules in a database that are used to preserve relationships between tables when records are changed. p. 161 Contains two or more tables, enabling you to take advantage of the relationships that have been set in your database. p. 188 Returns records meeting any of the specified criteria. p. 180 Provides a step-by-step guide to help you through the query design process. p. 176 When the primary key value is deleted in a primary table, Access will automatically delete all foreign key values in a related table. p. 162 Uses greater than (>) less than (C), greater than or equal to (>R), and less than or equal to (<=), etc. to limit query results that meet these criteria. p. 180

Answer 1

Answer:-

a-3

b-9

c-6

d-18

e-13

f-19

g-4

h-10

i-5

j-2

k-12

l-15

m-8

n-11

o-16

p-7

q-14

r-17

s-1

Above I matched all the terms related to their definations.