Access Resource Page for ITMG 100

Big Data You Tube Video http://youtu.be/2D8oji5EKbM Video tutorials (note you have controls on the right hand side of the screen to move the different screens when they contain video and screen shots)

 

In-Class Access Lab Assignment how to download access, rename for test
  how to create relationships in access database
Access Lab Tutorial Files how to import an excel file into access as a table
access lab intro how to create a select query (question 1 from access practice)
normalization how to create a "SELECT 'AND' Query (question 3a from access practice)
harkins (unnormalized table) how to create a multi table drill down query (question 5 from access practice)
access lab exercise 2 how to create a "OR" query (question 9 from access practice)
access lab exercise 3 how to create a calculated field query (question 10 from access practice)
access quick ppt review how to create a report from a query in access (question 11 from access practice)
  how to export an access query to excel and create a chart (question 6 from access dec 11 2014 review)
   
old access exam review guide ACCESS PRACTICE
old access exam review movie database ONE access database for practice
old access exam review movie database employees3 file for practice
  ANSWERS TO ACCESS PRACTICE (pdf)
employees file for ole access exam revie ONE ANSWERS TO access practice (database)
ANSWERS TO OLD EXAM REVIEW (pdf) ANSWER to access practice question 10
OLD ACCESS_EXAM_REVIEW_ANSWERS(DATABASE)        
question eight answer (excel file) ACCESS DEC  REVIEW SESSION      
  movie file for access database      
access lab exercise HOURS employees file for access lab exercise      
access movie database for HOURS ANSWERS TO ACCESS REVIEW SESSION (PDF)
employees file for access lab exercise database file for answers to ACCESS REVIEW SESSION
ANSWERS TO LAB EXERCISE HOURS answer question 6 from ACCESS REVIEW SESSION
ANSWER Database file  to Lab Exercise HOURS  
answer question 12 from Lab Exercise HOURS OTHER ACCESS RESOURCES
ANSWERS TO LAB EXERCISE HOURS SECTION 9 http://allenbrowne.com/tips.html
ANSWER Database file  to Lab Exercise HOURS SEC 9 http://www.fabalou.com/
answer question 12 from Lab Exercise HOURS SEC 9 http://www.eraserve.com/tutorials/
  http://office.microsoft.com/en-ca/access-help/examples-of-microsoft-access-data-entry-forms-switchboards-and-dialog-boxes-HA001034548.aspx
PowerPoints  
Chapter Five Data and Knowledge Management  
Chapter Twelve Business Intelligence