Written by What you really value your databases for is the possibility to retrieve information out of it. There are very powerful reporting tools in Access that will help you with finding the information kept in your databases. You can create simple queries and examine records in your databases with the Report function.
In the Navigation menu choose the table or query you would like to use for your report. Then choose Create and Report. Access will create a simple report with the information from the table or with the result of your query. But usually you will need more information from your database than a simple report contains. If you want to create a customized report, there is a Report Wizard provided by Access that will help you to form the useful report.
If you want to use the Report Wizard, start with the Navigation menu and choose the table or query you want to use for your report. Then choose Create, then Report Wizard. The first page of the Report Wizard dialogue box will appear. At this first page you will be able to change our table or query before opening a Wizard. If you don’t want to replace your table or query, then go to the Available Fields list and choose each field you want in your report. Then move all the fields you want to the Selected Fields column clicking an arrow button. Or you can select all fields available by pressing the button with two arrows. Then click Next.
When you are done selecting the fields, you can select one you will group the information on. For example, you are creating a database of books, so you can create your report by genre and al books of one genre will be reported together. It is also possible to select subgroups. So, each genre can have a sub-group of the audience, for example. And click next again.
Select a sort order for your records and choose if you want it to be ascending or descending. You can also make calculations of sum, average, minimum or maximum with the Access. Then you can select a Layout and Orientation. The field width will be adjusted automatically to fit the page if you select the appropriate option in the Wizard. Click next again.
Choose a report style and press next. Then, give a title to your report and you can run it right away by leaving it activated. If you don’t want to work with it right away, you can open the report in Design view. In order to complete the report, click Finish.
This way you will be able to create reports with your Access databases and use the reporting tools for finding and analyzing the information in your databases.
Everything about microsoft access database: great training info, all sorts of business products (that can be tailored for the specifics of your business), special microsoft access database blog with tips and tricks about MA databases.
All this and more from a trustworthy UK based company which majors at microsoft access database and is assisting clients round the globe.
