Database Applications/Introduction
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]- Wikipedia: Database application
- Wikipedia: Microsoft Access
- Wikipedia: LibreOffice Base
- Harper College: Relational Databases and Microsoft Access - Chapter 1
- LibreOffice: Getting Started with Base
Multimedia
[edit | edit source]- GCF Global: Access 2016 Introduction to Databases
- GCF Global: Access 2016 Introduction to Objects
- GCF Global: Access 2016 Getting Started
- GCF Global: Access 2016 Managing Databases and Objects
- YouTube: Getting Started with LibreOffice Base
Activities
[edit | edit source]- Complete the tutorial GCF Global: Access 2016 Working with Tables.
- 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]