Levels Tought:
Elementary,Middle School,High School,College,University,PHD
Teaching Since: | Apr 2017 |
Last Sign in: | 10 Weeks Ago |
Questions Answered: | 4870 |
Tutorials Posted: | 4863 |
MBA IT, Mater in Science and Technology
Devry
Jul-1996 - Jul-2000
Professor
Devry University
Mar-2010 - Oct-2016
You must upload the database name in this format
  1)  INFO261_WK4_{yourlastname}.accdb.
2) Make sure that you review Chapter 4 from the text book.Â
3) I encourage you to search the Internet for additional information.
4) The name of each Query should start with Week4.
Assignment:
Create at least 4 filters one for each table you have created in the database and save them as queries, you must explain the purpose of each query.
Create a query to show the schedule of each course and classroom location.
Create a query to show the enrollment of each student. (The student cannot be enrolled in more than one class at the same time)
Create a query to show the schedule for each Instructor. (The Instructor cannot be in be in more than one class at the same time)
The total Number of queries at least 10.
Submission Instructions:
Your completed database must be submitted as an MS Access 2013 database no later than the end of Week 4 on Sunday 11:55 PM EST.Â