Course of Ofimática OpenOffice Basic - Database - Basic Level
Precio 60 € - Cursos de especialización, OnLine de 60 horas - Titulación Emitida por el centro
Beyond all doubt, the applications of databases have turned into a powerful tool for gestionar and organise the data related with a determinate subject, of an effective way. It Would remain incomplete the study and handle of the application OpenOffice, without devoting a course to the tool of Database that contains.
OpenOffice Database has expanded strongly his functionality, offering to the professional and particular user an effective and simple tool in his handle, to design databases, structured in tables.
Also, offers big possibilities regarding the design of queries of simple selection, forms of introduction of data and reports. Even, it offers the tool to work with the application like agent of relational databases, allowing establish and define relations between tables.
Besides, through the extensions of OpenOffice will be able to increase the functionalities of the application, adding new characteristics to the program.
Therefore, along the development of the course the student will learn basic concepts and foundations of the handle of programs of databases that will help him to the hour to organise and gestionar properly the information on a determinate subject
The student will learn to:
Know the process of obtaining and installation of OpenOffice.
Learn the fundamental concepts of the databases.
Learn to differentiate the distinct elements of the interface of the program.
Learn the design and use of tables and to establish basic relations between the same
Create simple forms
Realise basic queries to the Database
Generate reports and modify his design
The process of learning base in the reading comprensiva of the different didactic units that comprise the course, visualisation in video of an explanation detailed of the treated in the unit, realisation of a practice in real time on an on-line simulation of the own program in the system and systematic realisation of the test of autoevaluación, besides the course is focused in an essentially practical sense with innumerable examples for each separated in which poses the most suitable form to explode the different options of the program, along the course. To surpass the course, the student will have to realise several practical cases posed by the tutors and surpass a final examination in the platform of and-learning.
There is not.
Headed to companies and particular that want to implant technologies Open Source for his usual tasks of management of databases of clients, providers, prodcutos, etc...
1. INTRODUCTION To THE DATABASES
1.1. Basic concepts
1.2. Objects of a relational database
1.3. Analysis and design of a database
1.3.1 analyses and design of the tables
1.3.2 relations between tables
2.1. Open the application OpenOffice Base
2.2. Main screen of OpenOffice Basic
2.3. Create a table from the sight of design
2.4. Create a table using the assistant
2.5. Modify the design of a table
3. SCREEN OF SIGHT OF DATA OF THE TABLE
4. RELATIONS BETWEEN TABLES
4.1. Relations between tables
4.2. How relate the tables in base
4.3. Delete the relation
5.1. Creation of a form
5.2. Creation of a form using the assistant
5.3. Sight of design of a form
6.1 Create a query from the sight of design
6.2 Consult data of more than a table
6.3 Create a query using the assistant
7.1. Creation of a report
7.2. Modify the design of a report
El curso Course of Ofimática OpenOffice Basic - Database - Basic Level está en nuestro Buscador de Cursos y Masters desde el 14/11/2011.