Database: Tutorials

---

Vian Public Schools
 Online Technology Competencies

---

VPS Students
Both Windows 95/98 and Windows 3.1 platforms are mentioned. Both types of platforms are available Vian Public Schools. Assessments must be taken in Computer Tech Lab.

To use this tutorial, it is important that you understand how to use application windows, click and drag with your mouse, access menu commands like File/Open and Edit/Paste, and know how to save files to diskette. Please review tutorials 1 and 2 if necessary.

TUTORIAL 5.1 - 5.2 - 5.3 Database Features

Electronic Database Advantages
Extensive table organization and formatting
Easy to import and export information
Easy to edit entries, lists, tables, and forms
Fast calculations and sorting features
Print extensive reports quickly
Store, organize, and sort thousands of records in a small file.

Each database record contains a student name, the school they attend, the school location, the school type, school tuition.

1. Open the table student name and enter the appropriate information in each field to add a record to the database
2. Move to the third field in the database and delete it
3. Search the database for the word "southern"
4. Search the database for the word "southern" and the word "vocational"
5. Sort the entire database by school tuition
6. Use the top three students' scores to place into a new database. Select these three records and create a new database.
7. Paste these three entries into the new datbase.
8. Use the font formatting options in Microsoft Access to change all student total scores to bold.
9. Add a final record to the database that summarizes each students scores and calculates the average
10. Use print preview to adjust printing as necessary and print the database record you have created.

TUTORIAL 5.4Customized Databases

In this tutorial, you will design a customized columnar report of the database above, change its characteristics and print it. Use the file tut5-3.mdb in the following exercise.

1. Go to the menu command Create/Report
2. Choose the options layout and template from the menu.
3. Find the total number of schools in each state.
4. Print an indidvidual record form the database.
5. Print a customized database report.

TUTORIAL 5.5Insert database fields into word processing document

In this tutorial, you will design a customized columnar report of the database above, change its characteristics and print it. Use the file tut5-3.mdb in the following exercise.

1. Go to the menu command Create/Report
2. Choose the options layout and template from the menu.
3. Find the total number of schools in each state.
4. Print an indidvidual record form the database.
5. Print a customized database report.

TUTORIAL 5.6 Database Definitions

Database- Describes a program that stores infomation so that it can be collated, compared, and retrived.

Field- A subsection of a database record

Filter- To sort data by priorities usually listing only partial records.

Record- A group of fields that contain data to describe a record in a database

Layout- The general design of a databases organization

Sort/arrange- To list data in a predetermined format

Search- To make a query in which the user searches for certain keywords

Select- To highlight information in the database. This data can be immediately cut or copie or deleted. Click again to deselect.

Mail merge- A method of using a database with a word processing form to make multiple copies of personalized letters. Names and addresses from the database are printed one by one in fields embedded in the word processing document.