Meaning Of Letterman Jacket

Modify tables data tables

Here we see the record-editing techniques for modifying the definition of a table as the data entered into it.

Modify the design of a table .

If you create a table, we want to change some of its definition (eg add a new column, expand a column that already exists, delete a column, etc ...) we have to make a change in its design:

Open the database where the table to modify, if not already selected.

Right click on we want to modify the table, select Design View on the shortcut menu:

To amend the definition of a field, place the cursor on the field to modify and make the necessary substitutions.

To add a new field ,

• Go to the bottom of the table and write the definition of the new field.
• Standing in one of the fields already created and click the button the Layout tab, in the latter case the new field is inserted before they are positioned.


To remove a field,

• Position in the field and click the button Layout tab.
• Select the entire row for the field by clicking its left end and when it is highlighted press the Delete key or

Del. field will be deleted from the table definition and data stored in the field will also disappear.

Enter and modify data in a table.

To enter data into a table, we can choose between: • Double-click
s holding the name of the table in the Navigation Pane.
• From the Scan Panel to right click on the table to fill in and select on the shortcut menu.
• If we are in the Table Design view, click on the button V ists object and choose Datasheet View from the Home tab or design.



In all three cases appear Datasheet window:

Each row is useful to introduce a register.

Write the value of the first field of the record.

Press ENTER to go to the second field of the record.

When finished entering all the fields in the first row, press ENTER to enter the data in the second record.

When we change the registry, the store is being introduced, it is necessary to keep records of the table.

Click on the Close button to end the table.

If we want to delete a whole record:

Select the record to delete by clicking on the box to the left of the record.

The record will be selected.

Press the DELETE key keyboard or click the Delete button on the panel records the Startup tab.

If we want to change any value entered, we have only put us on the value to be modified and re-write.

If we want to change something about the structure of the table, we have to go to Design View by clicking on the View button to view the Home tab.