I need help with only 2 of the 5 questions. I am having trouble understanding how to do:
2. It’s A Grind Coffee Shop
It’s A Grind Coffee Shop is a neighborhood coffee shop. Kate Fitzgerald, the proprietor,
has decided that she needs a form and two reports created to help her purchase new
books for her coffee shop.
Kate has provided you with an updated database file, T8_ItsAGrindCoffee_Data.mdb.
Specifically, Kate wants you to:
A. Create a form that will allow Kate to add new books to the BOOK table. Kate has asked
you to use a Columnar layout and light gray background color. Kate has given you her
logo to add to the form, ItsAGrindImage.jpg. Position the logo in the top-left corner.
Include three command buttons (next record, previous record, and add new record).
Save the form as Books.
B. Create a report that groups the records by author. Include only the author from the
AUTHOR table, and book title, year, and condition from the BOOK table. Sort the report
by book title. Create a title labeled Current Authors; center the title on the report. Set
the label properties to 12 point, bold, italic. Save the report as Books By Author.
bal76744_plugint08_002-012.indd T8-10 2/23/08 12:08:23 PM
Plug-In T8 Decision Making Using Access 2013 * T8-9
C. Create a report using the publisher name, book title, year, and author name. Group the
report on publisher name and sort on the year the book was published. Create a report
title of Books By Publisher. Align the columns evenly and use a professional-looking
font style and layout. Save the report as Publishers.
4. Scale Classic Cars
Johnny Krol runs a body shop that specializes in restoring classic cars. Johnny owns three
classics and began collecting scale models when his wife put her foot down and said no to
building more garage space for his cars. Johnny has decided that he needs a form and a
report created to help in identifying the buying habits of his customers. Johnny has provided
you with an updated database file, T8_ClassicCars_Data.mdb.
Specifically, Johnny wants you to:
A. Create a form that will allow Johnny to enter new classic cars and update existing
records. The form should use a Columnar format. Include three command buttons
(next record, previous record, and add new record). Save the form as Catalog.
B. Create a report listing classic cars grouped by their make. The report should display all
fields from the CATALOG table, sort by model name, and calculate the average price for
each make. Use the Formal style. Save the report as Cars By Mode