Transcript ACCESS – Chapter 1

HOMEWORK IV HINTS
DUE DATE REMINDERS
• Homework IV
– 10/31 (Friday)
• MyITLab Lesson D
– Monday November 3rd
• Homework V
– Friday November 7th
SO… HOMEWORK IV…
• If the mention of Homework IV makes you go:
…you’re quickly running out of time.
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
GENERAL HINTS
• Examine given tables for good ideas of what to name your
fields
Another good reason to read the whole assignment first!
GENERAL HINTS
• Examine given tables to understand what the formatting
should look like
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
REMEMBER TO CREATE TABLES
IN DESIGN VIEW!!
ADD INFORMATION TO TABLES IN
DATASHEET VIEW!
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.
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)
QUERIES
• Query6b
– Need two criteria on the same field, uses an AND
ex: X>Y AND X<Z
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
QUERIES
• Query6c Continued:
– Your results must include all
genres, even if they have no
shows
Right click on the relationship in the query
design, and select “Join Properties”
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
ANALYSIS QUESTIONS
• Your AQ table should look like this in design view:
ANALYSIS QUESTIONS
• If you run out of room to type responses, change the field
data-type to long text.
AND FINALLY:
• GO TO OPEN LAB.
(OR)
• Drop me an email at
[email protected]
OR
[email protected] (for faster response)