Level II Test Review

1
Level II Test Review

• Lookup Wizard Field
• Matching-Non-matching search
• Comparison Operators
• Logical Operators
• Calculated Fields
• Custom Report
• Data Access Page
• Pivot Chart

2
Stadium Table Lookup
3
(No Transcript)
4
(No Transcript)
5
(No Transcript)
6
(No Transcript)
7
Level III
8
Level III

• Tutorial 9
• Action Queries
• Table Relationships
• Tutorial 10
• Macros
• Tutorial 11
• Visual Basic for Applications
• Use the Comp practice file folder for all Level
  III assignments

9
Action Query

• Adds, changes or deletes multiple records at one
  time
• Make-Table Query
• Append Query
• Delete Query
• Update Query

10
Action Queries
Query Button
11
Make-Table Query

• Creates a new table from one or more existing
  tables. Can be exact copy or subset
• Does not delete records from the existing tables
• Can make backup tables
• New table is based on data at that time

12
Append Query

• Adds records from an existing table or query to
  another table
• This doesnt affect the original table

13
Delete Query

• Deletes groups of records from one or more tables
• Use selection criteria to select records to
  delete
• This is permanent

14
Update Query

• Changes selected records in one or more tables
• Use selection criteria

15
Table Relationships

• One-to-many (1M)
• Many-to-many (MN)
• One-to-one (11)

16
Relationships
Many-to-Many Between Position and Student
One-to-One
One-to-Many
17
Join Type
Join Type Button
18
Join Properties
19
Inner Join

• A join in which Access selects records from the
  two tables only when the records have the same
  value in the common field that links the tables
• This is the type join we have been using

20
Left Outer Join

• Selects all records from the first, or left table
  and only those with matching common field values
  from the second Table

21
Result
22
Right Outer Join

• Selects all records from the second, or right
  table and only those with matching common field
  values from the first, or left table

23
Right Outer Join Setup
24
Result
25
Self-Join

• Can be either inner or outer join
• Use two copies of the same table

26
Result
27
Index

• A list that relates field values to the records
  that contain those field values
• Access automatically creates and maintains an
  index for the tables Primary Key
• And for foreign keys
• Fastest way to search for records
• Makes updating slower

28
Index
29
Final Project

• Due Wednesday December 7, 2005
• Let me know if you have questions

30
Review Assignment6 Printouts

• References
• Step 3 page 462
• Step 4 page 445
• Step 5 page 453
• Step 6 page 449
• Step 7 page 451
• Step 8 page 466
• Step 9 page 476

31
Lets do Tutorial 9