|
|
Lab #2 - Creating a FileMaker Pro Database Part
I ------------ FOR WINDOWS
------------ |
OBJECTIVE: Part I: Using FileMaker Pro Version
5.0, design a mailing list database to keep track of
suppliers and the products they sell. The source of firm
names and their products is available from the Ohio
Nursery Stock Survey that is provided by the Ohio Nursery
and Landscape Association at: http://www.onla.org
Part II: Modify the layout of your mailing
list database, add several graphical elements to improve its appearance,
and incorporate several buttons that make working with the database
a lot easier.
PART I:
|
s T E P 1. |
Start FileMaker Pro by clicking on Programs, Class Instructor, FP5, FileMaker Pro. Choose the Create a new empty file option. Type in a File name of Maillist.fp5 and choose the
A drive for saving it. Click Save. |
|
|
s T E P 2. |
You are now going to start creating individual fields of information. Your cursor is already in the right spot, type ID and then click Create. Note that FileMaker assumes this field will hold text information. Leave it that way unless you are going to enter numbers. Create these other fields: Firm Name, Contact, Address, City, State, ZIP (number), Phone, FAX, Product, Email, and Web. Click Done. |
|
|
s T E P 3. |
FileMaker automatically puts all the fields on one page. Note on the bottom of the page that you are in the Browse mode. This view is used when you want to enter data into a field or browse through the database. Click on Browse (at the bottom of the window) and select Layout. Alternatively, you can choose Layout from the Mode option on the main menu. |
|
|
s T E P 4. |
Click on the A located to the left of the main screen. These are drawing tools for dressing up the look of your application. Move you mouse to the top of the page and right of the word Header. Click here and then type List of Suppliers. |
|
|
s T E P 5. |
Switch back to Browse mode. Now you need to enter the appropriate information into your database for 10 different firms. Click to the right of the field name for which you want to start entering information. NOTICE: a box appears that indicates where you should type. Press Tab to move from one field to the next.
|
|
|
s T E P 6. |
Choose Record from the main menu and New Record or press the Control and N keys to add a second record to your database. Repeat this for each new record that you want to add. Click on the little rolodex icon to move through the different records. |
|
|
s T E P 7. |
Choose Mode from the main menu and Sort. |
|
|
s T E P 8 |
Click on Product once, click Move, click Sort. Check to see what happened.
|
|
|
s T E P 9 |
You can do a search of the database and find cases that match a given criteria by choosing Find from the Mode menu. Click on one of the fields, type your criteria (something that will match an existing record), then press Find. |
|
|
|
Copyright © The Ohio State University |