Microsoft Access 3D: Reports: Modify Report in Layout and Design View, Add a Group and Sort

Reports:

• Forms are a nicer way of looking at tables or queries on your screen.
• Reports are also a nicer way of looking at tables or queries on printed paper.
• An example of a tabular report is shown below listing all students
• Tabular reports, as shown below are more common than columnar reports that you may come across in the next section

Reports also have some additional features:

• Logos, and headings can be placed at the top (like forms)
• Page numbers and dates may be placed at the top or bottom.
• Formulas may also be put on reports:
• eg. total number of students, average cost of a dvd, the total sales for a day, week or month etc.

Create a Report :

• You can create a report that will take information from a table or query and put it into a report automatically, similiar to the create a form procedure used to create forms.

• Similiarly to forms, reports can then be modified and extra details added.

Layout View, Report View, Design View :

• In Report View, your report appears as it would if you were to print it out, (you can't make any changes to it).
• In Layout View, your report also appears as it would if you were to print it out, however you can make some changes to it such as:
  • change the titles of the columns, adjust the column size, change the title, sort a column
• In Design View, your report does not look like what the printed report is, however you can make advanced changes (covered in next section).

Note:

If you create a report based on a query, the report will not be sorted automatically as the query was, you will have to use the tools in the Layout View to create a sort similiar to what you had in the query.

Example: when you create a report based on this query:

All the information from the query appears, however the LastName is not sorted as it was in the query (you just have to do another little step to create a sort based on the LastName field which you will learn in the assignment).

This website is copyright protected see contact page for details.