CH2 Henry Books Case Answers

Topics: Check box, Typography, Form Pages: 2 (952 words) Published: October 26, 2014

Answers to Henry Books CaseThe following answers indicate how to perform the specified task in Microsoft Access. The process for other database management systems would be different, although it should be similar. See the Instructor’s Resource Kit on CD-ROM for a copy of the Henry Books database that contains the solutions to these exercises. 1.Include the AuthorNum and AuthorLast fields in the design grid. Do not enter any criteria. 2.Double-click the asterisk in the Branch field list to add all fields to the design grid. Do not enter any criteria. 3.Include the PublisherName and City fields in the design grid. Remove the check mark from the Show check box in the City column. Type Boston in the Criteria row for the City column. 4.Include the PublisherName and City fields in the design grid. Remove the check mark from the Show check box in the City column. Type <>Boston in the Criteria row for the City column. 5.Include the BranchName and NumEmployees fields in the design grid. Remove the check mark from the Show check box in the NumEmployees column. Type >=9 in the Criteria row for the NumEmployees column. 6.Include the BookCode, Title, and Type fields in the design grid. Remove the check mark from the Show check box in the Type column. Type SFI in the Criteria row for the Type column. 7.Include the BookCode, Title, Type, and Paperback fields in the design grid. Remove the check mark from the Show check box in the Type and Paperback columns. Type SFI in the Criteria row for the Type column. Type either True or Yes in the Criteria row of the Paperback column. 8.Include the BookCode, Title, PublisherCode, and Type fields in the design grid. Remove the check mark from the Show check boxes in the PublisherCode and Type columns. Type SFI in the Criteria row for the Type column. Type PE in the Or row of the PublisherCode column. 9.Include the BookCode, Title, and Price fields in the design grid. Type >5 AND <10 in the Criteria row for the Price...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Case Answers Essay
  • Henry Tam Case Study Essay
  • Answers: Earthquake and Lab Book Essay
  • Henry Tam Group Case Research Paper
  • answer of bio book e Essay
  • Henry Tam Case Research Paper
  • Henry Tam Case Analysis Essay
  • Case D Full Answers Essay

Become a StudyMode Member

Sign Up - It's Free