1 / 18

Day 20: Homework IV Hints

Day 20: Homework IV Hints. Cody Cutright October 21st , 2014 CS 101. Due Date Reminders. Homework IV 10/31, by 11:55pm MyITLab Lesson D Monday November 3rd , by 11:55pm Homework V Friday November 7th , by 11:55pm. So… Homework IV…. If the mention of Homework IV makes you go:.

dolan-velasquez
Télécharger la présentation

Day 20: Homework IV 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. Day 20: Homework IV Hints Cody Cutright October 21st, 2014 CS 101

  2. Due Date Reminders • Homework IV • 10/31, by 11:55pm • MyITLab Lesson D • Monday November 3rd, by 11:55pm • Homework V • Friday November 7th, by 11:55pm

  3. So… Homework IV… • If the mention of Homework IV makes you go: …you’re quickly running out of time.

  4. General hints • Read the instructions all of the way through • Things that future steps ask you to do may give you a hint how to complete earlier steps

  5. General hints • Examine given tables for good ideas of what to name your fields Another good reason to read the whole assignment first!

  6. General hints • Examine given tables to understand what the formatting should look like

  7. General Hints • Close tables as you are done with them. • Remember, that Access is designed so multiple people can work on a database at once • This means that an open table is “locked” and nothing that references it can have changes made to it

  8. Remember to create tables in design view!!

  9. Add information to tables in datasheet view!

  10. General Hints • The MOST IMPORTANT THING you can do is be positive your tables are correctly designed • Improper table design will render your database unusable. • End of story.

  11. Specific Hints: Step 5v The field size must be a double(This has to do with how the field is stored in memory.) The format must be fixed. The decimal places must be 1. (5 vi. is very similar)

  12. queries • Query6b • Need two criteria on the same field, uses an AND ex: X>Y AND X<Z

  13. Queries • Query6c: • Create a query that lists each genre name, the number of shows within that genre, and the total number of viewers for that genre. • Hint: Need to use the Totals Row • Out of the three fields, one will use Count, the other will use Sum

  14. Queries • Query6c Continued: • Your results must include all genres, even if they have no shows Right click on the relationship in the querydesign, and select “Join Properties”

  15. Queries • Query6e • You can only use the provided formula if the Rating field in your Shows table is named the same – otherwise it needs modified

  16. Analysis Questions • Your AQ table should look like this in design view:

  17. Analysis Questions • If you run out of room to type responses, change the field data-type to long text.

  18. And Finally: • GO TO OPEN LAB.

More Related