Consider the following fewrelations of Academic systems. 1. Semester ( SemNo ,Se

Question

Consider the following fewrelations of Academic systems.

1. Semester (SemNo,Sem_Dur, Start_Date, End_Date)

2. Professor (VUPid, P_Name, Age, Deptid, CourseCode)

3. Prof_Exp(VUPid,Experience)

4. Department (Deptid, D_Name, Main_Office,HOD)

5. Project (Pid,Title, Start_Date, Due_Date, Prj_Instructor)

6. CoursePre-Req(CourseCode,Pre-requisite)

7. Course (CourseCode, C_Name, Prg_Code)

8. Student (VUSid, Std_Name, Std_Age, Prg_Code,)

9. Program (Prg_Code, Prg_Name, No_of_Sem,Min_CGPA)

10. ProgramDur (Prg_Code , Max_Dur)

A. Need to perform following operations in MS-AccessApplication project

(Go to Tools menu FileNewBlank database)

You are required to:

I. Create relations/Tables and the relationshipsamong them in MSAccess

II. Create 3 data/entry Forms (Student Details,Professor Details, and Course

Details).

With command buttons: Save, Cancel,Navigation

III. Create a Master/Detail Form for transactionsusing SUB forms.

IV. Application Menu

Creating the Main Switchboard is straightforward. You go to theTools

menu --> Database Utilities --> SwitchboardManager.

Master/DetailForm:

Student Name:

Roll No:

Start /Enrolled Date:

Sub-form1(with followingcolumns)

Course Code CourseName

Sub-form2 (withfollowing columns)

Project Code, ProjectTitle

Explanation / Answer

First create your table in design menu

Show all table form tool….. relationship …. addall

Edit relations …. From relation ship menu

Create forms of all tables

And so on

The big thing is the use of help assistant in MS ACCESS

Type your question about your work and follow theinstruction

Hope it will be very easy for you

For example you want to create a sub form

Type question “ create a sub form “ in helper“office assistant” box

Follow the path to get require result

All will be very easy

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.