BA325

1
BA325 Competing with Information Technology

• May 3, 2002
• Susan Anderson

2
Agenda

• Last week
• Chapter 7 Discussion
• Group Exercise
• Group Time
• Chapter 8 Discussion
• Discuss Access Homework Concepts
• Debrief Midterm
• Homework next week

3
Last Week

• Chapter 6 Telecommunications and Networks
• Principles of communication within a computer
  system and among computers
• Major media and devices that are used in
  telecommunications
• Different network layouts and the concept of
  protocols
• How telecommunications can improve operations in
  organizations

4
Last Week, contd

• Latest developments in telecommunications media
  and transmission speeds
• Telecommuting pros and woes

5
Go to Chapter 7 Slides
6
Group Time

• Review feedback on team outlines and approaches
• Determine how you will accomplish next weeks
  group assignment

7
Go to Chapter 8 Slides
8
Access Homework Tutorial 2

• This week you learned about the following
  concepts
• Composite Keys
• Common Fields
• Data Redundancy
• Data Type examples?
• Field Size
• Format Property

9
Access Homework Tutorial 2

• Entity Integrity
• Null Value
• Updating (Maintaining)
• Navigation Mode
• Editing Mode

F2 Key
10
Access Homework Tutorial 3

• Select Queries
• Query By Example
• Join
• One-to-Many Relationship
• Primary Table
• Orphaned Record
• Referential Integrity
• Sorting Sort Key

11
Access Homework Tutorial 3

• Filter
• By Selection and by Form
• Condition
• Logical Operators
• And / Or
• Expression
• Expression Builder
• Aggregate Function

12
Midterm Last Week

• I am throwing out the following poorly worded
  questions

A B C
29 4 20
46 13 35
49 72 70
79 88 87
13
Midterm Debrief

• Average was 88 (Score/ Possible)
• Review concepts that were consistently missed
• Challenges now or never

14
Next Weeks Homework

• Complete CASE 1 for Tutorial 4
• Group Project Draft of executive summary
• One page max double-spaced