The Columns of a Table in Datasheet View |
|
Introduction |
You can create the columns of a table in Datasheet View. You can create the columns from scratch or use some samples columns provided in Microsoft Access. After starting a table in Datasheet View (on the Ribbon, you could click Create and click Table in the Tables section), you can double-click Add New Field and type the desired name.
You can also create a column using one of the sample columns provided by Microsoft Access. First, to use a sample table, on the ribbon, you can click Create. Then, in the Tables section, click Table Templates to see a list of sample tables: |
In the Fields & Columns section, click New Field. This would display the Field Templates window: To expand a node, you can click its + button. Here is an example: To use a field from the Field Templates window:
Some operations will require that you select a column:
To change the width of a column:
To move a column in Datasheet View, select it, click and hold your mouse on it. Then, start dragging left or right in the desired direction: To move a group of columns, select them, click and hold the mouse on one of the selected columns. Start dragging left or right in the desired direction:
To rename a column:
To hide a column, drag
the right border of its column header completely to its left border: To hide one or a group of columns, right-click and click Hide Column. You can also right-click any column and click Unhide Column. Here is an example: To hide a column, clear its check box. To reveal a column or a group of columns previously hidden, right-click any column header on the table and click Unhide Column. In the Unhide Columns dialog box, put a check mark on each column you want to show.
To remove a column from a table:
Any of these actions would present you a warning to confirm whether you still want to delete the column(s) or you want to change your mind. If you still want to remove the column(s), click Yes.
|
|
||
Home | Copyright © 2008-2016, FunctionX, Inc. | |
|