Bba Sem-3 - Itb - Practical Lab Record 2022
Bba Sem-3 - Itb - Practical Lab Record 2022
Bba Sem-3 - Itb - Practical Lab Record 2022
Commerce
Affiliated to Osmania University
Certificate
This is to certify that_ ,
class ______________________________________________________II
MS EXCEL
Create a worksheet named Patient to include the following
Patient No Patient In-Patient or Out-Patient Doctor attended Date
Name
1. Add 5 rows .
Create a worksheet with the days of the week at the top and time from 9.00
2. To 17.00 in intervals of 30 minutes (9.00, 9.30, 10.00,,,,,,,,,,,,,,,,,,,
17.00) use Auto fill Feature to create this worksheet
In above table find the average (or mean) salary, count of employees
8.
getting less thanAverage salary.
Create a Bar Graph and Exploded Pie Chart with 3-D visual effect using above
9. data.
Create the following worksheet that shows the number of planes arriving
in an airportin the morning (AM) arrivals and in the afternoon (PM ).
10. Day AM Arrivals PM Arrivals
Monday 80 40
Tuesday 65 45
Wednesday 50 75
Thursday 58 60
Friday 150 80
Saturday 40 68
Sunday 30 100
a) Prepare a line graph showing the daily arrivals for both AM and PM.
11.
b) Prepare two pie charts showing the relative distribution of arrivals in the
morning and the afternoon.
Calculate the Present Value (PV) , Net Present Value (NPV) and Internal Rate
15.
of Return on the given data
Year Cash Flow
0 -₹ 350.00
1 ₹ 100.00
2 ₹ 200.00
3 ₹ 150.00
4 ₹ 75.00
Rate of interest (r) = 5%
17.
EMPLOYEE NAME DEPARTMENT SALARY Rs
A SALES 3000
B ACCOUNTS 4000
C MARKETING 5000
D SALES 6000
E ACCOUNTS 4000
F MARKETING 8000
Obtain Department-wise Subtotals.
18.
EMPLOYEE NAME DEPARTMENT SALARY Rs
A SALES 3000
B ACCOUNTS 4000
C MARKETING 5000
D SALES 6000
E ACCOUNTS 4000
F MARKETING 8000
Prepare Pivot Table.
24. Select a table from an existing database and create tabular and datasheet
auto forms.
Create a database Hardware mart and table spares with the following structure
26.
Items Price Per Unit Qty Total Cost
Laptops 15,000 5
Scanners 10500 4
Servers 45,600 3
Printers 8,500 2
Windows Software 2000 1
Do the following operations
a)Calculate the total cost and replace in field total cost.
b) Sort the data using quantity
c) Prepare report with title
Create a database Book Store and table Books with the following details
27. Book No Title Author No. of Available Publisher Date of
Copies Publishing
Perform the following queries
a) List the data author wise
b) List Title, Author, Publisher, No of copies
c) List all the books of a particular author
d) Create a label of 4 lines title, author, publisher, date of
publishing and no of copies available.
Create a sales man table in a data base business containing following fields
Sales Man No. Name Region Target Set Actual
(N/S/E/W)
28. a) Calculate the difference between and actual and create a new field and
enter the value.
b) Create a report of the data.
In the above perform following queries
a) List those salesman who have achieved the target
29.
b) list sales for a particular region
c) List name, region who have not achieved the target
M.S.
EXCEL
Step4: Type the desire content in the cells. Create five rows of data.
Step5: Go to home Select borders Select “All Borders” to the table.
OUTPUT:
2. Create a worksheet with the days of the week at the top and time from 9.00
To 17.00 in intervals of 30 minutes (9.00, 9.30, 10.00,,,,,,,,,,,,,,,,,,, 17.00) use Auto fill
Feature to create this worksheet
Solution:
Step1: Click on Start button Go to all programs Select Microsoft Excel.
Step2: A Microsoft Excel window appears on the screen
Step3: Select cell A1 type the Monday, select the cursor and drag it till F1 (auto fill), you
will be able to see all week days
Step4: Fill the table with desire content. Create five rows of data.
Step5: Go to home Select borders Select “All Borders” to the table.
Step6: Select the cells Marks1, Marks2, Marks3, Marks4, Marks5 and Total
Go to Home Menu Select “AutoSum” Select “SUM”
The sum of all the marks will appears in Total Cell.
Step7: Repeat the same procedure for remaining rows and Total for all the marks will appear.
Step9: Select the cell C8 and type Minimum Formula “=MIN(C2:C6)” and press Enter
Select the cell C9 and type Maximum Formula “=MAX(C2:C6)” and press Enter
Step10:
Select cell C8 and drag and drop till H8 – will get all minimum values of all the columns.
Select cell C9 and drag and drop till H9 -- will get all maximum values of all the columns.
OUTPUT:
Solution:
Step1: Click on Start button Go to all programs Select Microsoft Excel.
Step2: A Microsoft Excel window appears on the screen
Step3: Select cell A1 type the content given the question
Step4: Go to home Select borders Select “All Borders” to the table.
Step5: Select cells C2 to C6 Go to Home Menu Select “Conditional Formatting”
Mention condition “Format Cell that are LESS THAN: 50” and click on OK
Step6: Select cells D2 to D6 Go to Home Menu Select “Conditional Formatting”
Mention condition “Format Cell that are GREATER THAN: 65” and click on OK
Step7: Select cells E2 to E6 Go to Home Menu Select “Conditional Formatting”
Mention condition “Format Cell that are BETWEEN: 60 and 80” and click on OK
OUTPUT:
5. Prepare a worksheet showing employee code, employee name and designation of the
software engineers working in a company XYZ. The employee code starts with
increments by one for engineer and ends with 1007. Use series fill option and fill code.
Also insert today’s date on the top of the worksheet.
Solution:
Step1: Click on Start button Go to all programs Select Microsoft Excel.
Step2: A Microsoft Excel window appears on the screen
Step3: Select cell C1 type “=TODAY()” , will get today’s date.
Step4: Select cell A2 type “COMPANY XYZ”
Step5: Select cell A3 type “SOFTWARE ENGINEERS”
Step6:
Select cells A4 type “EMPLOYEE CODE”
Select cells B4 type “EMPLOYEE NAME”
Select cells C4 type “DESIGNATION”
Step7: Select cells A5 type “1001” and use auto fill drag and drop till 1007.
Step8: Write the desire content in the columns of the table.
Step9: Go to home Select borders Select “All Borders” to the table.
OUTPUT:
6. From the table given below, reduce the total expenditure to Rs.16000 by reducing
sales department’s expenditure by applying Goal seek.
Department Expenditure Rs.
Production 4000
Sales 6000
Marketing 3000
Finance 5000
Total Expenditure 18000
Solution:
Step1: Click on Start button Go to all programs Select Microsoft Excel.
Step2: A Microsoft Excel window appears on the screen
Step3: Select cell A1 type the content given the question respectively.
Step4: Go to home Select borders Select “All Borders” to the table.
Step5: Select the Total Expenditure cell i.e, B7.
Step6: Go to Data Menu Select “What if Analysis”Goal Seek
OUTPUT:
Solution:
Step1: Click on Start button Go to all programs Select Microsoft Excel.
Step2: A Microsoft Excel window appears on the screen
Step3: Select cell A1 type the content given the question respectively.
Step4: Select cell A2 to A6 and write your desire names.
Step5: Select cell B2 to B6 and write your desire basic salary
Step6:
Select cell HRA C2 write “=B2*50%”
Select cell TAD2 write “=B2*10%”
Select cell Deductions E2 write “=B2*4%”
Select cell Gross Pay F2 write “=(B2+C2+D2)-E2”
Select cell TAX G2 write “=F2*30%”
Select cell Net Pay H2 write “=(F2-G2)”
Step7: Select the Cells from C2 to H2 and use auto fill drag and drop till C6 – H6.
Step8: Go to home Select borders Select “All Borders” to the table.
Step9: Select cells from A1 to F1 Go to Home menu Select “Sort & Filter ” option
OUTPUT:
8. In above table find the average (or mean) salary, count of employees getting
less than Average salary.
Solution:
Step1: Click on Start button Go to all programs Select Microsoft Excel.
Step2: A Microsoft Excel window appears on the screen
Step3: Select File menu Click on OPEN Select “7Q” file.
Excel sheet will appears on the screen.
Step 4: Select the cell G8 and write “Average Salary”
Select the cell F8 and write the average formula “=AVERAGE (H2:H7)”
Step5:
Select the cell G9 and write
“No. OF EMPLOYEES GETTING LESS THAN AVERAGE SALARY”
Select the cell F9 and write the COUNTIF formula “=COUNTIF(H2:H6,"<=34703")”
OUTPUT:
9. Create a Bar Graph and Exploded Pie Chart with 3-D visual effect using above data.
Solution:
Step1: Click on Start button Go to all programs Select Microsoft Excel.
Step2: A Microsoft Excel window appears on the screen
Step3: Select File menu Click on OPEN Select “7Q” file.
Excel sheet will appears on the screen.
BAR GRAPH
Step4: Select the NAME and NETPAY columns
Go to “Insert Menu” Bar Graph Click on it.
Bar diagram will appear on the screen
EXPLODED PIE CHART WITH 3-D VISUAL EFFECT
Step5: Select the NAME and NETPAY columns
Go to “Insert Menu” Pie Diagram 3D Exploded Pie Chart Click on it.
3D Exploded Pie Chart will appear on the screen
OUTPUT:
10. Create the following worksheet that shows the number of planes arriving in an
airport in the morning (AM) arrivals and in the afternoon (PM ).
11
A) Prepare a line graph showing the daily arrivals for both AM and PM.
B) Prepare two pie charts showing the relative distribution of arrivals in the morning
and the afternoon.
Solution:
Step1: Click on Start button Go to all programs Select Microsoft Excel.
Step2: A Microsoft Excel window appears on the screen
Step3: Select File menu Click on OPEN Select “10Q” file.
Excel sheet will appears on the screen.
LINE GRAPH
Step4: Select the table, Go to Insert menu Select Line graph click on it
PIE CHARTS
Step5: Select the table, Go to Insert menu Select Pie Chart click on it
OUTPUT:
12. Create the worksheet that shows marks secured by the students in various subjects
and find total using auto sum.
Roll No Name Marks1 Marks2 Marks3 Marks4
2001 Ramu 64 48 56 48
2002 Srikanth 78 57 75 57
2003 Ramesh 59 88 85 88
2004 Radha 86 84 49 84
2005 Kalyan 89 79 59 79
Find Mean, Median and Mode using above data.
Solution:
Step1: Click on Start button Go to all programs Select Microsoft Excel.
Step2: A Microsoft Excel window appears on the screen
Step3:
Select cell A1 type “Roll No.”
Select cell B1 type “Name”
Select cell C1 type “Marks1”
Select cell D1 type “Marks2”
Select cell E1 type “Marks3”
Select cell F1 type “Marks4”
Select cell G1 type “Total”
Select cell H1 type “MEAN”
Select cell I1 type “MEDIAN”
Select cell J1 type “MODE”
Step4: Select the cells A2 to F6 and type the given content in the table.
Step5:
Select column “Total”, cell G2 Go to Home menu select “AutoSum” option.
Drag and drop for auto fill of sum values
Step6:
Select column “MEAN” , cell H2 type “=AVERAGE(C2:G2)”
Drag and drop for auto fill of mean values
Step7:
Select column “MEDIAN” , cell I2 type “=MEDIAN(C2:F2)”
Drag and drop for auto fill of median values
Step8:
Select column “MODE” , cell J2 type “=MODE(C2:G2)”
Drag and drop for auto fill of mode values
OUTPUT:
Solution:
Step1: Click on Start button Go to all programs Select Microsoft Excel.
Step2: A Microsoft Excel window appears on the screen
OUTPUT:
14. Analyze the variance using One Way Analysis of Variance (ANOVA) method on the
observation given
S.No. Month Shop A Shop B Shop C
1 January ₹ 98,756.00 ₹ 89,586.00 ₹ 96,523.00
2 February ₹ 98,654.00 ₹ 96,524.00 ₹ 99,658.00
3 March ₹ 89,566.00 ₹ 99,650.00 ₹ 96,532.50
4 April ₹ 96,533.00 ₹ 96,531.50 ₹ 96,499.80
5 May ₹ 99,658.00 ₹ 96,490.80 ₹ 98,756.00
6 June ₹ 96,532.50 ₹ 96,477.10 ₹ 98,654.00
Solution:
Step1: Click on Start button Go to all programs Select Microsoft Excel.
Step2: A Microsoft Excel window appears on the screen
Step3:.
Select cell A1 type “S.No.”
Select cell B1 type “Month”
Select cell C1 type “Shop A”
Select cell D1 type “Shop B”
Select cell E1 type “Shop C”
Step4: Select the cells from A2 to E7 and type the content given the question respectively.
Step5: Go to home Select borders Select “All Borders” to the table.
Steps for Adding ADD-Ins for ANOVA method
Step7: a) Go to file menu Select “Excel options”
b) An Excel options wizard will appears on the screen
c) Select Add-Ins Click on OK.
OUTPUT:
15. Calculate the Present Value (PV) , Net Present Value (NPV) and Internal Rate
of Return (IRR) on the given data
Year Cash Flow
0 -₹ 350.00
1 ₹ 100.00
2 ₹ 200.00
3 ₹ 150.00
4 ₹ 75.00
Rate of interest (r) = 5%
Solution:
Step1: Click on Start button Go to all programs Select Microsoft Excel.
Step2: A Microsoft Excel window appears on the screen
Step3:.
Select cell A2 type “Year”
Select cell B2 type “Cash Flow”
Select cell C2 type “Present Value”
Select cell F1 type “Rate of interest (r)”
Select cell G1 type “5%”
Select cell A91 type “Net Present Value (NPV)”
Select cell A12 type “Internal Rate of Return (IRR)”
Step4: Select the cells from A3 to B7 and type the content given the question respectively.
Step5: Go to home Select borders Select “All Borders” to the table.
Step6: Select the Present Value Column write the formula for Present value
cell C3 =B3/(1+$G$1)^A3 and press enter
Step7: Drag and Drop the cell to get all Present values.
Step8: Net Present Value is the sum of all the Present Value
a). Select the cell C9 type “=SUM(C3:C7) ”
b). Select the cell C10 type “=C3+NPV(G1,B4:B7)” and press enter
Step8: Internal Rate of Return (IRR)
Select the cell C12 type “=IRR(B3:B7,G1)” and press enter
OUTPUT:
Solution:
Step1: Click on Start button Go to all programs Select Microsoft Excel.
Step2: A Microsoft Excel window appears on the screen
Step3:
Select cell A1 type “PRINCIPAL AMOUNT”
Select cell A2 type “RATE OF INTEREST”
Select cell A3 type “TIME PERIOD”
Select cell A4 type “AMOUNT TO BE PAID”
Step4:
Select cell B1 type “200000”
Select cell B2 type “ 5%”
Select cell B3 type “10”
Select cell B4 type “=PMT(B2/12,B3*12,B1)”
Step9:
Select cell A13 type “PRINCIPAL AMOUNT”
Select cell A14 type “RATE OF INTEREST”
Select cell A15 type “TIME PERIOD”
Select cell A16 type “AMOUNT TO BE PAID”
Step10:
Select cell B13 type “200000”
Select cell B14 type “ 8%”
Select cell B15 type “3”
Select cell B16 type “=PMT(B14/12,B15*12,B13)”
Step11 Go to home Select borders Select “All Borders” to the table.
OUTPUT:
17.
EMPLOYEE NAME DEPARTMENT SALARY Rs
A SALES 3000
B ACCOUNTS 4000
C MARKETING 5000
D SALES 6000
E ACCOUNTS 4000
F MARKETING 8000
Obtain Department-wise Subtotals.
Solution:
Step1: Click on Start button Go to all programs Select Microsoft Excel.
Step2: A Microsoft Excel window appears on the screen
Step3:
Select cell A1 type “EMPLOYEE NAME”
Select cell A2 type “A”
Select cell A3 type “B”
Select cell A4 type “C”
Select cell A5 type “D”
Select cell A6 type “E”
Select cell A7 type “F”
Step4:
Select cell B1 type “DEPARTMENT”
Select cell B2 type “SALES”
Select cell B3 type “ACCOUNTS”
Select cell B4 type “MARKETING”
Select cell B5 type “SALES”
Select cell B6 type “ACCOUNTS”
Select cell B7 type “MARKETING”
Step5:
Select cell C1 type “SALARY Rs”
Select cell C2 type “3000”
Select cell C3 type “4000”
Select cell C4 type “5000”
OUTPUT:
18.
EMPLOYEE NAME DEPARTMENT SALARY Rs
A SALES 3000
B ACCOUNTS 4000
C MARKETING 5000
D SALES 6000
E ACCOUNTS 4000
F MARKETING 8000
Prepare Pivot Table.
Solution:
Step1: Click on Start button Go to all programs Select Microsoft Excel.
Step2: A Microsoft Excel window appears on the screen
Step3:
Select cell A1 type “EMPLOYEE NAME”
Select cell A2 type “A”
Select cell A3 type “B”
Select cell A4 type “C”
Select cell A5 type “D”
Select cell A6 type “E”
Select cell A7 type “F”
Step4:
Select cell B1 type “DEPARTMENT”
Select cell B2 type “SALES”
Select cell B3 type “ACCOUNTS”
Select cell B4 type “MARKETING”
Select cell B5 type “SALES”
Select cell B6 type “ACCOUNTS”
Select cell B7 type “MARKETING”
Step5:
Select cell C1 type “SALARY Rs”
Select cell C2 type “3000”
Select cell C3 type “4000”
Select cell C4 type “5000”
Select cell C5 type “6000”
OUTPUT:
Write:
Macro Name: FORMATTING
Shortcut Key: k
Store macro in: This Workbook
Description: MY FORMATTING
Click on OK
Recording of Macro Start
Step 4:
Go to Home Menu Select borders “All Borders”
Go to Home Menu Font Select Font Color “RED”
Go to Home Menu Select Alignment Center and Middle.
Go to Home Menu Format Select Row height : 25
Step5: Go to Developer Menu Select “Stop Recording”.
Step6: Do your desire work in worksheet.
Step7: Select it and in order to apply your Macro Setting just press your macro combination
key.
All Macro Setting will appears on the screen, on a single click.
OUTPUT:
20. Create an Excel worksheet of student marks report showing current date and time
on the top.
Solution:
Step1: Click on Start button Go to all programs Select Microsoft Excel.
Step2: A Microsoft Excel window appears on the screen
Step3: Select cell D2 type now formula for current system date and time “=NOW()”.
Current System date and time will appear in the cell.
Step4:
Select cell A2 type “Roll No.”
Select cell B2 type “Name”
Select cell C2 type “Marks1”
Select cell D2 type “Marks2”
Select cell E2 type “Marks3”
Select cell F2 type “Marks4”
Select cell G2 type “Total”
Step5: Fill the table with desire content.
Step6: Go to home Select borders Select “All Borders” to the table.
Step7: Select the cells Marks1, Marks2, Marks3, Marks4, and Total
Go to Home Menu Select “AutoSum” Select “SUM”
The sum of all the marks will appears in Total Cell.
Step8: Repeat the same procedure for remaining rows and Total for all the marks will appear.
OUTPUT:
M.S.
ACCESS
21. Create a database College and table student with following details.
Departme
Student no. Name Year of admission DOB Gender % marks
nt
i) Enter min 10 records.
screen.
Step: 3- Select Blank database in file name field write college and click on create.
Step: 4- A home screen of college database will appear having table “Table-1”.
Step: 5- Select Table 1, right click select the design view, then it will ask the name of the
table in same as dialogue box
Table Name
Student
Ok Cancel
Name Text
Department Text
DOB Calendar
Gender Text
% Marks Number
Select student no. right click, assign primary key, click on same button.
Enter 10 records
screen.
Step: 3- Select blank database in file name field write College and click on create.
Step: 4 – A home screen of College database will appear having table “Table 1”
Step: 5- Select Table 1, right click select design view, then it will ask the name of the table in
same as dialogue box.
Table Name
Student
OK Cancel
Student no Number
Name Text
Department Text
Year of Number
Gender Text
% Marks Number
23. Create a database Company and table employee with following details.
i) Enter 5 records
screen.
Step: 3- Select blank data base in file name field write Company and click on create.
Step: 4- A home screen of Company database will appear having table “Table 1”.
Step: 5- Select Table 1, right click select the design view, then it will ask the name of the
table in same as dialogue box.
Table name
Employee
Ok Cancel
Eno Number
Designation Text
Department Number
DOB Yes/No
Appraised (Yes/No)
Select Eno, right click, assign primary key, click on same button.
Enter 10 records.
Step:8- Click on create and then click on query wizard, new query tab will appear, then click
on simple query under available fields select the name field and apprised field and then click
on finish. Employee query will appear on the screen with name and appraised column.
24. Select a table from an existing database and create tabular and datasheet auto
forms.
screen.
Step: 3- Select blank data base in file name field write Company and click on create.
Step: 4- create a database company and a table Employee (As already made in sum 41)
Step: 5- click on create, and then click on form the datasheet auto form will appear on the
screen.
25. Select the employee tables arrange the data in descending order of DOB using sort.
screen.
Step: 3- Select blank data base in file name field write Company and click on create.
Step: 4- create a database company and a table Employee (As already made in sum 41)
Step: 5- Click on create, select query design add Employee table, drag and drop the contents
of the table in field and under DOB field in sort write descending and then click on run the
query will appear on the screen with the table Employee and DOB in descending order.
26. Create a database Hardware mart and table spares with the following structure.
screen.
Step: 3- Select a blank database in file name field write Hardware and click on create.
Step: 4- A home screen of Hardware database will appear having table “Table 1”
Step: 5- Select Table 1, right click select design view, then it will ask the name of the table in
same as dialogue box.
Table Name
Spares
Ok Cancel
Items Text
Quantity Number
Step: 7- Click on create, select query design and then select the table, drag and drop the
contents of the table in field (i.e., Items, price per unit, qty and total) and under quantity field
in short write ascending and then click on run. The query of spares table will appear on the
screen where the data is sort using quantity.
Step: 8- Click on create and then click on report, the report of Spares table will appear on the
screen with the title.
27. Create a database Book store and table Books with the following details.
iv) Create a label of four line title, author, publisher, date of publishing and no of copies
available.
screen.
Step: 3- Select blank database in file name field write Book store and click on create.
Step: 4- A home screen of Book store database will appear having table “Table 1”.
Step: 5- Select Table 1, right click select design view, then it will ask the name of the table in
same as dialogue box.
Table name
Books
Ok Cancel
Book no Number
Title Text
Author Text
Publisher Text
Select Book no, right click, assign primary key, click on same button.
Step: 8- Right click on Author and then select sort A to Z the data will be listed Author wise
in the screen.
Step: 9- Click on create and then click on query wizard, new query will appear on the screen,
select simple query and from available fields select the fields: Title, Author, Publisher and no
of copies and then click on finish. List of Title, Author, Publisher, No of copies will appear
on the screen.
Step: 10- Click on create, and then click on query design, select the table and then click on
add and close it. Select the contents of the table (i.e., Book no, Title, Author, No of copies,
Publisher and Date of publishing) and drag and drop to the field. Under Author field
criteria write “H. G Wells” and then click on run. The list of books of particular Author will
appear on the screen.
Step: 11- Click on create, and then select labels, label wizard will appear on the screen, select
unit of measure and label type (i.e., English and Sheet field) and then click on next. Then
select font, font weight, font size and text color and then click on next. Select the prototype
label (i.e., title, author, publisher, date of publishing and no of copies available) and then
click on finish. The label of four lines title, author, publisher, date of publishing and no of
copies available will appear on the screen
28. Create a sales man table in database business containing following fields.
i) Calculate the difference between Target set and Actual and create new field and
entre the value.
screen.
Step: 3- Select blank database in file name field write Business and click on create.
Step: 4- A home screen of Business will appear having table “Table 1”.
Step: 5- Select Table 1, right click select design view, then it will ask the name of the table in
same as dialogue box.
Table name
Sales man
Ok Cancel
Name Text
Actual Number
Difference Calculate
In calculate select the operation that is “-“between the target set and actual
Select Sales Man No, right click, assign primary key, click on same button.
Step: 8- Click on create and then click on Report. The report of the data (Table: salesman
and Database: Business) will appear on the screen.
iii) List name, region who have not achieved the target.
screen.
Step: 3- Select the blank database in file name field write Business and click on create.
Step: 5- Click on create and then click on query design, select the table that is salesman table
and then select the contents of the table (i.e., Name and difference) under field difference in
criteria write “0” and then click on run. The list of salesman who has achieved the target will
appear on the screen.
Step: 6- Click on create, and then click on query design, select the table and then select the
contents (i.e., region and actual) under region field in criteria write HYD and then click on
run. List of sales of particular region will appear on the screen.
Step: 7- Click on create, and then click on query design, select the table that is salesman table
and select the contents from the table (i.e., name, region, difference). Under difference field
in criteria write “>0” and then click on run. The list name and region of those salesmen who
has not achieved the target will appear on the screen.
screen.
Step: 3- Select the blank database in file name field write XYZ Company and click on create.
Step: 4- A home screen of XYZ Company database will appear having table “Table 1”.
Step: 5- Select Table 1, right click select the design view, then it will ask the name of the
table in same as dialogue box.
Table name
Personal
Ok ncel
Empono Number
Name Text
DOB Calendar
Address Text
City Text
State Text
Email Text
Phone Number
Select the Empono, right click, assign primary key, click on same button.
Step: 8- Click on create and then click on table, a table will appear with a default name
“Table 1”
Step: 9- Select Table 1, right click select design view, then it will ask the name of the table in
the same as dialogue box.
Table name
Business
OKCancel
Empono Number
Dept.id Number
Designation Text
Select Empono, right click, assign primary key, click on same button.
Step: 11- Select Business table, right click and select open
Step: 12- Click on create and then click on table, a table will appear with a default name
“Table 1”.
Step: 13- Select Table 1, right click select design view, then it will ask the name of the table
in the same as dialogue box.
Table name
Department
OKCancel
Dept.id Number
Name Text
Description Text
Select Dept.id, right click, assign primary key, click on same button.
Step: 15- Select the department table, right click, and select open