Microsoft Access is a database application included in MS Office suite which will allow you to combine and use data in different ways. Using this database application, you can generate reports and send it by emailing it in a variety of formats. This article contains instructions for doing the same.
Microsoft tech support instructions
Follow the instructions mentioned below for creating a MS Access report and send the same in MS Outlook.
- The easiest of ways for creating a report in MS Access is to create a query which contains the data you want to include in your report. To do this, go to the Query view and select the option which says “Create query by using wizard”. This wizard will help you to combine data from the tables of the database for achieving the results you want. Also, using a query will make it easier for filtering out the results you don’t like to report. Simply make use of the query view to choose the data you want.
- Once you have finished designing your query and have selected the data which you would like to use in your report, go to the reports view and select the option labeled “Create report by using wizard”.
- As you run thorough this wizard, choose the query that you have just created, and then the fields from that query that you would like to include in your report. After that, select the way you want to group your data. It will also allow you to choose the way you want your report to look.
- Once the basic report has been created, go back and forth between preview mode and design view for fine-tuning it. Ensure that all your chosen data and grouping levels are in the way that you want them to be.
- Once you have finished fine-tuning the report, then it’s time to send it. Thanks to Microsoft that MS Access provides a simple method for sending reports through Outlook. To do this, click on “File”, “Send to” and then “Mail Recipient (as attachment)”. This will provide you with a list of options including but not limited to Excel, HTML, Rich Text Format, and plain text.
- Rich Text Format will allow both text and formatting associated with that text to be sent from one word processing platform to a different one.
That’s all with the instructions for creating a MS Access report and sending it through Outlook. Ciao!