Access 2007 Home > Access 2007 Help and How-to > Access Demos
Office.comPowered by Bing

Watch this: Modify the Task Management Database template

The Access 2007 Task Management 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. Watch this short demo to see how you can add a field to a table, and then how to add that field to a form or report.

Watch this >>

Assistance Problems watching the video? Try our troubleshooting tips.

 Tip    Try Office 2010 Access 2010 features 5 web database templates that you can publish to Access Services on a SharePoint Server. Then, you can use the database in a browser. Read an article or try Office 2010!

In the video

In this video, we customize the Task Management database by adding a new field to the Tasks table, and then adding that field to the Task List form, the Task Details form, and the Task Details report.

Add a field to the Tasks table

  1. Close all open tabs.
  2. In the Navigation Pane, double-click the Tasks table.
  3. Scroll to the right until you see the column named Add New Field. Double-click the column heading, and then 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.
  1. Drag the field you want from the Field List to the form or report.

Top of Page Top of Page