How to Create Reports In Microsoft Access 2016

Access 2016

Introduction

If you need to share information from your database with someone but don’t want that person actually working with your database, consider creating a report. Reports allow you to organize and present your data in a reader-friendly, visually appealing format. Access makes it easy to create and customize a report using data from any query or table in your database.

To make a report : Reports enable you to exhibit parts of your database in a simple to-peruse, printable organization. Access gives you a chance to make reports from the two tables and questions.

Open the table or inquiry you need to use in your report. We need to print a rundown of treats we’ve sold, so we’ll open the Cookies Sold question.

The Cookies Sold query

Select the Create tab on the Ribbon. Find the Reports gathering, at that point tap the Report charge.

Clicking the Report command

Access will make another report in view of your question.

It’s conceivable that a portion of your information will be situated on the opposite side of the page break. To settle this, resize your fields. Essentially select a field, at that point snap and drag its edge until the point when the field is the coveted size. Rehash with extra fields until the point that the greater part of your fields fit.

Resizing fields in the report

To spare your report, tap the Save charge on the Quick Access Toolbar. Whenever incited, type a name for your report, at that point click OK.

Saving and naming the report

Much the same as tables and inquiries, reports can be arranged and sifted. Just right-tap the field you need to sort or channel, at that point select the coveted alternative from the menu.

Erasing fields

You may find that your report contains a few fields you don’t generally need to see. For example, our report contains the Zip Code field, which isn’t important in a rundown of requests. Luckily, you can erase fields in reports without influencing the table or inquiry where you got your information.

To erase a field in a report:

Snap any cell in the field you need to erase, at that point press the Delete key on your console.

Deleting a field

The field will be erased.

When you erase a field, make certain to erase its header too. Just select the header and press the Delete key.

Erasing a field header subsequent to erasing the related field

Deleting a field

BLOGS : Office Setup Help

Leave a Reply

Your email address will not be published. Required fields are marked *