ACCESS PRACTICAL

PRACTICAL - 1

CREATE A NEW DATABASE WITH A TABLE AS STUDENT ADMISSION TABLE AS GIVEN BELOW.

COMMAND-:

PRACTICAL - 2

USING STUDENT ADMISSION TABLE CREATE STUDENT ADMISSION FORM WITH APPROPRIATE FORMATTING EFFECTS AND ENTER 10 SET OF STUDENT RECORDS.

COMMAND-:

 PRACTICAL - 3

CREATE A NEW TABLE AS STUDENT PAYMENT TABLE AS GIVEN BELOW.

COMMAND-:

PRACTICAL - 4

CREATE A RELATIONSHIP BETWEEN STUDENT ADMISSION TABLE AND STUDENT PAYMENT TABLE.

COMMAND-:

PRACTICAL - 5

USING BOTH TABLE CREATE A COMBINED FORM AS STUDENT PAYMENT FORM THAT MUST INCLUDE FOLLOWING FIELDS. APPLY FORMATTING EFFECTS AS PER REQUIREMENTS AND ENTER 10 SETS OF PAYMENT RECORDS.

ROLL NUMBER

STUDENT FIRST NAME

STUDENT LAST NAME

ADDRESS

DATE OF PAYMENT

AMOUNT RECEIVED

PAYMENT TYPE

COMMAND-:

PRACTICAL - 6

CREATE STUDENT PAYMENT QUERY AS GIVEN BELOW.

ROLL NUMBER

STUDENT FIRST NAME

STUDENT LAST NAME

AMOUNT RECEIVED

COMMAND-:

PRACTICAL - 7

USING BOTH TABLES CREATE A STUDENT PAYMENT REPORT.

ROLL NUMBER

STUDENT FIRST NAME

STUDENT LAST NAME

AMOUNT RECEIVED

COMMAND-:

ACCESS PROJECT

1. CREATE STUDENT_INFO TABLE.

2. CREATE STUDENT_MARK TABLE.

3. APPLY RELATION(ONE TO ONE) BETWEEN TWO TABLE.

4. CREATE STUDENT_MARKSHEET_ENTRY_FORM AS GIVEN.

5. CREATE BUTTONS FOR NAVIGATION AND ENTER 10 SET OF STUDENT RECORD.

6. APPLY FORMULA FOR TOTAL AND SECURED MARK IN STUDENT_MARK TABLE.

7. CREATE STUDENT_MARKSHEET_QUERRY WITH SEARCH OPTION.

8.CREATE MARKSHEET FORM WITH SEARCH OPTION.

9. DISPLAY MARKSHEET IN PRINT PREVIEW MODE.