Chapter 10—Review Use your textbook to complete the worksheet. 1. List the relational operators and logical operators that can be used to form a validation rule. Relational Operators: <less than Greater than <=less than or equal to >=greater than or equal to <>not equal to Logical Operators: And Or Not Like 2.
a) What does it mean when 2 tables are related? When a field on one table corresponds to a field on another table b) What types of fields are used to form a relationship between tables? When two tales are related on one type of field ) How do you create a relationship? 3. a) What is a foreign key? The one item that is linked to the primary key b) Explain a one-to-many relationship. When the primary key lets you refer to multiple fields c) What are lookup fields? d) How do you delete a relationship? Click the line that connects the two tables then press the delete key 4. a)What is a select query? Database object that is used to retrieve, or select, data that matches specified criteria b) How many fields can a select query contain? c) How do you create a select query? Click create, -> Query design )What is the design grid? Used to specify fields and criteria e)How do you add fields to the design grid? Drag the field into the design grid f)Should you add $ and commas to your data in the design grid? No because they are automatically added5. Compare and contrast filters (from Chapter 9) and select queries. 6.
a)List the steps to run a select query. Double click the query name in the navigation pane b)How is an existing query run? Double click the query name in the navigation pane 7. a) Which view do you modify a query in? Design view ) In Design view, can a field be added between existing fields in the design grid of a select query? If so, how? Yes, drag to design grid 8. a)What is a range query? Select query with criteria that matches a range of values b)What kind of operators is used to create the criteria for a range query.
<,>,<=,>=,<> 9. What is a complex query? Select query with multiple criteria 10. How can the and operator be implied in the criteria of a complex query? 11.
What is the OR row of a select query design grid used for? How is this different from criteria involving And? 1. a)What is a wildcard? Character that matches one or more characters b)List two criteria wildcards that can be used in a select query and explain when each would be used. *, ? , and Like c)What does the asterisk * wildcard do? Matches any number or character or no character at all d)What does the question mark? Wildcard do? Matches any one character or no character at all 22. What does the Like operator in the design grid of a select query indicate? To specify criteria 23. a)What is mail merge? Merges data stored in an Access database with a word document b)What is a form letter?A word document with merge fields c)What are merge fields? Place holders for data from an Access table or query d)List the eight steps to create a Mail Merge Letter. 1. Click Start Mail Merge 2.
Click Select Recipients 3. Click edit Recipient List 4. Click address block to automatically format and insert an address block 5. Click greeting line to automatically format and insert a greeting 6. Type the letter 7.
Click preview results 8. Click Finish & Merge -> Print Documents COMPLETE THE FOLLOWING END OF CHAPTER EXERCISES EXERCISE 3- EXERCISE 6 EXERCISE 9-