Databases

Mission!
  • Create a database of countries!

Part 1 through 9 - Learn How to Use Microsoft Access

  1. Follow along with these videos to create a database of countries!
  2. AFTER COMPLETING EACH VIDEO, RAISE YOUR HAND AND SHOW YOUR TEACHER!  :-)
  3. Hint:  There can not be slashes / or \ in a file name.
  4. DO THESE! -> https://www.dropbox.com/sh/llo22yl2cbrztxc/AABkZBZUwh_wgngUSa1u3HD-a?lst
  5. Note: Emergency backup video locations:
    1. https://drive.google.com/folderview?id=0B6BKTShcUEwJeU1tWHJ0VVFPQzA&usp=sharing#list
    2. Computer -> MS Classes (Q:) -> Wissner -> HandOut -> Database Countries


STOP!!!  Did you do part 1-9 above? Do that first! :-)


Part 10 - Add More Data!

  1. Add more countries, so you have a total of ten (10) countries.  Make sure you have:
    1. China
    2. India
    3. Russia
    4. A total of AT LEAST 10 countries.  You may have more, but not less.
  2. New Field:  Add to your table a field called "Currency".
  3. Hint:  This will be a new column for the name of the money in that country.
  4. Link:  http://en.wikipedia.org/wiki/List_of_circulating_currencies
  5. Or:  Search the Internet using the words: country AND currency
  6. Fill in all the missing data!
  7. Stop!  Raise your hand!  Politely ask your teacher to check your work!


Part 11 - Create a Third Report

  1. Create a report with the following features:
    1. Include only three fields/columns:  Name, Currency, and Area
    2. Sort ascending by the currency
    3. Title: Currencies of Ten Countries; 24 point, dark red
    4. Width: Adjust the width of each column so that all the data is visible on one sheet.
    5. Headings: Center and bold the heading on each column
  2. Open all three reports.
  3. Stop!  Raise your hand!  Politely ask your teacher to check your work!


Part 12 - Hand In the Project via Email

  1. In Access, SAVE!!! After saving, close and exit out of Access.
  2. Open up your school email account.
  3. Click Compose to begin a new email.
  4. Attach your database project to the email
  5. Subject line: Countries Final
  6. In the Address enter:  wissnera+hour@waylandunion.org
  7. AND in the Body enter:  Attached, please find my countries database project.
  8. Click on your Sent Mail to see that it sent, and immediately....
  9. Stop!  Raise your hand! Politely ask your teacher to look at your sent email.






Part 1 - Three Countries!  Set Up Your Database

  1. Open Microsoft Access.  Start -> Programs -> Microsoft Office -> Microsoft Office Access 2007
  2. Open Mozilla Firefox.  Start -> Programs -> Mozilla Firefox
  3. Go to mrwissner.com
  4. Rearrange the windows so each takes up 1/2 the screen.
  5. Watch, listen and follow along with this 10 minute video:  Creating a Database using Access
  6. Save!  Make sure to SAVE into your home directory (H:) in your computers folder.
  7. Stop!  Raise your hand!  Politely ask your teacher to check your work!

Part 2 - Four More Countries!  Total of Seven Countries!

  1. Read all the directions for this part BEFORE doing them.
  2. Important:  Europe, Africa, Asia are continents, not countries.
  3. Language:  Find the language information for each country using this link.  Infoplease Link
  4. Statistics:  Use the following link for population, capital city, and area (in square km).   Offline Data
  5. By the end of this part, you should have data for SEVEN countries.
  6. If you have three countries so far THEN, add four more countries (you choose, use links above).
  7. Stop!  Raise your hand!  Politely ask your teacher to check your work!



Part 3 - Create Your First Report

  1. Hint:  You should now have a total of SEVEN countries.
  2. Watch, listen and follow along with the next video:  Finishing Countries Database Intro and Making a Report
  3. Stop!  Raise your hand!  Politely ask your teacher to check your work!

Part 4 - Make another Report using Report Wizard!

  1. With the same data table, make another report with the following features:
    1. Hint: Use the Report Wizard!
    2. Fields: Name, Population, Area  -- Hint: Only include these 3 fields.
    3. Grouping Levels:  No grouping levels
    4. Sort: Sort descending by the area.  Hint:  Descending means largest on top, to smallest on bottom.
    5. Title: Area of Several Countries
    6. Columns:  Adjust the width of each column so that all the data is visible on one sheet.
    7. Headings:  Center and bold the heading on each column.  Hint: Do this in layout view.
  2. Open both reports.
  3. Stop!  Raise your hand!  Politely ask your teacher to check your work!



Part 5 - Add a Field & More Data

  1. New Field:  Add to your table a field called "currency".
  2. Hint:  This will be a new column for the name of the money in that country.
  3. Add three more countries, for a total of ten (10) countries.
  4. Hint:  Search the Internet using the words: country AND currency
  5. Link:  http://en.wikipedia.org/wiki/List_of_circulating_currencies
  6. Fill in all the missing data!
  7. Stop!  Raise your hand!  Politely ask your teacher to check your work!

Part 6 - Create a Third Report (using the Wizard!)

  1. Create a report with the following features:
    1. Name, Currency, Population
    2. No grouping levels
    3. Sort ascending by the currency
    4. Title: Currencies of Several Countries
    5. Width: Adjust the width of each column so that all the data is visible on one sheet.
    6. Headings: Center and bold the heading on each column
  2. Open all three reports.
  3. Stop!  Raise your hand!  Politely ask your teacher to check your work!


Part 7 - Hand In the Project via Email

  1. In Access, SAVE!!! After saving, close and exit out of Access.
  2. Open up your school email account.
  3. Click Compose to begin a new email.
  4. Attach your database project to the email
  5. Subject line: Countries Final
  6. In the Address enter:  wissnera+hour@waylandunion.org
  7. AND in the Body enter:  Attached, please find my countries database project.
  8. Click on your Sent Mail to see that it sent, and immediately....
  9. Stop!  Raise your hand! Politely ask your teacher to look at your sent email.


Notes for Teacher

* At the start of day 2 or day 3, open a completed project, show the students what should be there, and review how to make a report and do some formatting using the Report Wizard.




!!!OLD - DO NOT DO ANYTHING BELOW THIS!!!

Written Directions for Part 1 and 2

    1. Read all the Part I directions before starting.
    2. Create a new blank database and save it with a standard filenname. Example: 20101207countries8smithjohn
    3. Add the following columns (fields):
      • Name - Text
      • Population - Number
      • Language - Text -- Hint: Some countries have more than one commonly or widely used language.
      • Area - Number -- Hint: Find this in square kilometers
      • Capital - Text
    4. Fill in data for following three countries: Hint: Wikipedia works well for finding the data.
      • United States
      • Canada
      • Mexico
    5. Create a report with the following features:
      • All of the fields (except for the index field)
      • No grouping levels
      • Sort ascending by the name
      • Adjust the width of each column so that all the data is visible on one sheet.
      • Title: Countries Sorted by Name
    6. Add seven more countries so you have a total of ten.
    7. Watch, listen, and follow along with this tutorial videos to do the steps above:
    8. Raise your hand. Politely ask your teacher to check the first report.


Source:   http://www.wayland.k12.mi.us/wms/staff/wissnera/database/countries.htm

Offline Resource

Countries Offline Data

Creative Commons License
This work by Aaron Wissner is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License.

Comments