0
Go to the Design View for the table. Then click on the field name for the column you want to get rid of and press the delete key. It will prompt you to make sure you want to do it, as you will lose the data in it if you do. Click OK if you want to and it will be gone. When you next open the table, the column will no longer be in it.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Shortcut command used to delete a table column?
Delete column
To delete a field in a table right-click the column heading for the field and then click on the shortcut menu?
I believe it is "Delete Column"
When records are no longer needed what do you do to the table in access?
You "delete the records" from the table.
How you can delete a column from the table?
Can you be more specific? What kind of table do you mean, and what program are you using? A SQL statement like this will do it: alter table tblName drop column colName tblName is the name of the table colName is the name of the column
What is a leftmost column?
It is the first column in a table on the left. In a spreadsheet it would be column A. In Access it would the column for the first field. In a table in Word, it would be the first column on the left.
How do you delete a field from a query in access?
Right click the column heading. Then click delete field from the shortcut menu.
What is the row and column format of an Access table called?
layout
In an Access table each column contains a category of data called?
Field
In an access table each column contains a category of data called what?
Field
What are the parts of a basic SQL query?
The basic parts of a SQL Select query are: SELECT column names FROM table name WHERE conditions ORDER BY column names The basic parts of an insert query would be: INSERT INTO table name (VALUES) The basic parts of a delete query would be DELETE FROM table name WHERE conditions The basic parts of an update query would be UPDATE TABLE table name SET column name = value WHERE conditions
Delete column vba excel?
to delete column B Columns("B:B").Delete Shift:=xlToLeft
What are the columns in Microsoft Access table called?
In a Microsoft Access table each column shows the information in a field. Each row shows a record.
