Database Applications/Introduction

From Wikiversity
Jump to navigation Jump to search

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

Objectives and Skills[edit | edit source]

Objectives and skills for this lesson include:

Readings[edit | edit source]

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

Multimedia[edit | edit source]

  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[edit | edit source]

  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[edit | edit source]

  • 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. [1]
  • Microsoft Access is a database management system installed on personal computers.
  • Access databases include four objects: tables, queries, forms, and reports.

Key Terms[edit | edit source]

Access Datasheet View
A view of a table that is much like a spreadsheet. It allows you to enter in your information quickly.[2]
Access Design View
A view that allows you to manipulate how data will be created, stored, and displayed on the screen and in reports.[2]
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. [3]

See Also[edit | edit source]

References[edit | edit source]