Reporting in Microsoft Access
You can create a report from your iBase database in a Microsoft™ Access database format. You can use Microsoft Access to create reports with more than one main entity type.
Why use a Microsoft Access database as a report format?
- iBase reports can be combined to allow reporting on more than one main entity. For example, a report on telephones, might also report on the subscribers of the phones involved.
- To allow iBase data to be combined with data from other systems; Microsoft Access can incorporate data from a wide variety of formats: Extensible Markup Language (XML), OLE DB, and Open Database Connectivity (ODBC).
- Microsoft Access data can be used by specialist database report tools.
- Each main entity, link, or linked entity has a separate Microsoft Access database table.
- Each record that you include becomes a row in the relevant database table.
- Each field that you specify in the report definition becomes a column in the relevant database table.
- Any formatting that you specify as part of the report definition, for example fonts or highlighting, is ignored.
Creating a Microsoft Access database report
- In the report wizard, enter the details of the report.
- Click Next to display the second page and in the Output to area, select Microsoft Access and then specify a file name and location.
- Click Finish. When the report is complete, click Close.
Viewing the Microsoft Access database
To view the database, start Microsoft Access and open the database that you created. Double-click the table that is named after the main entity in your report. For example, if you selected Telephone as your main entity, double-click Telephone_ to display the contents of the Telephone_ table.
Reporting on an extended selection of entity types
One of the reasons that you might choose to create reports in Microsoft Access is to extend the selection of the entities that you report upon, beyond one link distance. For example, in a report on calls by a particular telephone; being able to report on entities one further link away, means you might report on the subscribers too.
Reporting on different entity types requires that you create separate report definitions and use them to create reports, these reports can be generated into the same Microsoft Access database.
Linking tables and creating relationships in Microsoft Access
- Generate the first report and output to a new Microsoft Access database.
- Generate the second report and output the report to the same Microsoft Access database, and select Update existing database.
- Select Extend the database to include the report data.
The Combined database now has one table for each of the entity types in your reports.
- Create relationships between the tables that originated from the reports:
- Select . A relationship might exist between the MainEntity_ID fields in related tables.
- For each entity type, select a field relevant to your report in one table and drag it to the corresponding field in the related table. You can use the record IDs to help identify the relationships that need to be created.
- Click Create to make the relationship.