Loading

Module 1: Productivity Programs

Notes
Study Reminders
Support
Text Version

Lesson 6 Introduction to Database Programs

Set your study reminders

We will email you at these times to remind you to study.
  • Monday

    -

    7am

    +

    Tuesday

    -

    7am

    +

    Wednesday

    -

    7am

    +

    Thursday

    -

    7am

    +

    Friday

    -

    7am

    +

    Saturday

    -

    7am

    +

    Sunday

    -

    7am

    +

Introduction to Database Programs
* Lesson 6 - INTRODUCTION TO DATABASE PROGRAMS LESSON
INTRODUCTION AND OBJECTIVES [1] Introduction to Database
Programs

[Introduction to Database Programs]

Lesson Introduction
-------------------------

Suppose you own a bookshop. To manage it efficiently, you need to keep a
detailed record of the books available in your shop. You also want to check
the titles and the number of copies available per title so that you can
order stock for new titles and restock old titles. You also want to track
the overall sales.

You have to store all this information in an organized form so that you
can easily retrieve it when required. One way to organize data is to use a
database, which is an organized list of data.

You can use a database program, such as Access 2007, to efficiently create
and manage a database. Database programs help you add, delete, view, and
modify the data stored in a database.

In this lesson, you will learn about the basic tasks that you can perform
by using a database program. You will learn how to create and use a
database. In addition, you will learn how to generate various types of
reports by using queries.Lesson Objectives
-------------------------

After completing this lesson, you will be able to:

*

Explain basic concepts of a database.
*

Create a database.
*

Work with records in a database.
*

Explain what database queries are and how they work.
*

Work with reports.



Links:
------
[1]
http://alison.com/mod/scorm/player.php?a=305¤torg=eXeRM_Module34823c6301d286658d32&scoid=14595