Access Two Assignment
(as of 13 June)
This homework will expand on the database that we
created in class.
- Add your name and pertinent information to
the
Members
Table. (20 %)
- Add three different transaction records for
yourself.
(15 %)
- Using the screen (form) we created in the
lab, find your
record
and the related transactions. Print this out to be handed
in.
It should include your transactions. Turn in ONLY the page that
shows
your member information and transactions, not a printout of the entire
database. (15 %)
- Explain why the screen (form) we
created in class (used
in
number 3 above) cannot be used to add a brand new member to the
database,
but it can be used to add new transaction records for an existing
member to
the database. (if you can't figure out why - try to add a new
member
using that screen - you can't - and try to intrepret the error message
that pops up). Write your answer to this question on the bottom
of
the report you create for number 5 below. (20 %)
- Create a report using the report wizard that
uses the
following format. (Hint: it is called tabular form.) Print
out all the member data in the database using this report. ( 30% )
Member Information
Current date
Member
ID Title
Last Name First Name
Address
City State
Zipcode Date Joined
(all the member
records should be printed out
here
- watch your formatting!)
Please staple your two sheets of paper
together.
Make sure you remember to answer question number 4 !