Family Database Using Microsoft Works-Windows
- Technology
- Middle

- Activity Time
- Materials
- Concepts / Topics
Learners create and edit a family database, enter and sort records, generate and print reports, and use a formula and query to select records.
Making a Family Database
Grading
- Homework: 10 points
- Steps 1–10: 80 points
- “When You Finish” activity: 10 points
Create the Family Database
- Start Microsoft Works for Windows.
- Create a new file: Database.
Create the heading and fields below. Skip a line between each field, and be sure to type a colon after each field name.
Family database for (your name)
Field Width Last Name: 15 spaces First Name: 12 spaces Relation: 15 spaces Home State: 10 spaces Age: 4 spaces Height: 7 spaces - After you have entered all the fields, enter your family's records. Tap the TAB key to move down to the next field; Shift+TAB moves up through the fields. Don't forget to enter height in inches.
- When you are done entering all the information, check that everything is correct in List view (VIEW, LIST). Change the field widths to the widths shown above (FORMAT, FIELD WIDTH). This will allow you to see all the information in the records.
Sort your database from oldest to youngest:
- Click TOOLS, SORT RECORDS.
- In the first field, click the arrow to select AGE, then click Descending.
- Click OK. You should now see your records from oldest to youngest.
Make a report: choose TOOLS, CREATE NEW REPORT.
- Type Family Database for (your name). Don't click OK yet!
- Add ALL FIELDS by clicking ADD for each field. Then click OK once.
- You are now in the Report Statistics screen. Get the average age by clicking AGE, then AVERAGE. Click OK.
Print your report:
- Click FILE, PAGE SETUP and change your left and right margins to .5.
- Do a PRINT PREVIEW. If it fits on one page, print. If not, raise your hand.
Name your report:
- Choose TOOLS, NAME REPORT.
- Click the box next to NAME and type Whole Family.
- Click RENAME, then DONE.
- Save as FAMILY1.
When You Finish (10 Points)
Put in a formula and use a query to select records.
Choose TOOLS, MAKE A NEW REPORT.
- Title: Family members younger than 32
- Add fields LAST, FIRST, AGE, HEIGHT, then tap OK twice to get to the Report Definition screen.
- In column E in the HEADINGS row, type Inches/Year.
- In column E in the RECORD row, type =Height/Age (this is like a formula in spreadsheets).
- Format your formula. With it still highlighted, choose Format, Number, Fixed, 2 decimals.
Make a query: choose TOOLS, CREATE NEW QUERY.
- In letter A, click the arrow to choose Age.
- In letter B, click the arrow to choose Less than.
- In letter E, type 32.
- In letter F, choose Height.
- In letter G, choose Greater than.
- In letter I, type 55.
- Do a Print Preview and zoom in. You should see all those people who are less than 32 and over 55 inches tall. Print your report if it fits on one page.
- Save as FAMILY2.
Teachers.Net · https://teachers.net/lessons/326.html