Wednesday, February 08, 2006

MS Access - 2/8/2006

Today we finished up Chapter Four (Queries).  We covered lovely topics such as the filter (the little tornado buttons) and the Unmatched query (finding records in one table that don’t have buddies in the other table).  

Next week we’re having a test on Chapter 1-4.  Make sure you know all about queries – they are very important in the design of databases, so I’ve made the test a little heavy on them.  The test has 21 M/C questions and 3 Skill Assessment questions.  When you’re studying, make sure that you go over the questions I reviewed with you, and make sure that you work your way through the ten skill assessment questions that start on page 131.  If you know those, you should do fine.

Oh, and thank you guys so much for the Bowl for Kids’ Sake support!  Seriously, that means a lot to me!

Homework:
  • No homework in lieu of studying for the test!

  • Good luck!

1 comment:

Anonymous said...

Dear Ben I am stuck on a question. In Assesement 2 . I was creating a relationship for Price Code in the Prices table as one and price code in the Events table as many and it would not let me. Can you explain why.It said I had to uncheck the referential integrity so I did but the relationship was not like the others. What did I do wrong. Please e-mail me at hewitthorses@nctc.com and let me know. Thank you Edna