ACCESS LAB ASSIGNMENT Date: 17th March, 2020

ACCESS LAB ASSIGNMENT      Date: 17th March, 2020

 

Total Marks: 10

 

1.      Creating tables                      (3 marks)

 

Create a database MCBSCollege and a table Faculty

           

Field Name

Data Type

Properties

FacultyID

FacultyName

Department

 

Accommodation

Date of joining

Designation

 

Tel_no

 

DOB

 

Sex

Number

Text

Text

 

Yes/No

Date & Time

Text

 

Number

 

Date &Time

 

Text(1)

Faculty Id : Primary Key

 

Caption: Department

Select from Lookup (CS,IT,MATHS, ESL)

Default: No

Today’s date only

Look up  options: (Lecturer, Sr.Lecturer, Asst professor, Professor)

 

Telephone  Number

(Total 8 and start with 9 or 7 or 2)

Date of  Birth

(between 1/1/1980 & 1/1/2000)

M or F

Enter 5 records for the table faculty using a form. Also add buttons FIRST, PREVIOUS, NEXT, LAST in the same form. Also add CLOSE button to close the form.

           

 

Create a table Courses with the following fields.

FIELD NAME                      TYPE             SIZE               DESCRIPTION

Faculty ID                              Number                                      Select from Faculty table

Course1                                      Text                         

Course2                                      Text             

Course3                                      Text                          

 

 Enter 5 records for the table Courses using a form. Also add buttons FIRST, PREVIOUS, NEXT, LAST in the same form. Also add CLOSE button to close the form.

 

2.      Queries and Reports             (5 marks)

 

Queries:

a.       Q1:      FacultyID, Name, Department,DateOfJoining

b.      Q2:      Count faculties from IT department

c.       Q3:      Update Faculty name from “Maram” to “Maryam”

d.      Q4:      FacultyID, Name, Department, courses from CS Department

e.       Q5:      FacultyID, Name, Department, courses from name starts with a

 

 

Reports

a.       R1:      Faculty courses (id, name, courses)

b.      R2:      Faculty accommodation (id, name, accommodation)

c.       R3:      Faculty joining (id, name, date of joining, designation)

d.      R4:      Faculty designation wise (id, name)

e.       R5:      Faculty and courses.

 

 

3.      Blank form with title and buttons   (2 marks)

 

a.       Create a blank form with command buttons for opening all queries, forms and reports. One more button for exit the application.

b.      The title of blank form is       

 

MODERN COLLEGE OF BUSINESS AND SCIENCE

Bousher, Sultanate of Oman

Answer Preview
This is only a preview of the solution. Please use the purchase button to see the entire solution