Microsoft Access Tutorial - Quickest Way to Make a Report
1. Open the database
The database you want to create a report for should have at least one table. Open the database for which you would like to create a report on. This tutorial uses the Access database that was created in a previous reading.
2. Click on Insert and Then Report.
On the right pane select AutoReport. There are two options. Either pick columnar or tabular. This is simply how the report will look. You can look at the picture on the left after clicking a report name to see an example of how the report will look. On the drop down menu select the table or query you would like to use for this report. For this example I will use the table called "People". Once you have made the selections click on OK.
3. Open the Report
Open the report that you have just created. If you picked columnar, you will see all the fields on the left column and all the data in the table on the right column. If you selected tabular, you see that it will look like how the table shows up in the datasheet view. Each entry in your table will be separated by a line on this report.
Click on X and it will ask you if you want to save the changes, select yes. Give your report any name.
You will then see it under the reports on the main dialog window. You can make changes to it by right clicking on a report and clicking on "Design View". For this example, I would suggest you use the tabular version once you are in design view because that looks most like how your Access table looks in the datasheet view.
Once again, if you right click on it and click "Design View", you can make actual changes to the physical layout of the report that has more customization than the report that was automatically generated.
You can use this technique to create a report quickly and then make edits to that report to make it look like you want. This is sometimes easier than trying to make a report in Microsoft Access from scratch.
I would suggest to always use this technique if you need to create a lot of customization for your report because once you have something to work with, you will find it easier to make edits to it. Since you didn't have to spend any time creating the report (since you used Microsoft Access AutoReport feature), you can use more of your time on actually making it customized.
Published by Kantus
I love writing short stories and humor articles, but tend to stick with topics that are discoverable by search engines and capable of spreading virally. View profile
- Microsoft Access Tutorial - How to Create Multiple TablesThis article shows four ways to creating multiple tables in your Microsoft Access databases.
- Microsoft Access Tutorial - Convert Database to Different Version of AccessThis is a tutorial showing how to convert a database between different versions of Microsoft Access.
How to Import Microsoft Excel Data Into Microsoft AccessYou may not be getting everything you can out of your data by using Microsoft Excel. Importing Microsoft Excel data into Microsoft Access is easy and will give you additional d...- Microsoft Access - 4 Steps to Adding Data to a Database TableStep by Step guide to adding actual data into a Microsoft Access database table.
- Microsoft Access Tutorial - Data Access Page (using Design View)This tutorial shows you how to use the design view rather than the built in wizard for creating a data access page in Microsoft Access
- Microsoft Access Tutorial: How to Modify Datasheet Layout Options
- Microsoft Access Tutorial - Primary Key and IDs
- Mastering Microsoft Access - Creating Great Useful Databases - Lesson 1
- Microsoft Access Tutorial: How to Password Protect Your Database
- How to Execute a Basic WHERE Clause SQL Query In Microsoft Access
- Microsoft Access Tutorial - How to Create Documentation for Tables
- Microsoft Access Tutorial - How to Create a Chart of Data