1 / 25

Homework V Hints

Homework V Hints. Cody Cutright CS 101 April 2 nd , 2014. General Notes. This homework does have a different feel than Homework IV The exam will be more like Homework IV Don’t be discouraged by this homework, stick with it. Mr T. – Don’t disappoint him. Step 1. Download the data files

tommy
Download Presentation

Homework V Hints

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Homework V Hints Cody CutrightCS 101April 2nd, 2014

  2. General Notes • This homework does have a different feel than Homework IV • The exam will be more like Homework IV • Don’t be discouraged by this homework, stick with it

  3. Mr T. – Don’t disappoint him

  4. Step 1 • Download the data files • Extract the files • Observe the file icons: • This means they are XML files and we will need to import them later

  5. Step 3 Hints • External Data -> XML • Browse for File -> Click OK • Ensure “Structure & Data” is selected • -> Click OK -> Then click Close • Repeat for second file

  6. Step 4 • Remember, the Table has to be done in Design-View before you can enter records in Datasheet View These are the fields you create in Design-View

  7. Step 4 • You will need to pick the appropriate data types before you enter data… text would be a good idea • The AirlineType is a Lookup Field • Don’t forget the primary key

  8. Step 5 • The relationships require you to match up fields with the same names. • Pay attention to instructions – DO NOT ENFORCE REFERENTIAL INTEGRITY

  9. Step 6a • Remember, half the battle is selecting the correct fields.

  10. Step 6B • For the criteria, remember that AND means two criteria show up in the same row • Largest Airline (Legacy Carrier) and the Cheapest Airline (Low-Cost Carrier) • The criteria must be entered exactly as it is in the AirlineType Field of your AirlinesTable • *Remember, the hint tells you how many fields you see when you run the query, not what you see in design view

  11. Step 6C • Remember, OR criteria must appear in two different rows.

  12. Step 6D • Hint, is it true an airport is a hub?

  13. Step 6E • Do NOT copy and paste the formula from this section into Access. • (Notice that if you try, it copies and pastes in Italics – Access doesn’t use italics so this breaks the query) • Type it in manually

  14. Step 6F • We did this in class somewhere between 6 and 8 times the other day… • Start making a new query, click the SQL button in the bottom right, copy and paste the SQL code • *Note that you can copy and paste this code because it is formatted to allow it

  15. Step6G • You only need to show the OriginAirportstable and Query6Ein the query design view

  16. Analysis Questions • DO THIS CORRECTLY Analysis Questions in Design-View QUESTION IS TEXT RESPONSE IS MEMO

  17. Analysis Questions Analysis Question in Datasheet View

  18. CHECK FOR THESE THINGS: • Did you apply the sorts correctly? • Remember Access sorts left-to-right • Did you format the decimal places correctly? • Sometimes you have to run the query before it will let you format the decimal places • Did you rename any calculated fields? • Expr1: is NOT an appropriate field name and will result in points lost. Fields names must be descriptive • Ex: in 6G, Passengers-per-Resident would be an appropriate calculated field name

  19. CHECK FOR THESE THINGS: • Report Wizard • Did you rearrange/resize the fields so I can read EVERYTHING? (Seeing #### on your homework report will result in points lost) • Analysis Questions: • Do they start with a capital letter and end with a punctuation mark? • Do they make logical sense and answer the question? • Did you just type in words to have something for a response? (You will lose all the points if so.)

  20. Exam Hints

  21. Study Resources • Study Guide • http://cs101.wvu.edu/media/1715/microsoft_access_study_guide.pdf • Review Projects • http://cs101.wvu.edu/resources/exam/review-projects/#tabs-access

  22. Other things to lookover THIS IS NOT AN ALL INCLUSIVE LIST Picking primary keys, Creating relationships, Importing Data, Picking Data Types, Renaming Calculated Fields, Calculated Fields, Formatting (For example, as currency), Decimal Places, Sorting, Criteria. How Sort Order Works (left-to-right), Total Query Option (what wording do we look for?), Form Wizard , Report Wizard ( HOW TO REARRANGE FIELDS SO I CAN READ EVERYTHING)

More Related