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
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
- Explain the concept of a database and its relationshiop to spreadsheets in terms of data structure, manipulation, and use cases
- Create a simple database in Libre Office Base and populate it with data relating to content that matters to you
- Extract information from a database in a useful structure which takes advantage of the power of table relationships
- Understand how to use external resources to design queries and database commands to accomplish useful tasks
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
Libre Office Base Handbook
Published by the open document foundation, this PDF handbook explores all the essential elements of the Base software package.
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.
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.
webSet up your workspace
- Download and then open a database in Libre Office Base. Name the database "collectiblesLoanerLibrary".
buildModule Mini-Project for submission and sharing
Exercise type: Building your own database
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
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.