Document Sample
Database Powered By Docstoc
What is a database:
  a table of rows & columns for storing related information
  information is organized so that it can easily be accessed,
    managed, and updated.
  companies collect data records for sales transactions, product
    catalogs and customer profiles

  an employee database stores/organizes employees by: employee
   ID, name, title, wage rate etc
  each row, is called a data record, corresponding to one
  each column name is called a record field.

Employee     Last     First
                                 Title     Wage        Phone #          SIN #
  ID        Name      Name

  04321     Smith      John     Cashier    $11.25      640-1433 123456789

  05341      Doe       Jane     Waitress   $11.50      640-8598 987654321

         Database Spreadsheet Functions
 sorts all records of a selected field in ascending or
    descending order
 Select Data ... Data menu … Sort (A-Z or Z-A)

 adds drop down menu filter options to each field
 select all fields … Filter   (on Data Menu)

Custom Filter
 selected criteria ie. greater than, less than, equal to etc.
   from Filter drop down menu for any column … select Text
    Filter (for words) or Number Filter
 Use “Clear Filter” from drop down menu to show all records

 subtotals each record and grand totals all the data
 Select Data … Subtotals (on Data Menu) … Use “At Each Change
    In” menu to pick grouping of subtotals

     Creating a Database Using Spreadsheets
Creating a database using a spreadsheet allows the user to sort the information
very easily. Follow the instructions below:
1. Create a new empty Excel Workbook file called: My CD’s. Create a single
   worksheet called CDs. (label Sheet1 as CDs)
2. Using Row 1 … create the following field (column) headings.
      Title, Artist, Genre, No. of Tracks, Price
3. Using the following categories, complete two (2) records for each genre. The
   genres are: Rock, Pop, Country, Rap, Dance, Reggae, Soundtrack.
4. Using the CD Universe website ( or a better
   website you may know of (that gives you genre, tracks, prices, etc.) select the
   appropriate information to fill in your database.
5. After you have filled in two (2) records for each type of music (2 records X 7
   genres = 14 records), complete the following tasks. After each of the tasks
   below copy each answer into a new sheet
6. Create the following Sorts and Filters:
      a. A filter that shows all CDs that are greater than $14.99. Sort by Price.
         (copy all records to a new sheet and change the “tab-title” when done)
      b. A filter that shows the CDs that have less than 12 tracks. Sort by No. of
         Tracks. (copy all records to a new sheet and change the “tab-title” when
      c. A filter that shows only Pop and Soundtrack categories. Sort the records
         in descending order (eg. ZZ Top…ABBA) according to Artist. (copy all
         records to a new sheet and change the “tab-title” when done)
      d. A report that sub totals the price for each category and the total price of
         all the CDs in the report (copy all records to a new sheet and change the
         “tab-title” when done)
7. Save file as “Your Name” CD Database into your H: Drive