SILS iSchool

12 Nov 2018

Value Added | daily

Class Schedule

Basics | sessions 01-05

22 AUG | intro
27 AUG | clients
29 AUG | servers
05 Sep | networks
10 Sep | basics lab

Web Development | sessions 06-11

12 Sep | structural layer
17 Sep | presentational layer
19 Sep | working with layers
24 Sep | behavior layer
26 Sep | images & design
01 Oct | website lab

Document Markup | sessions 12-14

03 Oct | object layers
08 Oct | graphics
10 Oct | document markup lab

Spreadsheets | sessions 15-19

15 Oct | spreadsheets
17 Oct | formulas & functions
22 Oct | thoughts about data display
 18 Oct  | Fall Break 
24 Oct | database tools
29 Oct | spreadsheets lab

Relational Database | sessions 20-26

31 Oct | relational databases
05 Nov | tables
07 Nov | relationships

12 Nov | forms for input | Task 05.03 | reports for output | Task 05.04 | next session

14 Nov | SQL
19 Nov | complex queries
26 Nov | databases lab
 21 Nov | Thanksgiving 

Presentation | sessions 27-30

28 Nov | presentation design
03 Dec | presentation delivery
05 Dec | presentation lab
12 Dec | 0800-1100 | final in class presentation





Create a shelf list report. It does not have to be turned in now.

Generate a Shelf List Report

Create a Shelf List Report

so the volunteers can tell where to shelve the books. The books will be shelved by their Library of Congress number. We also want to know how many books we have in stock and how much each one costs.

Using the report wizard, create a report that shows:
  1. the name of each book in the library
  2. the shelf number of each book
  3. the total number of each title we have
  4. and the retail price of each book
Sort by the Library of Congress number of the book
Use a tabular layout
Change the title of the above report to make it more descriptive
At the end of the report, include a count of the total number of book titles in the library
  • do not total the number of books in stock, just the number of different titles
  • give it the label Number of Book Titles
  • left-align this label with the left-most column in the report
Make certain that the report will print on an standard letter-sized, portrait orientation page without extending past the printable areas of the page to the right.

back to top

General Appearance of Reports

Pay attention to the professional appearance of all reports. Feel free to change field headings in the report so that they look more professional and are more descriptive.

back to top