BCOT 114--Access Assignments

 

Name:  _____________________________________________    

          

Student No.: ______________________                                                Session & Ticket: SPRING 2014/#21521

 

NOTE: Send the entire database unless otherwise instructed.

ACCESS

PTS

ACCESS

PTS

Section 1 Section 3
REVIEW 1:
WEEmployees1.accdb
    Employees Table
  REVIEW 1:
WEEmployees3.accdb
   
HiresAfter2004
 
ASSESSMENT 1:
NPCGrades1
  SM100-01Grades table
  REVIEW 2:
WEEmployees3.accdb
   
Review
 
ASSESSMENT 2: InventoryListTable1.accdb
  InventoryList table
  REVIEW 3:
WEEmployees3.accdb
   
LifeInsceList
 
ASSESSMENT 3: CostumeInventory1.accdb
  CostumeInventory table
    
Step 7    (Print Screen to show Filter)
    
Step 11 (Send complete database)
(Worth 4 pts.)
  ASSESSMENT 1: NPCGrades3.accdb
  A+Students
 
    ASSESSMENT 2: PTCostumeInv3.accdb
   Step 6   Query
   Step 14 Report

(Worth 4 pts.)
 
Section 2 ASSESSMENT 3: PTCostumeInv3.accdb
  
Create a
form and make changes
REVIEW 1:
WEEmployees2Relshp.accdb
    Review Table
     
REVIEW 2:
WEEmployees2Relshp.accdb
   
Review2 Relationship
     
ASSESSMENT 1: NPCGrades2.accdb
    AC478-01Grades table
     
ASSESSMENT 2: PTCostumeInventory2.accdb
    CostumeInventory table