Building a Report

in Microsoft Access 2000


Database name:  VideoStore

Filenames:  Customers, Videos, Employees


Open the database file


Choose “Reports” (on the left)


Create reports by using wizard  (can also experiment with the Design View too)


Select the fields you want in your report by moving them from the left window to the right window


So you want any groupings?  Just choose <Next>


Select your sorting order


Select your layout and orientation


Select the style


Enter the file name of your report (note that this will be your fourth file in your database)

Choose “Preview the report” or “Modify the design”