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