1 / 15

Day 20: Homework IV Hints

Day 20: Homework IV Hints. Cody Cutright March 24 th , 2014 CS 101. Due Date Reminders. Homework IV This Friday, by 11:55pm MyITLab Lesson D Monday March 31st, by 11:55pm Homework V Friday April 4 th , by 11:55pm. So… Homework IV…. If the mention of Homework IV makes you go:.

perry
Download Presentation

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 March 24th, 2014 CS 101

  2. Due Date Reminders • Homework IV • This Friday, by 11:55pm • MyITLab Lesson D • Monday March 31st, by 11:55pm • Homework V • Friday April 4th, 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. 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.

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

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

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

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

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

  14. Analysis Questions • If you run out of room to type responses, change the field data-type to memo.

  15. And Finally: • GO TO OPEN LAB.

More Related