After you have created your table, you are not stuck with that first version of the table. You can modify your table by adding, deleting, and reordering fields. Despite the fact that the order of your fields don't affect how your table functions within the database, changing their order may make it easier for you and anyone else to understand the table's structure.
In order to change your table, first right click the table that you wish to modify. When you have done that click design view and then you will be able to do a number of things to change the look of your table.
Firstly, you will be able to delete a field, to do this click the row selector of the row you wish to delete and then click the delete rows button, and then click yes in order to confirm that you wish to delete this row.
Secondly, you can also add additional fields to your table if you need to display more information or data. To add a field, click the row selector of the row below where you want the new field to appear. When you have done this, click the insert row button, type a name for the field and then click the row's data type cell. Now click the down arrow that appears and click the desired data type.
Finally, in order to reorder the fields within your table, click the row selector of the row you want to move and then drag the row selector to the desired position.
Deixe o seu comentario
Post a Comment