How to create a report from a query in access

In this chapter, we will be covering the basics of reports and how to create reports. Reports offer a way to view, format, and summarize the information in your Microsoft Access database.

For example, you can create a simple report of phone numbers for all your contacts.

• A report consists of information that is pulled from tables or queries, as well as information that is stored with the report design, such as labels, headings, and graphics.

• The tables or queries that provide the underlying data are also known as the report's record source.

• If the fields that you want to include all exist in a single table, use that table as the record source.

• If the fields are contained in more than one table, you need to use one or more queries as the record source.

Example

We will now take a simple example to understand the process of creating a very simple report.

For this, we need to go to the Create tab.

Before clicking on the Report button to create a basic report, make sure the proper query is selected. In this case, qryCurrentProjects is se

how to create report in ms access step by step with examples

how to create report in microsoft access