Saltar navegación

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

Módulo Aplicaciones Ofimáticas - Trabajando con Word - Vídeo 5 - 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 6 de octubre de 2024 por Mario S.

69 visualizaciones

Trabajando con la herramienta de Combinación de correspondencia

Más información Transcripción

Descargar la transcripción

Well, another thing we have seen in class is the correspondence combination, 00:00:00
okay? So to do that we came to correspondence, to the correspondence tab, 00:00:05
and here we have a series of tools that we are using. Well, I'm going to delete all this. To 00:00:11
delete it, to select it all, I can go to the left margin, click three times, 00:00:18
and then it selects everything, I delete it and that's it, okay? Well, here the first thing we did 00:00:23
it will be good to start a correspondence combination and it gave me different options to make that 00:00:30
combination a correspondence combination is like making a template and that automatically 00:00:36
word will not personalize it for a set of information people or whatever 00:00:44
that we have saved in a database or as word says in a list is worth in this case 00:00:54
what I am going to do is a letter is worth then the first thing I give you is to start and I tell you the 00:01:02
type of correspondence combination that I want to do the second thing I do is select the 00:01:09
recipients and this gives me three options write a new list use an existing list or 00:01:13
choose the outlook contacts we have not seen any outlook so this third option 00:01:18
because we cannot use it to use an existing list this if we had done it 00:01:24
once we could do it but we have never done it ok then we have to 00:01:29
come yes or yes to the first option which is to write a new list then here 00:01:34
this window is going to appear in this window different fields appear this 00:01:39
structure that is showing me is important because it is how they work 00:01:45
the databases when we work with access which is the tool that 00:01:48
propósito que nos proporciona microsoft word para trabajar con bases de datos vais a ver 00:01:53
que vamos a trabajar al principio muy al principio de esta manera vale bueno aquí me muestra una 00:01:59
tabla unas columnas y las filas cada fila de ésta se llama un registro vale entonces vamos a ir 00:02:07
metiendo información y word cuando estamos haciendo la combinación de correspondencia 00:02:14
nos va a generar un documento sobre la plantilla que vamos a hacer ahora por cada registro por 00:02:21
cada línea que tenga esa tabla vale bueno lo primero que podemos hacer es bueno aquí me da 00:02:27
por defecto una serie de campos vale informaciones yo no las quiero todas entonces puedo darle a 00:02:34
personalizar columnas y entonces estas son todas las que aparecen aquí arriba yo no quiero todo 00:02:43
this I can want for example treatment because not the name if last name if 00:02:50
name of the organization because not this does not leave me 00:02:55
it is worth eliminating this also eliminate this also 00:03:03
for the city we are going to leave the province I eliminate it well to make the 00:03:08
example we are going to leave a few fields 00:03:13
vale eliminar eliminar 00:03:16
y eliminar bueno si yo quisiera meter más campos 00:03:26
vale por ejemplo podemos meter aquí otro campo agregar y le digo vale el nombre 00:03:31
del campo pues va a ser por ejemplo nota 1 00:03:38
vale agregar nota 2 agregar nota 3 vale por ejemplo imaginaros que es algo así y vamos a 00:03:43
hacer una plantilla para que luego reciba y las notas de cada evaluación vale entonces yo dejo 00:03:55
estos campos son los que quiero le voy a aceptar entonces fijaros como ahora esta tabla me la 00:04:03
muestra con los campos que le he dicho el nombre los apellidos ciudad nota 1 nota 2 nota 3 vale 00:04:07
then I start to put the data here then I say good to see for example because oscar 00:04:12
last name gome city madrid note 1 because it is a 5 14 18 for example another because sylvia is worth 00:04:19
sanz here we are going to put barcelona and we put the notes because a 5 a 5 and a 5 we put now carlos 00:04:35
vale carlos hernández madrid vale y aquí te vamos a poner un 1 un 1 a un 2 y 00:04:49
vamos a ponerle ahí también un 1 vale vamos a poner ahora a maría 00:05:05
sancho who is also from madrid ok maría has everything at 9 ok these would be my data here we would 00:05:11
put all the data all the records all the information of the people to 00:05:27
whom these notes are addressed ok imagine if it is all the students of the smr 1b because 00:05:33
here you would have to appear all the students with your notes, okay, well, I'm going to accept it, 00:05:40
then notice that the first thing he tells me is to save that list, okay, I'm going to tell him to 00:05:46
save it on the desktop, okay, then look at this is the list that I am doing that he already had, he 00:05:51
saves it with this key, this is the symbol of access, it is worth that we have not used it so far, but 00:05:59
if you want if you open it here if you double click I was going to open it instead of with the word I was going to 00:06:05
open it with access ok which is the way we have to work with relational bases so that 00:06:11
we can learn those concepts of relational bases and that we will see a little later ok 00:06:19
in this case I put the name because I am going to say list smr as I have that I am going to put a 2 00:06:25
vale y lo guardo vale ya tengo esos datos creados entonces yo ahora me pongo a crear mi plantilla 00:06:33
entonces empieza a poner bueno estimado señor señora dos puntos y ahora quiero que aquí ponga 00:06:40
el nombre de los diferentes alumnos vale entonces hay una opción que dice insertar campo una 00:06:51
tool to insert a combined field if you deploy you see you have all those fields here ok 00:06:57
then what I want is for you to put esteemed sir lady the name and then put me there the 00:07:04
field name I give a space and the surnames ok the name and the surnames ok resident 00:07:08
and now we are going to insert it again insert combined field and I tell you in the city this 00:07:23
no podéis escribir menor menor el nombre del campo mayor mayor hay que hacerlo vale desde insertar 00:07:28
campo vale las notas obtenidas esta evaluación han sido y entonces ahora cojo y digo eran tres 00:07:34
notes because I am going to insert a table so it is worth then I am going to put here note 1 00:07:49
note 2 note 3 ok and I am going to put a format something like that let's see what else 00:08:00
tiene esto algo así me gusta más vale esto 00:08:10
y lo quiero alinear en el centro por ejemplo nota 1 notador nota 3 bueno en 00:08:19
realidad los quiero todas las notas lo quiero todo alineado al centro 00:08:28
al centro 00:08:35
but it is worth this to the center 00:08:38
and this is the center and now what am I going to do here go 00:08:45
putting in each of the cells of the table that we will see them also this 00:08:51
week I'm going to come to where the correspondence insert field 00:08:57
combined I tell him note 1 and here I put note 2 00:09:04
and here we put note 3 and this would be our good 00:09:09
greeting 00:09:18
of lies and this would be our template ok this 00:09:21
would have a text that will appear in all the documents we are going to 00:09:31
generate and then those fields that are the ones that are going to be customized then if you look here 00:09:35
at the end there is an option that puts you to finish and combine and before we have this one that could 00:09:40
be moving through different fields, that is, through different generated documents, so 00:09:48
the first thing I'm going to tell you is to finish and combine 00:09:57
and this gives me three options it says to edit documents individually it will generate 00:10:04
documents on the computer print documents you can send them directly to the 00:10:11
printer that we have configured by default if we have any or send them by 00:10:16
e-mail that this happens to us the same as before we have not used outlook and then this 00:10:21
we cannot do it yet ok I'm going to tell you to edit the individual documents when you edit 00:10:28
the documents you get this little window and it tells you all current record only one is worth the one that 00:10:34
we have here or from 1 to 3 or ok if we don't want them all but if we want a sub-range 00:10:40
de todo el rango de registros que tenemos en este caso yo los quiero todos le voy a aceptar y 00:10:50
entonces que me crea pues esto estimado señor señora oscar gómez residente en madrid este 00:10:57
era el primer registro que teníamos las notas obtenidas esta evaluación han sido un 5 un 4 y 00:11:02
un 8 vale un saludo y es villablanca vale si sigo bajando entonces aquí ya tengo el segundo el 00:11:10
second document that has been generated from the template that we had created before 00:11:18
estimated silvia san resident in barcelona the notes obtained this evaluation has been 55 and 5 00:11:23
estimated sir carlos hernández resident in madrid the notes obtained have been 1 2 and 1 it is worth the 00:11:32
mismo que hemos puesto antes estimada señora maría 999 y ya no hay más a este este me lo ha 00:11:40
creado porque habíamos dejado un registro en blanco por eso me lo han creado vale cuando hemos 00:11:48
creado la lista he dejado una línea en blanco y por eso me ha creado esto pasa nada vale entonces 00:11:53
yo lo tendría bien cogería estos documentos los podría guardar o hacer con ellos lo que 00:11:58
we would like if you close this window where the documents are, you still have 00:12:03
not to save, you still have your template, okay, then this and so we would come to the archive to save 00:12:11
save or save as if we have never saved it and here we do not change the type, that is, here we would 00:12:18
dejaríamos como documento de word doc x vale y ya tendríamos un documento que va a ir siempre 00:12:25
contra la base de datos que hemos creado vale que es a ver dónde está aquí que es esta base 00:12:34
de datos vale y antes lo que os decía es si yo hago doble clic encima fijaros me abre 00:12:46
that those data you see the data that we have put before and it shows them to me here this is the access that 00:12:52
we will see it is worth here I could continue generating those documents I can even take this 00:13:04
row that has created us in white I select it and I tell it to delete it and so we leave it 00:13:09
todo lo dejamos todo bien vale bueno pues este es el vídeo para que podáis practicar la combinación 00:13:20
de correspondencia vale y esta semana seguimos trabajando bueno chicos pues un saludo hasta luego 00:13:31
Idioma/s subtítulos:
en
Autor/es:
Mario S.
Subido por:
Mario S.
Licencia:
Dominio público
Visualizaciones:
69
Fecha:
6 de octubre de 2024 - 19:16
Visibilidad:
Público
Centro:
IES VILLABLANCA
Duración:
00′ 07″
Relación de aspecto:
1.78:1
Resolución:
1920x1080 píxeles
Tamaño:
31.74 MBytes

Del mismo autor…

Ver más del mismo autor

EducaMadrid, Plataforma Educativa de la Comunidad de Madrid

Plataforma Educativa EducaMadrid