Database Applications/Introduction

This lesson introduces database applications, including Microsoft Access and LibreOffice / OpenOffice Base.

Objectives and Skills
Objectives and skills for this lesson include:

Readings

 * 1)  Database application
 * 2)  Microsoft Access
 * 3)  LibreOffice Base
 * 4) Harper College: Relational Databases and Microsoft Access - Chapter 1
 * 5) LibreOffice: Getting Started with Base

Multimedia

 * 1) GCF Global: Access 2016 Introduction to Databases
 * 2) GCF Global: Access 2016 Introduction to Objects
 * 3) GCF Global: Access 2016 Getting Started
 * 4) GCF Global: Access 2016 Managing Databases and Objects
 * 5) YouTube: Getting Started with LibreOffice Base

Activities

 * 1) Complete the tutorial GCF Global: Access 2016 Working with Tables.
 * 2) Review McFadyen: Relational Databases and Microsoft Access Chapter 1. Complete all of the exercises in Chapter 1.

Lesson Summary

 * Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.
 * Microsoft Access is a database management system installed on personal computers.
 * Access databases include four objects: tables, queries, forms, and reports.

Key Terms

 * Access Datasheet View
 * A view of a table that is much like a spreadsheet. It allows you to enter in your information quickly.


 * Access Design View
 * A view that allows you to manipulate how data will be created, stored, and displayed on the screen and in reports.


 * Microsoft Access
 * Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.