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 from)
excel version
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 a
ccess 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
D
atabase 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
D
atabase 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
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)