Database Assignments

Tip: If you ever need to format a field, go to File - Define - Fields

Part 1) Create a Database that will be used by a Pizza Shop. The database will have some of the following fields. You must create any additional fields that will make the Database work.

Field Name	Type
Customer Name	Text
Phone #	Text
Address	Text
Large	Text - Checkbox
Medium	Text - Checkbox
Small	Text - Checkbox
Peperonni	Text - Checkbox
Cheese	Text - Checkbox
Peppers	Text - Checkbox
Drink	Text - Checkbox
Pickup	Text - Checkbox
Delivery	Text - Checkbox
Subtotal	Calculation
Tax	Claculation - Subtotal * .15
Total	Claculation - Subtotal + Tax

Creating a Checkbox

Step One: Select the field by clicking on it

Step Two: Go to the format menu at the top and then select field format

Step Three: The style must be changed from Pop-up List to Check Boxes

Step Four: Beside Check boxes it says "using value list" and then there is another drop down menu. Select that secont drop down menu and go to Define Value Lists.

Step Five: Once the Define Value Lists dialogue box is active you must enter the Value List Name. You must do this right beside where it says Value List Name and then select create.

Step Six: Once you select Create it asks you in the larger box to type in the Value List Name Again.

Step Seven: Select Save

Step Eight: Select Done

You have now changed the field format to a check box.

Part 3

Be sure to add extras such as colour to your fields and a header or footer.(This must be done in Layout Mode). Adding colour to a field can be done by right-clicking on it and selecting the fill option on the menu. Also, changing the field to currency can be done by right clicking on the field and then selecting number from the menu. Adding a text box in the header can be done by clicking on the "A" and then selecting a spot in the header. Good Luck!