Solved by Expert Tutors
Solved by Expert Tutors
Question

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.


And


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

TP Assignment 7 (1).zip - Preview not available
Sign up to view the entire interaction

Step-by-step answer

ec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a moles

gue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor n

T8_ClassicCars_Data.mdb
s ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laor molestie consequat, ultrices ac magna. Fusce m ipsum dolo , consecte

Subscribe to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question