Tip:
Highlight text to annotate it
X
in video tutorial 2
we created a table
with the cable wizard but we didn't place any data in it.
in this tutorial
we want to fill that table with the data from our calc file
but this time, instead of typing in all the data by hand
we're going to look at how copy and paste our data
into the data base table
the first thing i want to do, is make a copy of the database we used last time
so i'm going to right click
select copy
and paste
now i'm going to rename this
to make this odb03
and take off copy
let's open up that calc file again
and on our database, we created an ID column here for all of our employees
so I'm going to insert one here
we'll call this ID
but we don't need to put anything in it because
that column will be auto populated. we'll also make a quick note
that each row going across, is for one employee
and the columns going up and down
are the fields
so i'm going to come down to the bottom corner
select all my data going up the top
right click and copy
now i'm going to open up, our odb03
and i'm not going to open up the employees table that we create i'm going
to right click on it
and select paste
we see here
the name is employees table
let's click next
we don't want a copy over our source i d
but we want everything else
to be copied over
and will finish this by clicking create
it doesn't look like anything happened
but when i open up my employees table by double clicking it
we see all our data
is inside this table
one thing odd about this table is, it all looks bold
looking better spreadsheet
weekend some bold in our title here
and when i copied that over
it made everything bold in our table
we have thirty records
zero thru twenty nine
let's add another record
I'm going to go back to the calc file
and i'm going to select single roll
this one here
donna lee.... copy
i'm going to close the table again
I'm going to right click on it.... paste
we see the same as before, we want to append the data
use the first line as column names this time we don't have column names
so i'm going to uncheck that
clicking on next
we're going to uncheck this column and let this one auto-fill
and click create
double-clicking to open
and now we see
we have thirty-one records
we added in donna lee
and
none of it is bold anymore
coming back
to our calc file
this time i'm going to select a row
in make it bold
and now i want to select that bold row
and 2 more (rows).... copy
and were adding white, brown,
and lee again
so i'm going to paste
again
i don't have first-line column names
clicking next
taking off our column
and create
double clicking
and we see our data is bold once again
so this is showing that if we had anything bold that we are copying in it
makes our entire table bold
we know him thirty-four records
now i just want to remove the bold i don't want to add in anymore records
this time i'm going to select another one i'm going to select
patricia anderson
copy
we can close our table
i'm going to paste into this
and this time i'm going to say use the first column
as column names
i'd only have one, so it shouldn't add anything in. i'll click next
and here again we see that
this is data we want to enter, but we are telling it, that they are column names
so we shouldn't add in any records
but we should be able to remove the bold from our table
Let's create it
double clicking...
shows we did not at another record, we still have only thirty four
and we've removed the bold
from our table
i want to make a copy of our employees table, so i'm going to right click - copy
and right click - paste
and instead of calling this employees2 ,which it what it is suggesting,
i'm going to call this
start date at bottom
clicking next
going to move everything over
but i'm going to take out the start date moving up back
now hitting that right arrow, to include again.
but places that at the bottom
let's click next
it's asking us if we want to change any of this information, i'm going to leave it
as it is and click create
opening this table shows us that
we had the same table but this time our start date
is on the far right
now i'm going to delete all this data out of here
selecting it all, right clicking, delete rows
we still have a couple more
so now we've got the empty table
once again
i have a our spreadsheet filled with dava that i want a copy over
this time so it doesn't turn bold i'm going to select at all
Bold everything, now remove my bold
now select just the data that i want to bring over
copy
and remember here our start date is between gender in end date
so i'm going to paste it into our start date at the bottom
i'm going to append the data
clicking next
I want to remove our ID
and i'll point out right now, that these two buttons are for our checkbox, all or
none
and i want to remove the id again
and i want to move
start date
down to the bottom
so that's what these arrows do, they will move up-and-down
whichever feild I they have selected
and i wanna move start date down to the bottom
so it moves it from my source data
to the bottom row on our table
let's click create
opening up that table
shows us that our start date
is on far-right, just where we want it
looking at our employees id
it starts
thirty-four
because
when we copied the table
it used up all our
autovalues through record thirty three
if i really want to start this at zero again
i'm going to hit selected
come down to the bottom
delete these
now to reset my numbering two zero I had to clear out the table
now i'm going to edit that table
select the employee-ID
and change autovalue to No
save the table
yes i want to save those changes
now i want to edit it
again
selecting employee-ID
and turning auto-value back on (to yes)... Save
now when i grab the data from our spreadsheet again
copy
Paste and we are pasting into employees start date at the bottom
i need to uncheck id
select our start date moved it back down to the bottom
and create
double clicking the open
shows that our employees starts at
employee number zero
in our start date is on the far right
just as we want