Difference between revisions of "Documentation/OOo3 User Guides/Calc Guide/Calc as a Simple Database"

From Apache OpenOffice Wiki
Jump to: navigation, search
(New page: {{DISPLAYTITLE:Calc Macros}} {{Documentation/CG3Ch13TOC |ShowPrevNext=block |PrevPage=Documentation/OOo3_User_Guides/Calc Guide/Sorting |NextPage=Documentation/OOo3_User_Guides/Calc Guide/...)
 
 
(5 intermediate revisions by 5 users not shown)
Line 1: Line 1:
−
{{DISPLAYTITLE:Calc Macros}}
+
{{DISPLAYTITLE:Calc as a Simple Database}}
 
{{Documentation/CG3Ch13TOC
 
{{Documentation/CG3Ch13TOC
 
|ShowPrevNext=block
 
|ShowPrevNext=block
Line 5: Line 5:
 
|NextPage=Documentation/OOo3_User_Guides/Calc Guide/Associating a range to a name
 
|NextPage=Documentation/OOo3_User_Guides/Calc Guide/Associating a range to a name
 
}}__notoc__
 
}}__notoc__
−
This is Chapter '''13''' of the '''OpenOffice.org 3 Calc Guide''', produced by the [http://oooauthors.org/ OOoAuthors group].
+
This is Chapter '''13''' of the '''OpenOffice.org 3 Calc Guide''', produced by the [http://www.odfauthors.org/openoffice.org/english ODFAuthors group].
−
<!-- A PDF of this chapter is available from [http://documentation.openoffice.org/manuals/userguide3/ Documentation] at OpenOffice.org. -->
+
A PDF of this chapter is available from [[Documentation/OOo3_User_Guides/Chapters|this wiki page]].
−
 
+
  
 
== Introduction ==
 
== Introduction ==
 
A Calc document is a very capable database, providing sufficient functionality to satisfy the needs of many users. This chapter presents the capabilities of a Calc document that make it suitable as a database tool. Where applicable, the functionality is explained using both the GUI (Graphical User Interface) and macros.
 
A Calc document is a very capable database, providing sufficient functionality to satisfy the needs of many users. This chapter presents the capabilities of a Calc document that make it suitable as a database tool. Where applicable, the functionality is explained using both the GUI (Graphical User Interface) and macros.
  
−
{{Documentation/Note| Although this chapter was initially created for macro programmers, the content should be accessible to all users. If you do not use macros, then skip those portions that deal with macros. On the other hand, if you want to learn more about macros, be certain to check out my book ''OpenOffice.org Macros Explained''.}}
+
{{Note| Although this chapter was initially created for macro programmers, the content should be accessible to all users. If you do not use macros, then skip those portions that deal with macros. On the other hand, if you want to learn more about macros, be certain to check out the book [http://www.pitonyak.org/book/ ''OpenOffice.org Macros Explained''].}}
  
 
In a database, a record is a group of related data items treated as a single unit of information. Each item in the record is called a field. A table consists of records. Each record in a table has the same structure. A table can be visualized as a series of rows and columns. Each row in the table corresponds to a single record and each column corresponds to the fields. A spreadsheet in a Calc document is similar in structure to a database table. Each cell corresponds to a single field in a database record. For many people, Calc implements sufficient database functionality that no other database program or functionality is required.
 
In a database, a record is a group of related data items treated as a single unit of information. Each item in the record is called a field. A table consists of records. Each record in a table has the same structure. A table can be visualized as a series of rows and columns. Each row in the table corresponds to a single record and each column corresponds to the fields. A spreadsheet in a Calc document is similar in structure to a database table. Each cell corresponds to a single field in a database record. For many people, Calc implements sufficient database functionality that no other database program or functionality is required.
  
−
While teaching, I used a spreadsheet as a grading program. Each row represented a single student. The columns represented the grades received on homework, labs, and tests (see Table 1). The strong calculation capability provided in a spreadsheet makes this an excellent choice.
+
While teaching, a spreadsheet can be used as a grading program. Each row represented a single student. The columns represented the grades received on homework, labs, and tests (see Table 1). The strong calculation capability provided in a spreadsheet makes this an excellent choice.
  
 
''Table 1. Simple grading spreadsheet''
 
''Table 1. Simple grading spreadsheet''
Line 192: Line 191:
 
|}
 
|}
  
−
{{Documentation/Tip| Although the choice to associate a row to a record rather than a column is arbitrary, it is almost universal. In other words, you are not likely to hear someone refer to a column of data as a single database record.}}
+
{{Tip| Although the choice to associate a row to a record rather than a column is arbitrary, it is almost universal. In other words, you are not likely to hear someone refer to a column of data as a single database record.}}
  
  
 
{{CCBY}}
 
{{CCBY}}
 
[[Category: Calc Guide (Documentation)]]
 
[[Category: Calc Guide (Documentation)]]

Latest revision as of 20:46, 15 July 2018



This is Chapter 13 of the OpenOffice.org 3 Calc Guide, produced by the ODFAuthors group. A PDF of this chapter is available from this wiki page.

Introduction

A Calc document is a very capable database, providing sufficient functionality to satisfy the needs of many users. This chapter presents the capabilities of a Calc document that make it suitable as a database tool. Where applicable, the functionality is explained using both the GUI (Graphical User Interface) and macros.

Documentation note.png Although this chapter was initially created for macro programmers, the content should be accessible to all users. If you do not use macros, then skip those portions that deal with macros. On the other hand, if you want to learn more about macros, be certain to check out the book OpenOffice.org Macros Explained.

In a database, a record is a group of related data items treated as a single unit of information. Each item in the record is called a field. A table consists of records. Each record in a table has the same structure. A table can be visualized as a series of rows and columns. Each row in the table corresponds to a single record and each column corresponds to the fields. A spreadsheet in a Calc document is similar in structure to a database table. Each cell corresponds to a single field in a database record. For many people, Calc implements sufficient database functionality that no other database program or functionality is required.

While teaching, a spreadsheet can be used as a grading program. Each row represented a single student. The columns represented the grades received on homework, labs, and tests (see Table 1). The strong calculation capability provided in a spreadsheet makes this an excellent choice.

Table 1. Simple grading spreadsheet

A B C D E F G
1 Name Test 1 Test 2 Quiz 1 Quiz 2 Average Grade
2 Andy 95 93 93 92 93.25
3 Betty 87 92 65 73 79.25
4 Bob 95 93 93 92 93.25
5 Brandy 45 65 92 85 71.75
6 Frank 95 93 85 92 91.25
7 Fred 87 92 65 73 79.25
8 Ilsub 70 85 97 79 82.75
9 James 45 65 97 85 73
10 Lisa 100 97 100 93 97.5
11 Michelle 100 97 100 65 90.5
12 Ravi 87 92 86 93 89.5
13 Sal 45 65 100 92 75.5
14 Ted 100 97 100 85 95.5
15 Tom 70 85 93 65 78.25
16 Whil 70 85 93 97 86.25
Tip.png Although the choice to associate a row to a record rather than a column is arbitrary, it is almost universal. In other words, you are not likely to hear someone refer to a column of data as a single database record.


Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/OOo3_User_Guides/Calc_Guide/Calc_as_a_Simple_Database&oldid=242759"
Personal tools