TECHNONASA TECHNOLOGY PROJECT
| Microsoft Access Lesson Plans |
 |
Teacher Guide - Student Workbook -
Resource Files
 |
Do you need to
teach database skills? Use the easy to follow
database lesson plans in TechnoNASA to have students
organize space mission information using Microsoft
Access. |
What is a Database?
The TechnoNASA
technology project begins with introductory
activities about databases. Students investigate:
Afterwards, students
use the NASA website to search an "online database" to answer
questions about space missions.
Register New
Recruits: Add and Filter Records in a Database
Next, students enter
an astronaut record into a Microsoft Access database. This is a
great opportunity to learn database terminology such as record,
field, table, and form.

Students then learn how to filter
records to answer questions about the records stored in the
database.
Design a Database
Following step-by-step instructions
students design a database that will organize NASA space mission
information. The Microsoft database will:
- store astronaut information
- store mission information
- search for astronauts by rank
- search for missions by
launching and landing dates
- search for missions by their
name
- search for missions by their
purpose
- view mission crests
- print a report of mission
information
We have done the work for you!
Research can be time consuming. For this reason, we have bookmarked
web pages for you about space missions, making it EASY for your
students to collect the information they will need to add records
into their database.
Build a Database Table
Detailed instructions help students
build a table in Datasheet View. They then follow the instructions
to edit the data type and properties for each field in Design View.
Create a Database Form
Using the Form Wizard in Microsoft
Access, students create a form. By following the database lesson
plans, it is simple to customize the appearance of the form.

DESIGN A DATABASE FORM
With TechnoKids
Technology Projects instead of preparing database lesson plans
for computer class, you can spend your time with
students having fun in the computer lab completing
meaningful activities.
Generate a Report
Detailed database lesson plans
make it easy! Students then follow the instructions to
generate a mission report that organizes the astronauts in the
database according to astronaut rank.
They use the report to choose
astronauts for a space mission.
Database Technology Skills
- create a database that stores
space mission information
- add a record
- filter records using search
criteria
- build a table to store data in
a database
- add a primary key to a table
- add a field description for a
field in a table
- select the data type for a
field in a table
- set the field properties for a
field in a table
- create a form to make data
entry easy
- customize the appearance of a
form
- enter data using a table and
form
- generate a report
- group fields in a report
How Much Does the TechnoNASA Technology
Project Cost?
TechnoNASA is great value
for your money. When you order TechnoNASA you will receive a teacher guide,
student workbook, and customizable resource files
for a price that is
affordable.
Software: Microsoft Access,
Windows Internet Explorer
Version: Office 2000, XP,
and 2003
|