Can a Scorecard be made in MS Access - HELP!

[TJVFree]

I’ve been asked to build a scorecard. I have been looking through different forms along with using the Google search and have not found anything that either shows me some examples or ways to make a scorecard or better yet, a how to make a score card using ms access.

Can someone point me in the right direction?

Thanks

 

[genomon]

For starters, what data are you trying to report? Table structures and any relationships would be helpful to know as well.

Beir bua agus beannacht!

 

[dhookom]

This all depends on what you want in your scorecard and the data. I do a lot of dashboard/scorecards and primarily use Excel with VBA to pull data from SQL Server. The data could come from Access.

Duane
Hook'D on Access
MS Access MVP

 

[TJVFree]

HI Duane and thank you for responding. I was hoping to hear what your thoughts were on this.
Not knowing a lot about VBA and how to connect access to excel could you guild me to a sight that would help or even a book that you recommend?

My term of Scorecard might be incorrect. I’m looking to build a report with four plus summary reports might also have Pivot tables, charts and wording. Is scorecard the correct term?

Thanks
Corey

 

[dhookom]

It still isn't clear how you plan to deliver the score card. Does it need to be dynamic or can you create a pdf format file to distribute to your customers? Are your customers going to want to set different criteria for the summaries and charts?

Duane
Hook'D on Access
MS Access MVP