Database Features  «Prev 

MS Access window

For instance the Open dialog boxes for all the Office 2000 applications are nearly identical. Many of the applications also have similar menu options—, which makes them easier to use when you are familiar with other Office applications. Office 2000 has some interface changes from Office ‘97, but Microsoft has kept the consistency across the 2000 applications. For instance, the Open dialog box has a new look, but it is the same Open dialog box that you will see in Excel 2000 and Word 2000.
With Office 2000, Microsoft has changed the look of some applications. Access 2000, for instance, has a different look than Access 97, Microsoft is trying to make Access look more like Outlook by using a vertical bar to access different types of information within the application. For instance, in Outlook you use the vertical Outlook bar to display your Inbox or Calendar. In Access you use the vertical Objects bar to display tables, queries, reports, and forms.

Creating Reports

Reports are probably the most common way that users will view their data, and that is why it is one of the more robust features in Access. The Reports group of the Create Ribbon provides all of the options for creating reports through the Access UI. Much like forms, Access provides a number of different options for building predefi ned report types, many of which require an object to be selected in the Navigation Pane before the option is available. Clicking on any of these options will create a new report and open it in the main Access window.
Similar to forms, there are also two designers available for building reports in Access 2010:
  1. the classic Design View designer, and
  2. the newer Layout View designer.
These designers operate in the same manner as they do with forms, but it is worth noting that the Layout View designer is extremely useful for reports because you can see the actual data that you are building the report for. The both Report designers provide two panes: the Grouping and Sorting pane, which greatly improves grouping, sorting, and fi ltering tasks in a report; and the Design Task pane, which provides the Property Sheet and the Field List. Finally, Access 2010 also provides two standard View modes for Reports:

Report View and Print Preview modes.