database homework

⦁    Go to the Database Tools -> Relationships control. Add all of the tables in the database in preparation for creating the database constraints.
⦁    Attempt to create a foreign key constraint between tblStudents and tblMajor.  Your join condition should resemble the following:
 
⦁    Did creating the foreign key constraint between tblStudents and tblMajor work?
⦁    Attempt to create foreign key constraints between tblStudents and tblClassYear. Did it work? If not, correct the data in the database tables to allow for the foreign key (referential integrity) constraint and try again.
⦁    Create a form for the table tblClassYear and save it as frmClassYear. Open the form and view the data in the table tblClassYear that you changed in step 4.  This is how you would normally change data in a table (not going directly to the table as you had to do in step 4).
⦁    Create a custom form for viewing and updating student information and name it frmStudentInfo, using the video https://www.youtube.com/watch?v=Hp6EPNF1xpY, and the image file
⦁    Now create a Navigation form by going to the Create -> Navigation menu and selecting “Horizontal Tabs” (See below

 

⦁    Add the 2 forms you created in the previous steps to the tabs in the navigation form.