To delete a table from the database
Modifying Databases |
You can use the following procedures to modify the tables and data in your database.
To delete a table from the database
|
|
Deleting a table from the database is not supported when you access the editor by clicking Edit Data on the List Items property page for a data entry control. This is because only the single table that contains the data that is linked to the control can be modified by using the control's List Items property page. |
Use one of the following methods:
On the Home tab, click Remove Table.
In the Tables pane, use the secondary mouse button to click the table that you want to delete, and then click Remove.
|
|
Renaming a table is not supported when you access the editor by clicking Edit Data on the List Items property page for a data entry control. |
In the Tables pane, double-click the table that you want to rename, and then enter the new name. Alternatively, use the secondary mouse button to click the table, click Rename, and then enter the new name.
To delete a field from a table
Use one of the following methods:
In Data view, use the secondary mouse button to click the column header for the field that you want to delete, and then click Delete. Alternatively, click any cell in the column for the field that you want to delete, and then on the Fields tab, click Remove Field.
In the fields pane of Design view, use the secondary mouse button to click the field name, data type, or description for the column that you want to delete, and then click Delete.
On the Home tab, click Remove All Fields. This action deletes all fields from the selected database.
In the fields pane of Design view, click to select the field that you want to delete, click a column header, and then press the Delete key.
Use one of the following methods:
In Data view, double-click the column header for the field that you want to rename, and then enter the new name. Alternatively, use the secondary mouse button to click the header, click Rename, and then enter the new name.
In Design view, click the field name for the field that you want to rename, and then enter the new name.
To change the data type of a field
Use one of the following methods:
In Data view, click any cell in the column for the field that you want to modify, and then select the new data type in the Data Type list on the Fields tab.
In the fields pane of Design view, click the data type for the field that you want to modify, and then click the new data type in the list.
To change the data type format
Use one of the following methods:
In Data view, click any cell in the column for the field that you want to modify, and then select the new data type format in the Format list on the Fields tab.
In the fields pane of Design view, click the field that you want to modify, and then in the Field Properties pane, click the new format in the Format list.
|
|
You can change the format for the number, date, time, and check box data types. |
To change a field's default value
Use one of the following methods:
In Data view, click any cell in the column for the field whose default value you want to change, and then enter the value that you want in the Default Value box on the Fields tab.
In the fields pane of Design view, click the field that you want to modify, and then in the Field Properties pane, enter the value that you want in the Default Value box.
In Data view, click the column header for the field that you want to move, and then drag it to the location that you want.
To sort the data in the fields
In Data view, use the secondary mouse button click the column header for the field that you want to sort by, and then click Sort Ascending or Sort Descending.
