Limited time offer 20% OFF StudySoup Subscription details

UH - CIS 2334 - Study Guide - Final

Created by: ktaha Notetaker Elite Notetaker

UH - CIS 2334 - Study Guide - Final

School: University of Houston
Department: Computer Information Systems
Course: Information Systems Applications
Professor: Mark Stinnit
Term: Fall 2016
Tags:
Name: Practice Notes
Description: Practice Notes
Uploaded: 12/10/2016
0 5 3 71 Reviews
This preview shows pages 1 - 3 of a 8 page document. to view the rest of the content
background image UH | CoT | ILT MS Access Exercise 2 Saved: 19-Oct-16 CIS 2334 | Fa16 Instructions 17596  Printed: 7-Oct-15 Assume  that all practice exercises are similar to problems on Exam 3 (Final Exam).  MS  Excel exercises depend on the completed MS Access exercises. Assume  you are responsible for developing & delivering the Catalog module of a larger  application (Helper) that will help Instructors: Better organize their course material – specifically, courses,  Organize learning objectives throughout the semester. Assume  you are using the same methodology that you are using for your CIS2334 Client  Project.  Use the MSA Exercise 1 Documents to complete the following: E XERCISE  1 – C REATE  C ATALOG   TABLES QUERIES   AND   SINGLE   TABLE   FORMS /R EPORTS The tabs in Fa16_MSAExercise1.AttributesQueriesLookups.xlsxm provide all the 
information needed to complete this exercise.
The accompanying .txt files include all data need to populate all tables - .txt files have 
the same name as the table into which their data is to be loaded.
The Attributes, Queries & Lookups spreadsheet contains five tabs - Cover, Attributes, 
Queries, Lookups, and Validation.  To complete the exercise most efficiently, use the 
definitions in AttributesQueriesLookups.xlsx to do the work in the following order:
Create tables (See Attributes tab) o Create tLookup
o Create parent table(s) - tInstructor
o Create child table(s) - tCourse
Link tables using PK=>FK in Database
Tools\Relationships
o Add parent & child tables to canvas
o Link parents to children using parent PKs &
child FKs o Add tLookup to the canvas, but do not link it o Modify tables to deal with any linking issues Add data to tables  (using .txt, .xlsx & .csv files) o Add data to tLookup
o Add data to parent table(s) - tInstructor
o Add data to child table(s) - tCourse
o Modify tables to deal with any data import issues
Create queries  (Queries tab) o Create field validation lookup queries (qluMajor, qluSemester)
o Create 1-to-m lookup queries (qluInstructor)
o Create simple table queries for tInstructor, tCourse & tLookup (“q” prefix)
Fa162334_MSAExercise2Instructions Mark Stinnett – tmstinnett2@uh.edu 17596  Page 1 of 5
background image UH | CoT | ILT MS Access Exercise 2 Saved: 19-Oct-16 CIS 2334 | Fa16 Instructions 17596  Printed: 7-Oct-15 o Modify tables and/or linkages and/or queries to deal with any errors Add lookups to tables o Use qluMajor to add the Major data validation lookup to tCourse.MajorID
o Use qluInstructor to add the 1-to-m lookup to tCourse.InstructorID
o Use Datasheet View to confirm that lookups work as expected
Create forms o Create single table forms, based on their “q” queries, for tInstructor, tCourse &  tLookup o Modify tables, links, forms, validations, and lookups to work as expected     Create reports o Create single table listings, based on their “q” queries, for tInstructor, tCourse & tLookup o Modify tables, links, and listings to work as expected Fa162334_MSAExercise2Instructions Mark Stinnett – tmstinnett2@uh.edu 17596  Page 2 of 5
background image UH | CoT | ILT MS Access Exercise 2 Saved: 19-Oct-16 CIS 2334 | Fa16 Instructions 17596  Printed: 7-Oct-15   Fa162334_MSAExercise2Instructions Mark Stinnett – tmstinnett2@uh.edu 17596  Page 3 of 5

This is the end of the preview. Please to view the rest of the content
Join more than 18,000+ college students at University of Houston who use StudySoup to get ahead
8 Pages 113 Views 90 Unlocks
  • Better Grades Guarantee
  • 24/7 Homework help
  • Notes, Study Guides, Flashcards + More!
Join more than 18,000+ college students at University of Houston who use StudySoup to get ahead
School: University of Houston
Department: Computer Information Systems
Course: Information Systems Applications
Professor: Mark Stinnit
Term: Fall 2016
Tags:
Name: Practice Notes
Description: Practice Notes
Uploaded: 12/10/2016
8 Pages 113 Views 90 Unlocks
  • Better Grades Guarantee
  • 24/7 Homework help
  • Notes, Study Guides, Flashcards + More!
Join StudySoup for FREE
Get Full Access to UH - CIS 2334 - Study Guide - Final
Join with Email
Already have an account? Login here
×
Log in to StudySoup
Get Full Access to UH - CIS 2334 - Study Guide - Final

Forgot password? Reset password here

Reset your password

I don't want to reset my password

Need help? Contact support

Need an Account? Is not associated with an account
Sign up
We're here to help

Having trouble accessing your account? Let us help you, contact support at +1(510) 944-1054 or support@studysoup.com

Got it, thanks!
Password Reset Request Sent An email has been sent to the email address associated to your account. Follow the link in the email to reset your password. If you're having trouble finding our email please check your spam folder
Got it, thanks!
Already have an Account? Is already in use
Log in
Incorrect Password The password used to log in with this account is incorrect
Try Again

Forgot password? Reset it here