Modify the Assets Access Database template

The Access 2007 Assets Database template is ready to use the first time that you open it, but you can also customize the database to better suit your needs.

Modifying the Assets database template

In this article

You can customize the Assets desktop database by adding a new field to the Assets table, and then adding that field to the Asset List form, the Asset Details form, and the Asset Details report.

Add a field to the Assets table

  1. Close all open tabs.

  2. In the Navigation Pane, double-click the Assets table.

  3. Scroll to the right until you see the column named Add New Field. Double-click the column heading, and type in the field name.

The first time you enter data in the column, Access sets the data type for you.

Add a field to a form or report

Once a field has been added to a table, you can then add it to a form or report.

  1. Right-click the form or report in the Navigation Pane and then click Layout View.

  2. On the Format tab, in the Controls group, click Add Existing Fields.

  3. Drag the field you want from the Field List to the form or report.

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×