Access Tutorials

One of the great features of Access is dealing efficiently with large amounts of data. Access has functions that lets you analyze and sort specific chunks of data without having to deal with all the raw data sometimes when a query isn’t enough. The same holds true for reports, you can design reports that fit your needs. You can specify what subset of data to print and which data to ignore. In this tutorial, I will show you how easy it is to create your own custom design reports that actually print what you need.
 

Go to Start>Programs>Microsoft Access to open the program. Go to File>Open and find the database named “Customer Listing.” The database will open in the table view, which looks like an Excel spreadsheet. From the “Objects” menu on the left hand side of your screen, click on “Reports,” and the select the option “Create report by using wizard.”

Next, select the “Tables/Queries List” arrow, click on “Query: Selection Quantities,” then click Category within the “Available Fields” and hit the “Select Single Field” button. Next, select the following field titles, “FirstName, LastName and OrganizationName” – you want to custom design a report that only prints these pieces of data, and click Next.

Now, select “first sort order list” arrow and click “Category.” Then click Next.

In this step, ensure that the “Tabular” layout and “Portrait” orientation options are selected. Next, select “Corporate” style and hit Next. Finally, we’ll name the report, “Customer Key Information” and click on the “Preview the report” button, and hit Finish. Next, you’ll see the preview of the report.

 
Great Job! You created a report that fits your business needs in less than five minutes.