Databases

Databases

1. File that integrates a collection of information of the same type

   • Oracle
   • SQL
   • FileMaker
   • Dbase
   • Access
     • Click on Microsoft Access 2010
       • Navigation Pane: It’s visualized the different objects of the database
         • Types of View
           • Datasheet View
           • Privot Table View
           • Privot Chart View
             • Print a Table
               • Print preview tab
                 • Groups: Paper size, Paper Layout, Zoom, Data and Close Preview.
                 • Size: Select many paper sizes.
                 • Margins: Type of margin (Normal, wide, narrow and customized)
                   • Import and Export a Database
                     • Import
                       • Tab: External Data and the Group: Import. The created file will have the extension name .xlsx.
                     • Export
                       • Tab: External Data and the Group: Export. The created file will have the extension name .xlsx.
                 • Vertical and Horizontal: Change the orientation
                 • Page Setup: Capture the size of the margins.
           • Design View
         • Types of Data
           • Text: They are alphanumerical data
           • Number: Numerical data used to perform arithmetic operations
           • Date/Hour: Used to show dates and hours in many ways
             • Templates: Are examples of databases to be used
           • Currency: Data that behaves as numerical data
           • Hyperlink: Used to perform links
             • Attachments: Data where it is possible to include..
       • File Menu: It shows the Backstage view.
         • Create a Database < From a Blank Database.
         • Capture data in a table.
           • Open a Database
             • New Table in an existing database
             • Working in a database
               • Presentation of a database
                 • Edition of Records.
               • Primary Key
                 • It will permit to share information contained in the records
           • Close a Database
             • A database from a table template.
         • Save a database.
           • Changing the name of a field.
       • Quick Access tool bar: Area where we can personalize the most used command buttons
       • Documents area : Visualize the objects that you are going to work.
         • Field name: Name of each one of the columns.
         • Record: Is all information related
         • Field: One of the particular data of a record.
         • Table: Structure composed by rows and columns.
       • Types of Objects
         • Table
           • Capture all the data
         • Form
           • Each one of the records that form the table will be visualized.
         • Report
           • The fields that will form part of the report will be defined.
         • Query
           • You will visualize each one of the fields that it form of the different tables
             • Sort Records
               • Tab: Home, the Group: Sort and Filter and with the buttons: Ascending, descending and clear all sorts.
               • Filters
                 • Observe a limited amount of records that fulfill with a given condition
                   • Forms
                     • A way to manipulate the information contained in a database.
               • Relations
                 • Virtual connection between the fields of the tables
                   • Creation of relations
                     • Click on the name of the field of the first table and drag it with the mouse to the name of the field of the second table
                     • It is used the same procedure of dragging the field to the corresponding table
               • Report Wizard
                 • It is based on selecting the fields of the tables through a series of steps
               • Blank Report
                 • A way to elaborate a report is using the Tab: Create, the Group: Reports and the Button: Blank Report.