Test 4

Name:______Date:______

  1. In Access, a database consists of a collection of ______.
  2. columnsc.worksheets
  3. tablesd.rows
  4. A field that uniquely identifies a particular record in a table is called a ______key.
  5. secondaryc.principal
  6. primaryd.foreign
  7. You create a query by making entries in a special window called a(n) ______window.
  8. Select Queryc.Ask Query
  9. Query Designd.Create Query
  10. To execute or run a query, click the ______button on the Query Design toolbar.
  11. Executec.Answer
  12. DoIt!d.Run
  13. To find all customers whose names begin with B, enter ______in the Criteria row
  14. B* c.B@
  15. B? d.B..
  16. To find all customers whose amount paid is $1,500.00, enter ______in the Criteria row
  17. >1500c.1500
  18. =$1,500d.=1,500
  19. To find all customers whose current due amount is greater than $1,000.00, enter ______in the Criteria row of the Current Due column.
  20. >1000c.>$1,500
  21. >1,000d.>$1000
  22. To omit duplicates from a query, use the Properties command and change the Unique Values property to ______.
  23. On c.yes
  24. Off d.no
  25. When an expression is entered for a calculated field, the field names used in the expression must be enclosed in ______.
  26. square brackets ([ ])c.quotation marks(“ “)
  27. curly braces ({ })d.parentheses(())
  28. To find the smallest amount paid for a customer, select ______as the entry in the Totals row for the Amount Paid column.
  29. LITTLEc.MIN
  30. SMALLd.LEAST
  1. To find all employees whose hire date is after April 10, 2000 enter ______in the Criteria row of the Hire Date column.
  2. 4/10/2000c.4/10/2000
  3. 4/10/2000d.April 10, 2000
  1. To find dues for all customers with dues greater than $200 and less than $2000 enter ______in the Criteria row of the Dues column.
  2. < 200 And >2000c.<200 And <2000
  3. >200 And <2000d.>200 And >2000
  4. To make changes to the structure of a table, right-click the table in the Database window and then click ______on the shortcut menu.
  5. Changec.Structure
  6. Restructured.Design View
  7. ______are rules that a user must follow when entering data.
  8. Data rulesc.Validation rules
  9. Edit rulesd. Normalization rules
  10. A(n) ______is a value that Access will display on the screen in a particular field before the user begins adding a record.
  11. required valuec.necessary value
  12. optional valued.default value
  13. To specify that AZ, NM, and TX are the only legal values for the State field, type ______in the Validation Rule property box in the Table window.
  14. =AZ or =NM or =TXc.{AZ,NM,TX}
  15. AZ, NM, TXd.“AZ” or “NM” or “TX”
  16. A field has the format > in the Format box. If you type phd in the field it will display as ______.
  17. Phdc.phD
  18. Phdd.PHD
  19. A field has the format < in the Format box. If you type me93 in the field it will display as ______.
  20. me93c.Me93
  21. ME93d.mE93
  22. In Access, to specify referential integrity, define a relationship between the two tables by using the______command.
  23. Referential Integrityc.Integrity
  24. Relationshipsd.Primary Key
  25. To specify that current due amounts must be between $100 and $5,000, enter
    >= 100 AND <=5000 in the Validation Rule text box for the Current Due field.
  26. If the table is represented as a collection of rows and columns, then the table is displaying in ______view.
  27. Tablec.Datasheet
  28. Tablesheetd.Worksheet
  29. If the value 1505.5 is entered in a field that has been defined as Currency data type, then the value will display as ______.
  30. 1505.5c.$1505.50
  31. 1505.50d.$1,505.50
  1. Every record in a table must have a primary key. True / False
  2. To display the entire entry for a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ______.
  3. Enlargec.Magnify
  4. Zoomd.Size
  5. To use average function, include ______row in the design grid.
  6. Fieldc.Total
  7. Sortd.Criteria