Homework V Hints

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

3. 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

4. Mr T. – Don’t disappoint him

5. 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

6. 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

7. 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

8. 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

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

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

11. 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

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

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

14. 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

15. 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

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

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

18. Analysis Questions Analysis Question in Datasheet View

19. 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

20. 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.)

22. Exam Hints

23. 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

24. 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)