It's up to you
...ur newly created table and database. First look at it in the table view. Tap the Table tab at the bottom of the screen and then choose Customers from the dropdown list and hit View Table. This will open the table and will automatically add a new record since the table is empty. Add a couple records for testing. Tap each box under the Field Names and enter the information for the first record. Once you have entered all the data for Mel Gibson, click the Table Menu and hit Add Record. This will add a new row to the table for you to enter the next information in. Repeat these steps until you have entered all the information. (You can enter more or less than there is here, three is just an easy number to work with so you don’t have to type in a whole bunch of information) CustID FirstName LastName Address State Birthdate Recent Purchase Num Purchases PI123 Mel Gibson Hollywood CA 5/12/63 TRUE 5 PI456 Bart Simpson Springfield Fox 10/2/88 FALSE 0 PI789 Bill Gates Seattle WA 1/28/34 TRUE 72 Make sure to save your table by selecting Save from the File Menu. Tap on the Main View tab. This will close the table and you will be prompted to save the table, choose Yes. Now open the table again the same way. The information you just entered will be displayed. Now choose the Bart Simpson record and hit Delete Record on the Table Menu. Close the table and you will again be prompted to save the table. If you choose Yes, that record will be deleted permanently, but if you choose No it will not be deleted. (For the purposes of this tutorial, do not delete Bart or you may feel foolish later on) Also try resizing the columns so that you can fit more data on the screen. To do this, just click the Resize button on the menu. A window will pop up in front of the column names at the top of the screen. Change the size of the FirstName column by clicking and dragging the line between FirstName and LastName. You can change any of the column sizes with this technique. To save your changes, click Save, otherwise click Cancel on the menu and no changes will be made to your data. Each time you open the Customers table now, it will have the same widths as you just saved. 5. Now practice sorting the database. With the table open in table view, tap Sort on the Tools menu. Try a basic sort first. You can sort by up to 4 different fields. Choose the table you want to sort, Customers, and in the first box, choose CustID and Desc. When you have finished selecting these options hit Sort. You will be prompted whether or not you wish to view the sorted data in a predefined form, but none have been created yet, so choose No. The window will disappear and the table will be sorted according to the options you chose. 6. Searching through the database involves basically the same steps as the sort. Choose Search / Filter from the Tools menu. Choose the Customers table and then choose the FirstName field to search in. Type in “B” for the search term and choose “Begins With”. Press the Filter button and choose to open the data in the table view. Assuming that you didn’t delete the Bart Simpson record, there will be two records returned. The other records haven’t been deleted from the database, and you can still edit and change data just as you would normally. The next time you open the database, all the records will be there. 7. Now for the most exciting part of the tutorial and of Pocket Database, look at the Form tab and begin creating your own customized form for this table. Choose to create a form for the Customers table by selecting it from the drop down box at the bottom of the screen. The table name is displayed in blue at the top of the screen. Now you need to make the text boxes to hold your data. “CustID” should be shown in the box labeled ‘Field to Create’. Choose the type of field you want, a text box. Click Create Field and the dialog box will disappear. Click and drag a box to make the text box be whatever dimensions you would like it to be. The newly created box will have a CustID label over the top of it. If you are happy with the field you created, click Finish Field Edit at the bottom of the screen and the dialog box will reappear with the next field to create. If you do not like how it looks, you can continue to change it clicking and dragging again. (Remember, you can place fields behind the wizard box since it will not be there when you are viewing your records.) The wizard will advance to the next field each time you finish making a field. As you progress through the fields, make the State field a drop down box, birthdate a date field and RecentPurchase as a boolean field. Once you have finished creating all the fields, the wizard box will disappear and you will need to enter a distinctive name for this form so that you will remember what is on it, perhaps AllCustData or something similarly descriptive. You will then be taken to the first record of the table. There is a command bar at the bottom of the screen that will help you to maneuver through all your records. Scroll through your records a couple of times using the Back and Next buttons. The record box in the middle of the navigation bar tells you what record you are currently viewing, and the number following this number is the number of records in the database (Should be three unless Bart was deleted). Click this and a dialog box will appear asking which record you would like to move to. Type in 3 and press OK to move directly to Bill Gates. You can edit your form by clicking the Edit Form button at the top left of the screen. This will take you to the form edit screen. Let’s change the title of the form to Clientele. Let’s also add some state abbreviations to the State field. Click the field name drop down box and select State. At the bottom right of the screen, click Add. Enter TX into the dialog that appears on the screen and hit OK. Add a few more sta...