Saltar navegación

Activa JavaScript para disfrutar de los vídeos de la Mediateca.

DATEBASE - Contenido educativo

Ajuste de pantalla

El ajuste de pantalla se aprecia al ver el vídeo en pantalla completa. Elige la presentación que más te guste:

Subido el 26 de noviembre de 2020 por Isabel L.

105 visualizaciones

Más información Transcripción

Descargar la transcripción

Well, this time we are going to study database. 00:00:00
Database is maybe the oldest application of computers. 00:00:07
In the past we have a lot of data that we want to process. 00:00:15
So, a database is a set of organized and related data on a given topic. 00:00:23
You have a lot of examples of database, for example, an agenda, for example, the register 00:00:31
that you have in a library, or the register in a school, there are a lot of examples and 00:00:38
people usually use database very spritly in so many application. You have 00:00:44
different possibilities, different programs, different apps that let you to 00:00:55
use database but maybe the famous, the most famous one is Access. What happen is 00:01:00
the access belongs to Microsoft so you must pay for the license. Taking into 00:01:09
consideration is the first time that you use this thing I think is 00:01:16
enough and instead of use access we are going to use a LibreOfficeBase so 00:01:25
So to use LibreOffice Base, you must look for it in LibreOffice, click, and then you 00:01:35
have this. 00:01:47
So you must select a new database. 00:01:49
You can open another database, but in any case if you do this, you must take into consideration 00:01:53
the virtual Java machine. 00:02:01
So sometimes can be very, a little bit fussy. 00:02:04
So my advice is that you must create a new database, give this database a name, what 00:02:08
you have, and then this is the aspect of the LibreOffice base. 00:02:20
On the left you have four objects, which are tables, queries, forms and reports. 00:02:36
What are tables? 00:02:47
Tables are used to store information. 00:02:49
A table consists of a set of rows and columns. 00:02:52
The columns are usually named as fields, and the rows are usually named as records. 00:02:59
In each table usually you have a field which is more important than the rest, and this 00:03:09
field is usually so called field key. 00:03:14
Then you have queries. 00:03:19
What are queries? 00:03:21
can be queries of selection if you 00:03:22
display records that meet a set of criteria 00:03:26
update if you want to update 00:03:30
a group of records, delete if you 00:03:34
want to delete a group of records in a table, or 00:03:38
create a new table. Then you have 00:03:42
forms, forms displays formats 00:03:46
used for entering information in tables with more options and more attractive design and reports 00:03:50
than used to present the data in a table or query, usually for printing. Apart from this you also 00:03:59
have relations between tables but we are going to talk about relations later. So you can click in 00:04:07
field, open, and open the database that we have downloaded from our virtual classroom. 00:04:18
So in this case, as you can see, we have three tables. 00:04:43
So for example, if I edit one of these, I can see the design of the tables. 00:05:00
What do we have in design? 00:05:16
We have files, name of files, and also the type of data that you have in each field. 00:05:18
For example, here you have different types of data, as you, it's the same as you have 00:05:26
in the workbook. 00:05:34
Test, number that can be general number with different length, decimal, integer, small 00:05:35
integer, float, real, double, test with different types of taxes, or time, date, date time, 00:05:43
others or just one is different which is Boolean. Boolean is when something is 00:05:55
yes or no. So in this particular case these are the types of you have, the 00:06:02
types of difference fields that you have in this table or for example in 00:06:10
this other one you have this or in products this is the aspect of the 00:06:20
design. So now if you open this you have some register, you have some records filling the table. 00:06:36
So these are the columns that we have already defined and here you have the value in each 00:06:54
record, so you have so many records you have different values. You can move from 00:07:07
one to another in this way. For example if I select one column I can 00:07:14
organize or order the table in this way, or in another way, in an alphabetic way, 00:07:27
or taking into consideration the post mode, or taking into consideration the 00:07:38
customer codes, for example. So we can do this type of operation 00:07:45
that are easy. You also do the filters for example if I want to well if you 00:07:55
want to create the auto filter it's very easy but it's not in it interesting you 00:08:03
select this one and create a filter for example for for Madrid you have more 00:08:09
than one. So if you select Madrid, you have the register in which Madrid appears. You can also 00:08:20
create your own filter. How? Adding criteria, for example, I want that in company, for example, 00:08:30
There is any companies that repeat, so it's not a good idea. 00:08:44
I think the only is town and city. 00:08:50
The condition for the filter can be Madrid or can be, for example, Valencia. 00:08:54
We are going to create, for example, I say Valencia. 00:09:31
So this is the result. 00:09:47
So you can do something with the table, just only with tables. 00:09:49
important. You can also create a new table. For example, we are going to create 00:09:55
a table in DesignVue. So what must I do? Firstly, give a name to the 00:10:02
field. For example, we are going to create a table with the students 00:10:12
of this class or the students of TICO. 00:10:20
What I have to do? 00:10:25
Firstly, the first field must be a code that I give to the students. 00:10:27
So for example, student code. 00:10:34
Student code, what type of data is student code? 00:10:44
Obviously, it's a number. 00:10:48
Then for example, name is a test. 00:10:53
Then surname, it can be first surname, second surname, then course, then group, then for 00:10:59
example age. 00:11:14
So we have, this is a text, this is also a text, course must be a number obviously, and 00:11:18
age must be a number also, yes? 00:11:31
So now, the most important field is going to be the student code. 00:11:37
So I must say that this is the primary field. 00:11:46
And finally, I have to save it. 00:11:54
So here we have our new table. 00:12:08
What happened? 00:12:12
haven't entered any date so it is empty. You must now enter the names 00:12:13
For example, 2 is 3, must be 4b, I have 50 years, another can be, what, I don't know, 00:12:26
And half, three, again. 00:14:29
With six is enough, you don't need so much, can be enough with this. 00:14:56
So you have create a new table, you have create, so if you now open this new table you have 00:15:45
this, your latest, well that is more or less the first section, the first of this, the 00:15:55
first one. 00:16:06
Valoración:
  • 1
  • 2
  • 3
  • 4
  • 5
Eres el primero. Inicia sesión para valorar el vídeo.
Idioma/s:
en
Autor/es:
Isabel Lafuente Reboredo
Subido por:
Isabel L.
Licencia:
Reconocimiento - No comercial
Visualizaciones:
105
Fecha:
26 de noviembre de 2020 - 18:46
Visibilidad:
Público
Centro:
CP INF-PRI-SEC EL CANTIZAL
Duración:
16′ 15″
Relación de aspecto:
16:10 El estándar usado por los portátiles de 15,4" y algunos otros, es ancho como el 16:9.
Resolución:
1440x900 píxeles
Tamaño:
33.96 MBytes

Del mismo autor…

Ver más del mismo autor

EducaMadrid, Plataforma Educativa de la Comunidad de Madrid

Plataforma Educativa EducaMadrid