Dec 19, 2008 · Well that is true almost; custom menus are available in the hard to find Add-Ins Ribbon tab and Toolbars that appeared at the top of the Access 2003 databases are completely gone. What has been retained in the user interface in full in Access 2007 though is right click menus.

A Total line appears at the bottom of the table or query. Click on the Total line under the column you want to total. A down-arrow appears on the left side of the field. Click the down-arrow and then choose the function you want to perform. Access performs the calculation and displays the results in the proper column on the Totals row.