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
-
Double-click the table that you want to change.
-
In the rightmost column, click the down-arrow next to Click to Add.
-
Select the data type that you want to store in the field. For example, to store a date, choose Date & Time.
-
Access creates the new column and selects the field name.
-
Type a name for the field.
-
Press ENTER.
Access selects the next column and displays the data type drop down list. -
If you want to add another field, repeat this procedure from step 3.
-
Save and close the table.
Add a field to a form or report
-
In the Navigation Pane, right-click the form or report, and then click Layout View.
-
If necessary, add a new row or column to the layout in which the form or report's controls are contained:
-
Select a cell adjacent to where you want to insert a new row or column.
-
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.
-
If the Field List pane is not displayed, on the Design tab, in the Tools group, click Add Existing Fields.
-
In the Field List, navigate to the table or query that contains the field you want to add.
-
Drag the field from the Field List to the form or report.
-
If necessary, resize the row or column to fit the new field.
-
Save and close the form or report.
Add a field to a datasheet
-
If the Navigation Pane is not displayed, press F11 to open it.
-
If the Field List pane is not displayed, on the Design tab, in the Tools group, click Add Existing Fields.
-
In the Field List, navigate to the table or query that contains the field you want to add.
-
Drag the field from the Field List to the datasheet.
-
If necessary, resize column to fit the new field.
-
Save and close the datasheet.
No comments:
Post a Comment