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 an autoshop. The database will have the following fields:

Field Name	Type
Customer Name	Text
Make of Car	Text
Year of Car	Number
Picture of Car	Container
Shocks	Text - Checkbox
Brakes	Text - Checkbox
Tires	Text - Checkbox
Oil Change	Text - Checkbox
Shocks Price	Calculation - If(isempty(Shocks),0,150)
Brakes Price	Calculation - If(isempty(Brakes),0,250)
Tires Price	Calculation - If(isempty(Tires),0,300)
Oil Change Price	Calculation - If(isempty(Oil Change),0,35)
Subtotal	Calculation - Shocks price+Brakes Price+Tires Price+ Oil Change Price
Tax	Claculation - Subtotal * .15
Total	Claculation - Subtotal + Tax

You will need to create a command button in Layout mode using the command button tool in order to import the picture efficiently. (The tool looks like a finger pointing to a button.) Once that tool has been selected you are able to select a spot on your layout for the button. The next step is to select the command for the button which will be to import picture. The third step is to name the command button "Import Picture". The Button will now allow you to import a picture as long as you are in browse mode and you have clicked on the picture container first.

Creating a Checkbox

You must have the field created before you can change it to a checkbox. In this assignment the fields are: Shocks, Brakes, Tires, Oil Change. If you want to change the format of these fields you must be in layout mode.

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 (Eg. Shocks) 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.

You must repeat the process for the other three fields.

Part 2

Getting the price to work involves entering in a formula in the corresponding field.

Ex. Shocks (Check Box) - Shocks Price (This Field Gets the Calculation Formula)

I have given you the proper formula at the top of this document. The formula checks to see if the box is checked. If the box is checked, the Price field will get the price defined in the formula.

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!