DEGREE
COLLEGE,
BHpUNBESAWNAR
NI
Har
DEPARTMENT OF COMMERCE
FUNDAMENTAL OF DATA MANAGEMENT
(CORE- 9)
NAME :- ABHISHEK SUBUDHI
UNIVERSITY ROLL NO:-2103010190080002
COLLEGE ROLL NO:- BC-21-100
SIGNATURE JRO INTERNAL EXAMINER
DATE:
SIGNAIURE OF EXTERNAL EXAMINER
DATE:
TABLES
INTRO DUCTTON
Atable is a stövctuse of veotical Columns and
|hosizontal sows Guith a coll at every întexsection. Ta ble allouw
lasge amords of text os mumbess to be poeseryted in an
O3gcnized amd easy to ead Monmeö: Each Ce ll Com Contan
tet o 9 7aph+cs and you Con foma! the table in any ay you
Cuont.
Some impoo tad tesms about tabe:
Rou- AT0u sUns hosizondat in a table ond is divided by
boódess
Column- Acolumm ns perpendicolary in a toble and îs divided
by bosdess.
Bos dess-SeposaFng Unesin the table.
Cell- A cell is the box thad is Coeatcd ohen yous
0us and
Yous co lumns întexsed each othes The Cel! con tains
data oo infomaan.
"LNSERT A TABLE
Thexr ane 3 Methods to insent a table in wosd doume Td
Method-1 (Table buttor)
’ Cia the nserol tob of the Ribbon .
Tn the table grsoup, ciq the
the table
table îcon-
ic Wosd
doopd oun ist. disploys a
’hag the intende d ta ble comns and sows- fam the
table goid
’ Fos exOmple ,3X3 Colum) Rows) Table.the to ble cuilt autog aticaly
nset into the docume nd.
Method-2 (Tnsest table)
’ Cicx the însert tab of the Ribbom
Tnthe table q70up , clicg the Table icon.
Fsom the dop- docm st disploy e d.CliK the insest toble Comvord
Insert table dioleg box appear
From ths d'alog box selec the 0us and Columm of tobl-e.
Method-3
In
CDrauing celus)
inset toble dialog box cick Drsaw Table . Wosd Chongs fo
prit Lay out vi ecu amd Choner the Tno 0J e pointer So it looks a
ske penct.
’ Use the pencl to doaw Coumns and us in to the table as Yoy
’pess ESc when you arse done.
.Row and columns
To Add a coleumn:
’ place the însestion point im a colum) adsacet to the locaian
you Cuish the mew Colmn to appea.
Right cice the mouse. A menu oppeaas.
>select Insest’ Tnset Colums to the teft os Tnset Columnsto
the Rights. Aneu column appears
to Add a Row:
’ place the imsestion pont in a tow below the locafon
You aish to add a soo.
> Rig ht cGa the moure. Amenu appeorsr -
’seled InseytTnseot Rows Above .
’ AnewSow appea3s above the însestion point
TO delete a Ro oy colUmn:
Select the d0w Þs Column.
RightCick yoUr mouse a menu appeaus.
B selet Delete cells.
Delete Cell datog box appeaas -Seled Dlehe entioe dow OY Delete
endie Colmns then cicK ok
$25,560 |S13,745
S13,470 $27,800 Cut
Cut
S17,555 S8,907 Copy
S6,789
Copy
|S10,239 Paste Options:
F Paste Options:
Insert Columns to the Left Insert
Insert Columns to the Right Insert
Delete Cells...
Insert Ros Above Seleçt Delete Cells...
Insert Rows Below Split Cells... selret
Insert Cells... Borders and Shading..
Split Cells...
(Table: Insert Columns to the Left or Right) (Table: Delete Row or Column)
$25,560 $13,745
Delete Cells
$13,470 $27,800 Cut
$17,555 $8,907 Copy
Shift cells left
$6,789 $10,239 Paste
O
Shift cells up
Insert Columns to the Left Insert O Delete entire row
Insert Columns to the Right Delete Cells.. Delete entire column
Insert Rows Above a Split Cells...
OK Cancel
Irnsert Roes Below Borders and Shading...
E Insert Cetts... lA Text Direction..
kter in January 2008. Al new clients are lo Cell Alignment Fig. 1.48 (Table: Delete Cells Dialog box)
h. New categories of business clients wes AutoFit
usiness. Table Properties...
Fig. 1.45 (Table: Insert Rows above an existing row)
TABLE STYLE
To apply table style;
cicx anyt-heor onthe tabe.the design tab wl appeas on the
Ribbon
Seled the Desgn tab and locate the table styles
CleK the Moe- dop-dpwn anoour -to see all ot the table syles
place the Mouse dzop-doun aow to see all of the table styles.
Setect the desiaed sty lethe toble style cail appear in the documerd
yout Reterences Mailtngs Review View Design Layout
a Shading
H Borders - h pt
Pen Color
Table Styles Draw Borde
3 More
Choose a visual style for the table.
(Table: Table Styles)
TO RestZE ATABLE
Boing mouse pointes overo the table cwhich you Cuont to
6esiz As Soon as a Small CO0SS TCon cojl
Left CoOnes and a Small Resize TCOn Coill Opeat at the top
appeas at the
bottomsgh Cosmes ot the table as shoun Belou.
Cross lcon
Row
Row2
Row3
Row4
Resize lcor
(Table: Resize a Table)
Bring the mouse pointe oveo the Resize i Con iu it
a diögona double- Sided T000- Noc poess changer to
the Lett moUse bUtto on
keep hotding the buthon cuhile eSzing the ta ble.
Drag the tabte up to make t Shos tes 08 docm to make it longe
Can dog the toble diagonaly to
width and the heig ht ot the table. Simultaneasty Chogc bofh the
lo MERGE Ces OFATABLE
Mesqe cell means mesging of too or mt cellr to Corate
One Lasge Cell.You Con mesgo celUls ethe you-tise os column-cise.
Bing mouse pointes posilian nside the fisst Cel thad Xou tuon to
mergr.
DNOW poe s the shft key ond cicx thc cels asound the cell hch yoy
Lan to mesge imto thefi st cel <this cil highig fre cets tuhich You
cick and they ouill be e0dy to be mesged.
> CUCK fhe layout tab and then CcK Me9e Celes button chich cui lt
mesge au the Selected cells.
P Attes mesgi'ng tte cellç oll the tomtend ot the Cells tojll be.
Scvambled cuhich you Com fx Jatesas you like.
MetgedCells Merge Cels Button Layout talb
06cuetlMicreoft ord
Hene inseit Psgelrout Betenceslings i e Vew Add is Oeslgn Lavout
Seleet
iewGotees Left 1503 em
Delete Insert
Propeties Abore nudt Right Spit Table
AtoFt
Ahgnment Data
Tatte Rhes Cotuens
Metar Cell Sir
Coimr
Coom4
Image Photo Picture Movie
Song Dance
TV
Music Serial
Cinema Theatre Actor
.,SPITTA TASLES CELLS
> Boing mouse polt position ory cuhese inthe socu that
appeas as the fist o0 w of the necs
shoutd
table.
5 NOO Cce the lay out- fab and then
ohch alL Spt tabhe button tohieh totl cUCK the Sptt table buton
tableg and the sel-eced s0w Coill be comeSptt the tabte înto tw o
fhe ti st sow the
lowes table. Lower EuTe UppataTE
Decumentl - Microsot Ward
Home sert Pafe iyout Reteences
Aca-s
Calib (8odyl
Falte
1 Qu Chige Cating
Stytes Styst
Opoaard Foct afagtpt shyes
Column1 Columns2 Coiumn3 |Coluyn4
Photo Picture
image Niovie
Song
Dance Musk Serat
TV
Cinema Theatre |Acta
Split Cells Dialog Box Split Celts utfon Layout tab
Dcensen Mresof wrd
alew Gre Algtent Data
berte
Set Table
peties
alelelal
Selt Cels
Column
Column1
hnber of cphmna2 Move
hber of o s 2 Serial
Song Actar
TV Mrge c befre
Caecal
’ Boing Nouse pointes posiion înstdethe EelL that has to be
divided înto mul4ple celð.
Now Ci the Layout tab sthen cl'q SptH Celtr button ; tKS caill
display a dolog box asking fos the nvmbes ot 30s Qnd ¬olunns
to be CoeQted tsonm the seleche d cell .
> Select the desioc d mumbe of sous and cotumn that have to
90 indo the esotart cel and finally CK the ok button to
apply the esult.
To ADD BoRDERS
Selet the Cells You ward to add a bosdeTto. Selee a table
CCk oves the table any cheot chich coill make (toss iCan
visi ble at the top Le Cosnes of the table. cicK ths Csoss
iCon to Select the table.
CUcthe Bosdes button to display a ist of options fo put a
bosdes asound the Selectd table.
tsy to odd amd se move diffeent bosdess bike Lett sight .
top os boBt om by selecking diextnt options fsn the basdes
opions
’ you com apply bosdet to any of fhe seleched sou Column.
Dto Delete the eisting bos de ,Simply Selee the NO Bos dex
optian fsom the bosdex opfns
Lab
Home Border Options Bordec Button
bocumen-Mcee Werd
Reterentes Viee Deign
sert
Ple
Quck Change Iang
Sejtes
Chphesre Bottom Border
Tog Bordet
jeft Border
1 Bont Border SFeb salary Totat
Employe
Henesy tHo Border 22000
Johe BB ABorders 20000
Arul 16000
Outdr Borders
nsde Borders
nssde Horizontal Border
L Inude yerticalBorder
Dagonal Oown Border
Diagonal Vp Border
Pege 1 LWars 160 Hongontai ine
Draw Table
Ual view Gidines
Bgrders and Shading
Print TV Web
S10,252 S25,560 S13,745
S5,550 S13,470 $27,800
S8,547 S17,555 S8,907
S13,578 S6,789 $10,239
(Table with added Border)
TO DeLETE ATABLE
’ CUcK anyuhe e inthe table You Cwant to delete.
’ CUcK the layout tab,Then Click the delete ta ble option
oders the pelete Table, Buton tò delete the Conple te
table fom the documet along auth its Content.
’ We Can Delete the sows Cell,
Columns also by Choosing
the opFon.
