information system assignment

zxy0120
case1info.docx

Background:  While in college obtaining his bachelor’s degree in Raleigh, North Carolina, Brent Hovis majored in computer science and learned programming.  Brent found that many of his fellow classmates found it difficult to write code, and he was constantly assisting them with helpful tips and techniques.  Prior to graduating, Brent began tutoring freshman and sophomore students in programming to make some extra money.  As his reputation grew, high school students began contacting him for help with their programming classes.  When Brent entered graduate school, he started  Programming Pros, a company offering expanded tutoring service for high school and college students through group, private, and semi-private tutoring sessions.  As demand for the company’s services grew, Brent hired many of his fellow classmates to assist him.  Brent wants to use Access to maintain information about the tutors who work for him, the students who sign up for tutoring, and the contracts they sign.  He needs your help in continuing to develop this database. Download the Programming database attached at the beginning of this post as the starting point for Case Problem A (pages AC 108-AC110).  When you open the database in Microsoft Access you may get a Security Warning.  Click "Enable the Content."  You will also need to download three additional files.  They, too, are found at the beginning of this post. All other required documents (Client.accdb, Students.txt, Agreements.xlsx) can be found the the MS Access Start-Up File.

Open the Programming database and in the "Tutor" table find the tutor with TutorID 1060.  Notice that this tutor's first name is "Student First" and last name is "Student Last."  Replace these two fields with YOUR first and last names.

Then complete Case Problem 2 on pages AC 108-110 to help Brent continue to build the Programming database.  When you complete this work, be sure to close the database and exit Access.  Then upload the database here.  Name it CaseProblem2.yourfirstname.yourlastname. Make a backup copy of the database you uploaded.

Macintosh HD:Users:zhangxinyuan:Desktop:屏幕快照 2017-10-16 上午10.24.15.png

Macintosh HD:Users:zhangxinyuan:Desktop:屏幕快照 2017-10-16 上午10.21.02.png

Macintosh HD:Users:zhangxinyuan:Desktop:屏幕快照 2017-10-16 上午10.21.27.png

Macintosh HD:Users:zhangxinyuan:Desktop:屏幕快照 2017-10-16 上午10.21.35.png
Macintosh HD:Users:zhangxinyuan:Desktop:屏幕快照 2017-10-16 上午10.21.48.png

Macintosh HD:Users:zhangxinyuan:Desktop:屏幕快照 2017-10-16 上午10.22.00.png

Macintosh HD:Users:zhangxinyuan:Desktop:屏幕快照 2017-10-16 上午10.22.08.png