The relationships view in the free and open source database program called Libre Office Base and is downloadable and installable without a single license key. The open source alternative to the Microsoft Coroporation's "flagship" desktop database application called Access is widely known to be a much more sanity-supporting design tool.

Database Building: Collectible loaner library

Computer Fundamentals tutorial

Start Here: Jump to a section

This module was engineered to be worked through sequentially: from top to bottom

check_boxLearning Objectives
bookModule resources & links
webSetup your workspace

motorcycleExercise 1: Database shell and table creation
motorcycleExercise 2: Relationship planning
motorcycleExercise 3: Relationship formation
motorcycleExercise 4: Form building and data entry
motorcycleExercise 4: Reporting single tables
motorcycleExercise 5: Extracting sliced and joined data

buildMini Project: Create your own collectibles loaner library database

check_boxLearning Objectives

  1. Explain the concept of a database and its relationshiop to spreadsheets in terms of data structure, manipulation, and use cases
  2. Create a simple database in Libre Office Base and populate it with data relating to content that matters to you
  3. Extract information from a database in a useful structure which takes advantage of the power of table relationships
  4. Understand how to use external resources to design queries and database commands to accomplish useful tasks

arrow_upward back up to contents

bookExternal Resources

Extensive video tutorial series on Libre Office base

A prolific YouTube screen caster named TheFrugalComputerGuy has compiled the most comprehensive tutorial set on Libre Office Base that your instructor could find

Link image to youtube tutorial

Libre Office Base Handbook

Published by the open document foundation, this PDF handbook explores all the essential elements of the Base software package.

Link image to youtube tutorial

Libre office official documentation

While open source software communities generally pride themselves on their excellent free and open documentation, the Libre Office Base documentation is shabby at best, primarily due to a lack of screen clippings. But still have this in your back pocket.

Link image to youtube tutorial

Download LibreOffice Base to your computer for free

Libre Office Suite, including Base at no extra charge, is free for download to all major platforms.

Link image to youtube tutorial

arrow_upward back up to contents

webSet up your workspace

  1. Download and then open a database in Libre Office Base. Name the database "collectiblesLoanerLibrary".

arrow_upward back up to contents

motorcycleExercise X:

Exercise type:



A sample:

arrow_upward back up to contents

buildModule Mini-Project for submission and sharing

Exercise type: Building your own database

highlightProject Specification:

Create a database to organize data about a kind of item that you like to collect which you might loan out to somebody so they can also explore the topic you find interesting.

Create at least 4 tables, each of which stores a set of data about this little project. See the above tutorial for an example film lending library database.


Create a simple form for entering data into each of the tables. Use the forms to populate your database with some real data. Do some research if you need to! Make it a learning process for yourself.

Create two queries that provide the following in

Submission steps:

Step 1: Compress the two files that create your database

In windows explorer or your file explorer of choice, navigate to the directory containing your database. Notice that unlike a plain old word processing document, a database is composed of multiple files, in our case, two. We need to assemble them into a single directory for easy sharing, uploading, and downloading.

Select both files which start with the name of your database but have different extensions. You can select multiple files by holding down the CONTROL key (or the Apple equivalent) and clicking both files.

Step 2: Properly name your zipped files

Name (or rename) your compressed folder using the following format: "[term]_[firstName]_[specialID number]_[topic of database].zip"

So, Loretta who is a Spring 2018 student might name her zip file as follows:

Step 3: Upload

Open the shared cloud directory linked below and drag your compressed zip folder from file explorer into the Google shared cloud drive directory.

Extension ideas:

arrow_upwardback up to contents