To resize a column in an Excel worksheet to display the widest item, you place the pointer on the column border and:

A(n) _________ query can be used to remove the duplicate values in a table

Fill in the blank(s) with correct word

For the following codes, define the validation criteria (there may be multiple checks for each field) and the order that you would test each of the conditions.

a. A credit card number entered on a Web form: the customer has selected the type of credit card from a drop-down list. b. A part number in a hardware store: The part number is a complex code, where the first digit represents the department (such as housewares, automotive, and so on), and the number should be self-checking. There are seven different departments. c. The date that a book was postmarked when returned to an online bookstore: A copy of the customer receipt must be included with the book. Returned books must be postmarked within 30 days of the purchase date. d. A language spoken code used on a website: Hint: search the Web for standard language codes. e. A driver’s license number composed of several parts: The person’s birth month, the birthday, and birth year, not necessarily together; a code representing eye color; and a sequence number. The driver’s license contains the date of birth, the eye and hair color, as well as the person’s name and address. f. The Canadian postal code: the format is X9X 9X9 (X is any letter, 9 is any number). g. Airline luggage codes: such as L A X for Los Angeles or D U B for Dublin. h. A product key used to unlock purchased software: The key consists of four groups of five characters each. The first group must have two letters followed by three numbers; the second group must contain two numbers followed by three letters; the third group must contain two letters, each from A through G followed by three numbers from one through four; and the last group must contain a letter, either an E, G, or C, two digits with values from four through seven and two letters, either an A, B, or C. Hint: a pattern may be the best way to validate the product key.