[go: up one dir, main page]
Scribd
Upload
39 views2 pages

Create The Following Database: - : Excel Assignment 1

The document provides instructions for creating an Excel database with two tables and restricting certain cells. The first table is for a course database and cells should be restricted for serial number, course, course content, days of completion, and fees. The second table is a contact database and cells should be restricted for name, contact number, and password.

Uploaded by

Megha gupta
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
39 views2 pages

Create The Following Database: - : Excel Assignment 1

The document provides instructions for creating an Excel database with two tables and restricting certain cells. The first table is for a course database and cells should be restricted for serial number, course, course content, days of completion, and fees. The second table is a contact database and cells should be restricted for name, contact number, and password.

Uploaded by

Megha gupta
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
You are on page 1/ 2

EXCEL ASSIGNMENT 1

Data validation

1. Create the following database: -

Restrict the following cells: -


i. Duplicate value should not allow in serial number column.
ii. Course should be selected from drop down list
iii. More than 80 characters should not allow in course content column.
iv. Value in days of completion column should less than equal to 250.
v. Value in fees column should less than equal to 40000

Imparting knowledge since 1997……..


2. Create the following database: -

CONTACT
NAME NO PASSWORD
AMAN 4569969 PIL32145
DIVYANSHU 6547899 PIL45621
CHANDER 4820655 PIL78934
RATAN 6012358 PIL41258
SUBASH 6547897 PIL52035

Restrict the following cells: -


i. Name should appear in capital letters only
ii. Only number should allow in contact number column.
iii. Password should begin with PIL and must contain 8 characters only.

Imparting knowledge since 1997……..

You might also like