MAKE SURE THAT YOU SAVE THE NEW TABLE AT THE END OF EACH CUT AND PASTE OPERATION, THEN CLOSE DESIGN VIEW AND CHECK THAT YOUR CHANGES HAVE BEEN REFLECTED IN THE ACTUAL TABLE, BY OPENING THE TABLE. Continue in this fashion until all fields are in the order that you want. Then "Paste" the previously cut fields back into the table below the last field name, in the first blank row, again by right-clicking and selecting "Paste."Ĥ. "Cut" the highlighted fields by right-clicking on them and selecting "Cut." The relocated field (and all others below it) should shift up to its new position.ģ. For example, in a price list table, there might be one field for item name, one for the description and a third for the price. Step 3: Move the various fields up or down in the right pane by selecting the field and clicking either the up arrow or the down arrow. Go through the entire list of fields and make sure you include all of the employee data you want to include in your database. Space Name field will be inserted (coincidentally) the name you want to assign to the field, eg name, surname, phone number, and so on. Queries: Queries can be designed using a wizard, in SQL or in a design view. They are neat: Without any effort on the users part (once the table is built) these fields. At this point we select the button Table and the respective entry Create Table in Design View, with the following screen. Some of the OpenOffice table field types are yes/no, date, text, integer, image and binary. are both used and under point 2, the string which the user inserted under point 1 will be displayed in the extra field. Do this in Design View by clicking the row of the first field below where you want the relocated field name to appear, then shift-clicking the row of the field immediately above the field that you wish to relocate.Ģ. A field in a table is one bit of information. To add a field to your table select the field and then click the > button to add. In a moment, Im going to be talking about auto increment fields. This field can be used by the user to define a string which should be appended to the CREATE TABLE statement. Highlight the intervening fields between where you want the relocated field to appear and its current position. It's kludgy, but you do it by selective cutting and pasting of multiple fields.
0 Comments
Leave a Reply. |