Foundations of Academic Computing                                                                  Cook

DB Lab                                                                                                                      

 

Create a database listing at least ten of your favorite CD’s or tapes. Include at least the following fields:

 

            Artist                                                    Text field

            Title                  Album title                    Text field

            Type Music                                          Text field

            Minutes            Approx                        Number field

            Price                Approx.                       Number field

            Cost per minute                                    Calculation field

            Average price                                       Summary field

            CD or Tape                                          Text field

 

Include your name in a header at top right of the page.

 

Print out a landscape (horizontal) page listing all fields in columnar format. Format price, cost per minute, and average price as currency with 2 decimal places.