LibreOffice ~ 100% Free
A Complete Office Suite that is 100% Free!

  • Word Processing
  • Spreadsheet Editor
  • Presentation Creator
  • Drawing Program
  • 100% Compatable with Microsoft Windows®
  • 100% Free

  • Clicking this Download button starts InstallIQ™, it manages Libre Office your installation. Learn More

    LibreOffice Base Tutorial #2 – Creating Tables

    Base is the database manager app in the LibreOffice suite, this outstanding free desktop database front end brings all the features and tools to satisfy your needs regardless the kind of user you are. For those who are new to database creation and management, Base offers really helpful wizards for table, queries, reports and form creation so its usage is made as simple and easy as possible. In this tutorial I'm going to tell you how to create a table.

    LibreOffice installed and ready to run is mandatory to follow this tutorial, so those who still do not have it can click on the “Download” button above these lines, the InstallIQTM installation manager will take care of the setup process.

    Open LibreOffice's Start Center and select Database from its options.

    In the Database wizard select “Open an existing database file... in the Open dialog browse to the file, select it and click on Open. For instruction on how to create a new database check our previous tutorials.

    The Database interface will open, from the left panel select Table and from the middle panel select “Create Table in Design View”

    Table 1 will open, here you can define the field's name and type for each field you need to create.

    Let's say you want to create a database to keep track of your CD collection, so the first fiel could be Artist Name, click on the first cell and type “Artist Name”

    As you can see the Field Type was automatically filled and it is going to be Text which is suitable for this case. Now continue entering the field names you consider necessary to keep accurate track of your CD collection I made some examples:

    As you can see I included some fields with different type like date for Release Year and time for Total Length. To select the type just click on it and the options will unfold.

    You can also add a description for each field and you can also define its length. All you have to do now is to save by going to File → Save. You'll be asked to fill in the Table name being the default Table1 In this case I named it Albums.

    Click OK and you'll be asked to create a primary key, click yes as it is mandatory for later data entry.

    The ID field will be created on top of the table and you'll later use it to assign a number to your albums in order to make then unique thus avoiding any duplicates.

    Now you can close the table.

    Final Words

    In our next tutorial I'm going to show you how to fill the table with your data. Base is really easy to use and at the same time it offers really powerful tools for those who need to get the most of their databases. Download LibreOffice for free right now and start using this phenomenal piece of freeware for all you daily tasks not only at the office but also at home or everywhere!!


    Clicking this Download button starts InstallIQ™, it manages Libre Office your installation. Learn More


    LibreOffice Download Specs:
    » Version: 3.4.0 (Build:12)
    » Download Size: 168 MB
    » Tested Virus FREE
    » Software requirements: None
    » Operating System (OS): Windows XP,    Windows Vista, Windows Vista (64 bit),    Windows 7, Windows 7 (64 bit)

    » Tags: libreoffice, powerpoint, excel,    spreadsheet editor, word processor,    office suite, download free office

    Security Verified

    SSL

    Home           Video          Music          Graphic Design           Home Office           Utilities
       Español        Networking        Screensavers        Wallpapers  
    Welcome to GoFree.com.
    All of our downloads are completely free and are thoroughly reviewed to make sure they are virus free. GoFree.com uses InstallIQ™ and is security verified by Trust Guard™ to ensure that your download is completely safe.

    Uninstall Software
    - - - - - - - - - - - - - - - -
    Terms & Conditions
    - - - - - - - - - - - - - - - -
    Privacy Policy
    - - - - - - - - - - - - - - - -
    Sitemap - XML
    - - - - - - - - - - - - - - - -
    About Us
    - - - - - - - - - - - - - - - -
    Contact Us
    - - - - - - - - - - - - - - - -
    Tutorials
    GoFree.com is distributing modified installers which differ from the originals. The modified installers are compliant with the original software manufacturer's policies and terms & conditions. InstallIQ™ is an install manager that will manage the installation of your selected software. In addition to managing the installation of your selected software, InstallIQ™ will make recommendations for additional free software that you may be interested in. Additional software may include toolbars, browser add-ons, game applications, anti-virus applications, and other types of applications. You are not required to install any additional software to receive your selected software. You can completely remove the program at any time in Windows' Add/Remove Programs. All Rights Reserved 2010 www.GoFree.com

    Get downloads that are free, reviewed and tested by our editors and virus free! Your downloads on GoFree.com are managed by InstallIQ using Trust Guard which verifies the security of all your downloads.

    Yahoo! Toolbar allows you to search the web from any site. You can even use it to block annoying pop-up ads and autofill web forms with a single click.