B
Brotherwarren
Hi folks,
Please could someone take the time to answer a few beginners
questions.
I'm a teacher with responsibility for monitoring our school's progress
nationally and reporting to parents on their child's attainment.
We have been using an in-house excel application to keep records of
things such as exam resutls, effort grades, reading ages and so on.
We're now considering swapping this data over to access.
My biggest worry is that a lot of the information passed back to
parents is in graph form. Is it possible to construct line graphs,
including line of best fit, format the colours of individual data
points and lines of best fit and other things that excel can handle.
If it's not possible to do things directly in Access, what are the
chances of exporting data to excel, graphing it, and returning the
graph to access for a report? We have around 350 reports to prepare
and print at one time, and these go out on 10 occasions through the
course of a school year so speed is fairly important.
Thanks for taking the time to read this.
Thanks in advance for any advice or answers.
Tony
Please could someone take the time to answer a few beginners
questions.
I'm a teacher with responsibility for monitoring our school's progress
nationally and reporting to parents on their child's attainment.
We have been using an in-house excel application to keep records of
things such as exam resutls, effort grades, reading ages and so on.
We're now considering swapping this data over to access.
My biggest worry is that a lot of the information passed back to
parents is in graph form. Is it possible to construct line graphs,
including line of best fit, format the colours of individual data
points and lines of best fit and other things that excel can handle.
If it's not possible to do things directly in Access, what are the
chances of exporting data to excel, graphing it, and returning the
graph to access for a report? We have around 350 reports to prepare
and print at one time, and these go out on 10 occasions through the
course of a school year so speed is fairly important.
Thanks for taking the time to read this.
Thanks in advance for any advice or answers.
Tony