How to Create a Bill Report on Microsoft Access 2007

Create bill report in Access 2007 by using the report form and an existing bill query.

Microsoft Access 2007 databases objects are often used to develop other objects in the database. Tables and forms are used to input data. The queries can be made of tables and they extract data out of the database. Reports also pull data out of the database and they can be based on tables, forms, and queries. Create a bill report by creating a query to locate the bills in the database. The report form is generated directly from the query.

Instructions

1. Open Access 2007 and select a database containing bills by clicking the "File" tab and selecting the "Open" option. Search your computer for the database. Click the database and the "Open" button.

2. Click the "Create" tab on the ribbon and select the "Query Design" button. Select a table that contains your billing and expense information when the Show Table dialog box opens. Drag this table into the query by clicking the name and dragging it into the query. Close the Show Table dialog box by clicking the "X" in the upper right corner.

3. Add fields to the query by clicking the table field names and dragging them into the query. In the field containing the expense type, add criteria that isolates the bills. Type "Bill" in the Criteria field and run the query by clicking the "Run" icon on the ribbon. The query displays the bills from the database in the query datasheet view.

4. Transform this query into a report by clicking the "Report" button on the ribbon. A bill report is created instantly from the query data.

References

• Microsoft: Create A Simple Report

Resources

• Microsoft: Access How To & Help