Follow the directions below to complete the Coaches Questions Activity
- Open a Word document and save as:
- last-first-coaches-questions
- All your answers will go in this document
- Open your Coaches.mdb database (see files to copy or this link if you were absent)
- Use sorting and filtering techniques you learned in class last time to answer the following:
- How many coaches are in the database?
- Who is the coach at Sisters High School?
- How many coaches are from Salem?
- How many schools have a 541 area code?
- How many schools are from the 3A class (of any type)?
- One school does not have a listed zip code. Find the school and find the zip code for it!
- (Use Google or your favorite search engine)
- List the schools that are in Milwaukie
- Alphabetize your list by coach's last name. Does it seem to matter whether or not the name is capitalized?
- Select the tools icon in the upper left corner. (Also known as Design View)
- What is the datatype for DateUpdated?
- What is the field size for Address?
