Please help with the assignment below. Access Project: Develop an Access Databas
ID: 3679034 • Letter: P
Question
Please help with the assignment below.
Access Project: Develop an Access Database that illustrates the registration process at Mount Olive College.
Based upon the information below, create a Microsoft Access Project that accomplishes the following tasks:
Project Part 2
Download the template from Moodle to use for the rest of this project.
Alter the course offerings table to include all necessary fields to create the ability to register students. (Hint, where are all the instructors and rooms?)
Add rooms and instructors to the registrations. Make sure Stephen Surles (ID 1) is teaching CIS430
Create foreign keys that enforce referential integrity and cascade among all the tables where necessary.
Display all the students registered for a section 1(section ID) of the CIS 430 course (course ID). Include in the display the following information for each student: first and last name, major, and matriculation date.
Display all the courses being taught by Stephen Surles, instructor (ID 1). Include in the display the course title, building, and number of students enrolled.
Display room usage information by the courses being taught in each room in each building.
Table Tools ProjectPart2Template: Database (Access 2007 Microsoft Access External Data Database Tools Home Create Cut Copy Datasheet ac Replace selection Advanced Y Toggle Filter Calibri A.) New Totals 11 Spelling A ] ay Refresh Xoelete-More A/ Filter View Paste /Format Painter B 1 u A Find All Delete --| More Select Views Clipboard Font Rich Text Records Sort & Filter in Security Warning Certain content in the database has been disabledOptions... E CourseOfferings CourseRegistrations a Courses ] Instructors | Rooms Students Relationships All Access Objects Search... Tables Y K -TermOffere-YearOffered-StartingTime , EndingTime . 1 SpringA 2 SpringB 3 SpringC 1 SpringA 2 SpringB 3 SpringC 1 SpringA 0 Building!D Add New Field CourselD BUS630 CIS300 CIS300 CIS430 EDU480 RLS499 SOC230 SectionID CourseOfferings CourseRegistrations Courses nstructors Rooms Students 2016 08:00 2016 13:00 2016 13:00 2016 09:00 2016 11:00 2016 16:00 2016 13:00 09:00 14:00 14:00 11:00 12:00 17:00 14:00 0 CourseRegistrations Reports CourseRegistrations Record: I 1 of 7 No Filter | Search Datasheet View Num Lock-Explanation / Answer
THE template which was already desinged and is getting executed but it is not getting transferred.
if there is any possibility I would have transferred