Chapter3

From WikiEducator
Jump to: navigation, search
Road Works.svg Work in progress, expect frequent changes. Help and feedback is welcome. See discussion page. Road Works.svg
Home.png
Computer Education Grade2h.png Grade Two
100
1.What is a Database
2. Tables & Sorting Records
3. Sort by Age
4. Fields and Records
5. Get Information from the Database


What is a Database

Database stores data. A database organizes data so you can find information. What Is a Database? A database is a collection of data. A database for you might be a list of all your friends. That database is a large one. It stores their names, addresses, phone numbers, parent information, and grades. To create a database on the computer, you use database software. Database Definitions A field stores one piece of data.

Tables & Sorting Records

A database stores information. A database can sort information. Make a database in a word document:

  1. Open a word document. Starting the Word Processor in Chapter Two.
  2. Click Insert in the Table menu.
  3. Give it two columns and four rows.
  4. Type Name at the top of the first column.
  5. Type Age at the top of the second column.
  6. Drag across the two headings and click the Bold icon.

Sort by Age

  1. Drag across the age column.
  2. Click Table and click Sort.
  3. Click Numeric under the Key type.
  4. Click Ok.

Fields and Records

A field stores one piece of data. Each record is a group of fields that have something in common. Databasedef.png Each record is a group of fields that have something in common. All of the records are in one table. The table is stored in a database file.

Get Information from the Database

  1. Where does Peter live?
  2. What is James's surname?
  3. What is Peter's phone number?