Access 2007: Using Reports to Make Data Meaningful to Others
Thank you for taking the time to report an issue.
What's wrong... Please write below.
This tutorial will show you how you might plan and build a database from scratch, including how to set up tables, create and use forms to enhance data integrity, design and run meaningful queries, and produce useful and attractive reports.
This tutorial will show you how to build a database from scratch, including how to plan and set up tables and fields, create and use forms to enhance data integrity, design and run meaningful queries, and create useful and attractive reports.
Our data lives in SQL Server, Access 2007, Excel, and in a purchased package’s Pervasive Database which we can access nicely via ODBC.
We currently do not have Crystal Reports, or any other report writer other than the reporting features that are integrated into Access 2007.
I took a stand and said that I believe that Access 2007 will be able to handle our reporting needs. We currently have very few reports and it appears that our reporting needs are quite basic.
The bulk of our data lives in SQL Server, but we do not have SQL Server Reporting Services available.
Are there issues that I should be aware of when starting to use Access 2007 Reporting against SQL Server? So far, our initial experiments have worked nicely, but we have only started to scratch the surface.
If we are heading down the wrong path, I would like to know sooner rather than later.
Here is the scenario: My company uses an EXTREMELY large database, millions of lines of data. We employ admins who perform all of their queries, reports, etc. using an SQL Server. I am not an admin, but have been tasked with writing queries and reports for my work group using Access 2007.
I have been able to perform simple queries, but when I try something very complex, Access just runs and runs for up to hours ata time without ever timing out or returning any data.
I have supplied my SQL statement to the admins for quality check and testing. They are able to run my queries in the SQL server in less than thirty minutes. Am I asking too much of Access 2007?
An Access Application may contain several Tables logically related but maintained separately for easier handling. When it is time to prepare Reports related tables are selected and joined on common information in them, filtered and placed the output on Reports. Meaningful and timely Reports play a very important roll in decision making.
Report designing is an Art in its own merit, like Form designing. MS-Access is equipped with excellent Report Designing Tools and with little practice you can master it.
After completing this course you will be able to:
1)Create tabular reports.
2)Group the data in a report.
3)Create stacked reports.
4)Use Layout view and Design view to change a report.