Internet Hunt button
Puzzles and Projects
Nature button
Computers button
Home Button

Database in AppleWorks by Cindy O'Hora

If you manage any collection of people or stuff, use these tips to get yourself organized.
These tips address: Creating, Finding and Sorting, Matching & Reporting, Labels & Mail merging, Summaries and Calculations, & Challenges.
The links do work in many of these pdf files.

Creating - making and refining

Building a basic database - getting started

Copy your database - how to

Fancy field work - making data entry easier!

Auto entry date field - Wouldn't it be loverly?

Layout - tweaking the appearance

Auto enter date when box is checked

Reordering a value list or popup menu

Radio button field - either - or

Adding a new field to an existing database

Radio buttons and calculating data.

Changing the field tab order - enter it your way

Database Quiz

New View / Tiling Windows - see what you are making

Multimedia Field - how to add movies and photos AW5

Adjusting the layout in database List view

Database Internet Hunt

Making a List view of just some of your fields.

Make Your own Database - tutorial updated 12/07

Finding & Sorting records

Using Find in database - stop that scrolling!

Sorting your database - easy as ABC

Find by dates in a range - Locate all the Aprils & Mays

Sort and print separate lists.

Finding nothing - not as silly as it sounds Omitting records
Find by first letter(s) or number(s) Hiding records to solve printing challenges
Finding anything using Match Reports - Sorts and Finds together
Match by criteria in popup menus  

Labels, Mail merging, Project ideas

Mail Merging to print individual envelopes

Projects using database

Mail Merging to preprinted certificates - an award giver's dream come true.

Integrating Database in a class - easy and meaningful

Making mailing labels in AW 6

Graduation Project ideas

Making redundant labels

Using IF function to solve mail merge challenge

Using partially used label sheets

Database & Pennsylvania Graduation Project ideas
Printing a whole database - Just say no!  

Challenges:

List layout excluding fields

Importing one database into another

Summary to calculate across records

Adding a button to a database - off site

Word processing to database - how to convert

Calculating age from Date of Birth field - at Apple's TIL

Integrating a database into a classroom Troubleshooting your database - at Apple's TIL

Harnessing online databases 1 exercise

Harnessing online databases 2 exercise

Educational Value of Database off site

Choosing the Right Database System off site

Database Activity - vocabulary Digital Edge Learning Interchange - K-12 lessons

Database - Organizing activity

Eliminating Duplicate records - at Apple's TIL
Common words AppleWorks database. My daughter spent hours creating this database. It has the 1000 most commonly used words in English, provided in 20 word subsets. You can use it to create custom spelling lists and tests. Directions included. Shareware $20! Contact me for info.

Best Practices of Technology Integration in Michigan K12 all subjects!


Internet Hunts / Nature / Computers / Prominent Pennsylvanians / Puzzles & Projects / Site map / Home

All trademarks, copyright and logos belong to their respective owners.
©1998 Cynthia O'Hora All rights reserved. Updated 4/2009 by Cindy O'Hora

This site is an entirely volunteer effort. I am not associated with Apple Computers or any of its subsidiaries.