BA271 Week 8 Lecture Simple Queries

1
BA271 Week 8 LectureSimple Queries
Caution Writing queries may be the hardest part
of this class all term

• Dave Sullivan

2
Status Report

• Review where we are
• Website Project partly graded
• Access 1 graded
• Access 2 Will be harvested after class.

3
Todays activities

• Build simple queries
• Look at the Winter 2004 terms Query Quiz
• Talk about rules to use when selecting the tables
  to put in the top half of a querys design view.

4
Rules for building multi-table queries

• Everything that will appear in the answer must be
  in the top half of the querys design view.
• All tables in the top half of the
  query-by-example form must be linked together.
• Dont put any extra tables in the top half of
  the query.

5
Activities you should do

• Complete the Access 3 assignment by Friday at 2
  p.m.
• Consider working though queries in the Query Quiz
  portion of the BA271 website.

6
Todays work sample

• Use a 4 by 6 card to create an Access-like
  Entity-Relationship diagram with tables, fields
  and one-to-many relationships that captures the
  data from the next slides Invoice report.

7
(No Transcript)