Documents Available Fall Schedule Spring Materials
August 31 First
Day Handout Assignment
1
Files for Additional
Assignment Also called StepByStepTableDesign
September 7 Assignment 2 Access
Tutorial 2 - Maintaining a Database
September 14 Assignment
3 Gradebook
Field Possibilities Exercise
LAST YEAR’S Project
Requirements (yet to be adjusted for this year)
September 21 Assignment 4 No class
September 28 Assignment No class
October 5 Assignment 4 Wildcard
Practice Complete
Tutorial 4 and all incomplete homework.
Unless some of you are just holding out on me, you are very behind. We should be testing tonight on Tutorials 1
- 4. We will skip the in-class review on
this one so we can, for sure, have the in-class review
on the Test II. Attached is the
review.
The
assignment for Tutorial 4 is simply to do the tutorial (textbook chapter). This is making it very, very light and, I
hope you will learn enough doing just this small amount.
Your grades as
they exist right now are on the website.
Go to www.kennedydatasolutions.net/G00########.pdf
( That means to put your G00 number then a period and
pdf) Only you will know your G00 number
to be able to see it. If you have no
Chapter 1, 2, 3, etc. below your attendance and no checkmarks in HW1, HW2,
etc., I have no work for you. This is
week 6! 1/3 of the course has
passed! I know we have had some
setbacks, but you must get going!
October 12 Assignment Test
I Review Test
I Review Answers QBE
Pane for Practicing!
October 19 Assignment
October 26 Assignment IIF and Calculated
Fields Gradebook Sorting
and Grouping Examples
November 2 Assignment Test II Review
Instructions Test II Review
Database
We will go
over Chapter 9.1 (We skip 8 completely) and then complete the test review. Do try to do it on your own;
you might enjoy
having two weeks to work on it. The test
will be very similar but a little shorter.
HOMEWORK: You need to be caught up by our test on
November 16! Homework turned in but not
graded may be a 100
automatically, but homework
not turned in is a zero! All must be
caught up by November 16’s test!
That’s two weeks!
November 9 Assignment REMEMBER - Tutorial
portion of each Chapter 1 - 7 is due on November 16 at the test! We did a couple of reviews, but the
homework assigned has been
very light in amount and just following the book’s instructions - nothing on
your own, which I expect you to learn by yourself.
You may certainly do
additional work!
Additional materials for future assignments:
Aggregates
and Calculated fields Grouping in reports 1 Conditional
IIFs and Many-to-Many Joins
Pix of
Grouping Sections Exploring
Nested IIFs.doc
Relationships Chapter 9.doc Update Query example.jpg Exploring Nested IIF Functions
November 16 Assignment
November 30 Assignment More on
CalculatedFieldsOrAggregateFunctions
FinalWrapUp SortingAndGroupingExamples
December 7 Assignment Access
XP Test III Review With Answers Calc Field Or Aggregate Project
Grading Sheet
Explanation-Joining
Many-to-Many With Detail Table Find Duplicates
Query
InvestigatingJoins1.mdb Join Type
Examples Join Type
Info
Joins
Investigated Completed Many-To-Many
Trial.mdb Level III Notes
Northwind
Dissected Relationships
Chapter 9 Relationships
December 14 You only thought we were finished!
Access
is not easy. However, just think about
this:
To get to this very important
place, someone says to you: “Go down
this street (the one you are on) and when you see a stop sign
on
the right, go right for 5 blocks. Then
make a left. Go that way for 3 miles
until you come to a blue house. At the
blue house,
make
a left and go 7 miles until you see a house with red brick and white trim. Make a right there and go 2 blocks. The house
will
be the one on your right.
Sounds pretty easy, but what if
you miss the first stop sign. It is
behind a bush. You go to the second stop
sign. You otherwise follow
the
directions. Do you think you will be
anywhere near the desired house?
Probably not! However, just
fixing one “turn” would
have
put you on the right track.
The table design is like that
turn. If your PK-FKs are not set right,
or if you have fields on the wrong table, then you have made
an early wrong turn that takes you
“nowhere.”
Fix that, and you have a pretty
good database.
Here’s an example! Original Database with problem Instructions on fixing it One for practice
What Do We Need to Do? Table Design PowerPoint Vet Office Example
