Video: Modify the Access 2010 templates

This video shows you how to add a new field to an Access 2010 template, and then add that new field to a form. It also demonstrates how to publish a template to Access Services, and how to synchronize changes to the server. You can use the techniques in this video to modify any Access 2010 database.

In the video

Add a field to a table

  1. Double-click the table that you want to change.
  2. In the rightmost column, click the down-arrow next to Click to Add.
  3. Select the data type that you want to store in the field. For example, to store a date, choose Date & Time.
  4. Access creates the new column and selects the field name.
  5. Type a name for the field.
  6. Press ENTER.

    Access selects the next column and displays the data type drop down list.
  7. If you want to add another field, repeat this procedure from step 3.
  8. Save and close the table.

Top of Page Top of Page

Add a field to a form or report

  1. In the Navigation Pane, right-click the form or report, and then click Layout View.
  2. If necessary, add a new row or column to the layout in which the form or report's controls are contained:
  1. Select a cell adjacent to where you want to insert a new row or column.
  2. On the Arrange tab, in the Rows & Columns group, click one of the Insert buttons to insert a new row above or below the selected cell, or a new column to the left or to the right of the selected cell.
  1. If the Field List pane is not displayed, on the Design tab, in the Tools group, click Add Existing Fields.
  2. In the Field List, navigate to the table or query that contains the field you want to add.
  3. Drag the field from the Field List to the form or report.
  4. If necessary, resize the row or column to fit the new field.
  5. Save and close the form or report.

Top of Page Top of Page 

Add a field to a datasheet

  1. If the Navigation Pane is not displayed, press F11 to open it.
  2. If the Field List pane is not displayed, on the Design tab, in the Tools group, click Add Existing Fields.
  3. In the Field List, navigate to the table or query that contains the field you want to add.
  4. Drag the field from the Field List to the datasheet.
  5. If necessary, resize column to fit the new field.
  6. Save and close the datasheet.


Top of Page Top of Page