1 00:00:00,690 --> 00:00:07,190 Well, this time we are going to study database. 2 00:00:07,190 --> 00:00:15,189 Database is maybe the oldest application of computers. 3 00:00:15,189 --> 00:00:23,190 In the past we have a lot of data that we want to process. 4 00:00:23,190 --> 00:00:31,030 So, a database is a set of organized and related data on a given topic. 5 00:00:31,030 --> 00:00:38,270 You have a lot of examples of database, for example, an agenda, for example, the register 6 00:00:38,270 --> 00:00:44,890 that you have in a library, or the register in a school, there are a lot of examples and 7 00:00:44,890 --> 00:00:55,770 people usually use database very spritly in so many application. You have 8 00:00:55,770 --> 00:01:00,829 different possibilities, different programs, different apps that let you to 9 00:01:00,829 --> 00:01:09,790 use database but maybe the famous, the most famous one is Access. What happen is 10 00:01:09,790 --> 00:01:16,450 the access belongs to Microsoft so you must pay for the license. Taking into 11 00:01:16,450 --> 00:01:25,810 consideration is the first time that you use this thing I think is 12 00:01:25,810 --> 00:01:35,950 enough and instead of use access we are going to use a LibreOfficeBase so 13 00:01:35,950 --> 00:01:47,819 So to use LibreOffice Base, you must look for it in LibreOffice, click, and then you 14 00:01:47,819 --> 00:01:49,680 have this. 15 00:01:49,680 --> 00:01:53,939 So you must select a new database. 16 00:01:53,939 --> 00:02:01,260 You can open another database, but in any case if you do this, you must take into consideration 17 00:02:01,260 --> 00:02:04,359 the virtual Java machine. 18 00:02:04,359 --> 00:02:08,280 So sometimes can be very, a little bit fussy. 19 00:02:08,280 --> 00:02:20,699 So my advice is that you must create a new database, give this database a name, what 20 00:02:20,699 --> 00:02:36,659 you have, and then this is the aspect of the LibreOffice base. 21 00:02:36,659 --> 00:02:47,280 On the left you have four objects, which are tables, queries, forms and reports. 22 00:02:47,280 --> 00:02:49,419 What are tables? 23 00:02:49,419 --> 00:02:52,360 Tables are used to store information. 24 00:02:52,360 --> 00:02:59,800 A table consists of a set of rows and columns. 25 00:02:59,800 --> 00:03:09,800 The columns are usually named as fields, and the rows are usually named as records. 26 00:03:09,800 --> 00:03:14,680 In each table usually you have a field which is more important than the rest, and this 27 00:03:14,680 --> 00:03:19,620 field is usually so called field key. 28 00:03:19,620 --> 00:03:21,080 Then you have queries. 29 00:03:21,080 --> 00:03:22,819 What are queries? 30 00:03:22,819 --> 00:03:26,819 can be queries of selection if you 31 00:03:26,819 --> 00:03:30,819 display records that meet a set of criteria 32 00:03:30,819 --> 00:03:34,819 update if you want to update 33 00:03:34,819 --> 00:03:38,819 a group of records, delete if you 34 00:03:38,819 --> 00:03:42,819 want to delete a group of records in a table, or 35 00:03:42,819 --> 00:03:46,819 create a new table. Then you have 36 00:03:46,819 --> 00:03:50,819 forms, forms displays formats 37 00:03:50,819 --> 00:03:59,539 used for entering information in tables with more options and more attractive design and reports 38 00:03:59,539 --> 00:04:07,939 than used to present the data in a table or query, usually for printing. Apart from this you also 39 00:04:07,939 --> 00:04:18,500 have relations between tables but we are going to talk about relations later. So you can click in 40 00:04:18,500 --> 00:04:43,769 field, open, and open the database that we have downloaded from our virtual classroom. 41 00:04:43,769 --> 00:05:00,069 So in this case, as you can see, we have three tables. 42 00:05:00,069 --> 00:05:16,620 So for example, if I edit one of these, I can see the design of the tables. 43 00:05:16,620 --> 00:05:18,519 What do we have in design? 44 00:05:18,519 --> 00:05:26,259 We have files, name of files, and also the type of data that you have in each field. 45 00:05:26,259 --> 00:05:34,060 For example, here you have different types of data, as you, it's the same as you have 46 00:05:34,060 --> 00:05:35,860 in the workbook. 47 00:05:35,860 --> 00:05:43,339 Test, number that can be general number with different length, decimal, integer, small 48 00:05:43,339 --> 00:05:55,519 integer, float, real, double, test with different types of taxes, or time, date, date time, 49 00:05:55,519 --> 00:06:02,300 others or just one is different which is Boolean. Boolean is when something is 50 00:06:02,300 --> 00:06:10,259 yes or no. So in this particular case these are the types of you have, the 51 00:06:10,259 --> 00:06:20,000 types of difference fields that you have in this table or for example in 52 00:06:20,000 --> 00:06:36,689 this other one you have this or in products this is the aspect of the 53 00:06:36,689 --> 00:06:54,079 design. So now if you open this you have some register, you have some records filling the table. 54 00:06:54,079 --> 00:07:07,160 So these are the columns that we have already defined and here you have the value in each 55 00:07:07,160 --> 00:07:14,120 record, so you have so many records you have different values. You can move from 56 00:07:14,120 --> 00:07:27,500 one to another in this way. For example if I select one column I can 57 00:07:27,500 --> 00:07:38,899 organize or order the table in this way, or in another way, in an alphabetic way, 58 00:07:38,899 --> 00:07:45,600 or taking into consideration the post mode, or taking into consideration the 59 00:07:45,600 --> 00:07:55,160 customer codes, for example. So we can do this type of operation 60 00:07:55,160 --> 00:08:03,920 that are easy. You also do the filters for example if I want to well if you 61 00:08:03,920 --> 00:08:09,620 want to create the auto filter it's very easy but it's not in it interesting you 62 00:08:09,620 --> 00:08:20,790 select this one and create a filter for example for for Madrid you have more 63 00:08:20,790 --> 00:08:30,629 than one. So if you select Madrid, you have the register in which Madrid appears. You can also 64 00:08:30,629 --> 00:08:44,009 create your own filter. How? Adding criteria, for example, I want that in company, for example, 65 00:08:44,009 --> 00:08:50,549 There is any companies that repeat, so it's not a good idea. 66 00:08:50,549 --> 00:08:54,210 I think the only is town and city. 67 00:08:54,210 --> 00:09:31,049 The condition for the filter can be Madrid or can be, for example, Valencia. 68 00:09:31,049 --> 00:09:47,960 We are going to create, for example, I say Valencia. 69 00:09:47,960 --> 00:09:49,960 So this is the result. 70 00:09:49,960 --> 00:09:55,240 So you can do something with the table, just only with tables. 71 00:09:55,240 --> 00:10:02,740 important. You can also create a new table. For example, we are going to create 72 00:10:02,740 --> 00:10:12,100 a table in DesignVue. So what must I do? Firstly, give a name to the 73 00:10:12,100 --> 00:10:20,620 field. For example, we are going to create a table with the students 74 00:10:20,620 --> 00:10:25,620 of this class or the students of TICO. 75 00:10:25,620 --> 00:10:27,620 What I have to do? 76 00:10:27,620 --> 00:10:34,899 Firstly, the first field must be a code that I give to the students. 77 00:10:34,899 --> 00:10:44,299 So for example, student code. 78 00:10:44,299 --> 00:10:48,779 Student code, what type of data is student code? 79 00:10:48,779 --> 00:10:53,379 Obviously, it's a number. 80 00:10:53,379 --> 00:10:59,730 Then for example, name is a test. 81 00:10:59,730 --> 00:11:14,789 Then surname, it can be first surname, second surname, then course, then group, then for 82 00:11:14,789 --> 00:11:18,360 example age. 83 00:11:18,360 --> 00:11:31,409 So we have, this is a text, this is also a text, course must be a number obviously, and 84 00:11:31,409 --> 00:11:37,580 age must be a number also, yes? 85 00:11:37,580 --> 00:11:46,120 So now, the most important field is going to be the student code. 86 00:11:46,120 --> 00:11:54,679 So I must say that this is the primary field. 87 00:11:54,679 --> 00:12:08,740 And finally, I have to save it. 88 00:12:08,740 --> 00:12:12,379 So here we have our new table. 89 00:12:12,379 --> 00:12:13,379 What happened? 90 00:12:13,379 --> 00:12:26,580 haven't entered any date so it is empty. You must now enter the names 91 00:12:26,580 --> 00:14:29,940 For example, 2 is 3, must be 4b, I have 50 years, another can be, what, I don't know, 92 00:14:29,940 --> 00:14:56,919 And half, three, again. 93 00:14:56,919 --> 00:15:45,470 With six is enough, you don't need so much, can be enough with this. 94 00:15:45,470 --> 00:15:55,700 So you have create a new table, you have create, so if you now open this new table you have 95 00:15:55,700 --> 00:16:06,750 this, your latest, well that is more or less the first section, the first of this, the 96 00:16:06,750 --> 00:16:07,750 first one.