Scribd
Upload
25 views1 page

MS Access Assignment for Students

The assignment involves creating a table in MS Access for student personal information with specified fields and data types. It requires the creation of a form with navigation buttons and a report using the report wizard. Additionally, a query must be formed to find individuals whose names start with 'R' while filtering by session.

Uploaded by

Himanshu Mehar
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
25 views1 page

MS Access Assignment for Students

The assignment involves creating a table in MS Access for student personal information with specified fields and data types. It requires the creation of a form with navigation buttons and a report using the report wizard. Additionally, a query must be formed to find individuals whose names start with 'R' while filtering by session.

Uploaded by

Himanshu Mehar
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

BASIC IT TOOLS

ASSIGNMENT III

MS ACCESS

1.) Create a table having student’s personal information:

FIELD NAME DATA TYPE


Roll number
Name
Session LOOKUP WIZARD
DOB
Resident of India
STATE LOOKUP WIZARD
YEARS OF EXPERIENCE APPLY VALIDATION RULE & TEXT
EMAIL ADDRESS

2.) Create a form from the table having any five fields including name and roll number of students and
the form should have two navigation buttons, and title of the form.

3.) Prepare a report using report wizard.

4.) Form a query, if you need to find the person whose name starts with ‘R’ and also use filter by
session in the same query.

You might also like