One table vs 100+ tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have about 100+ charts (each chart is a group of trendlines with data
points and labels for each point, and the x and y axis may vary between
charts) and I want to create a database from it with the capabilty to
1. search charts by category, title, x, y, etc. create a list of results,
and draw the chart when user click on one of the search result.
2. be able to expand, such as adding data to a chart or adding charts.

Is Access capable to handle it with forms? If not, what other choise I have
for a
simple cheap design? If Access is ok, I have the following question.

I'm trying to come up a design for creating charts out of tables. I have
two design ideas in mind, would you suggest me the better one, or come up a
new idea?
Idea A. all charts in one or a few tables with an extra field as chart name
pro: can use one function to draw all the charts
con: may have to add columns if future expansion requires

Idea B. one table for each chart, and use chart name as table name
pro: easy to maintain and update tables, and flexible to future expansion
con: not sure if one function can handle all the charts by table name?

the design is simpler the better, I plan to get it done in a few days (I
mean the archeture, not adding data) if possible.

thank you vey much in advance,

Wei
 
I would have said that the CON in A would apply to B also. If you need
to add a column, its likely you would need it in all the tables and
would be a nightmare to maintain. with the little you have given, I'd
opt for A.

I have about 100+ charts (each chart is a group of trendlines with data
points and labels for each point, and the x and y axis may vary between
charts) and I want to create a database from it with the capabilty to
1. search charts by category, title, x, y, etc. create a list of results,
and draw the chart when user click on one of the search result.
2. be able to expand, such as adding data to a chart or adding charts.

Is Access capable to handle it with forms? If not, what other choise I have
for a
simple cheap design? If Access is ok, I have the following question.

I'm trying to come up a design for creating charts out of tables. I have
two design ideas in mind, would you suggest me the better one, or come up a
new idea?
Idea A. all charts in one or a few tables with an extra field as chart name
pro: can use one function to draw all the charts
con: may have to add columns if future expansion requires

Idea B. one table for each chart, and use chart name as table name
pro: easy to maintain and update tables, and flexible to future expansion
con: not sure if one function can handle all the charts by table name?

the design is simpler the better, I plan to get it done in a few days (I
mean the archeture, not adding data) if possible.

thank you vey much in advance,

Wei
Click to expand...

Please remove obvious from email address if emailing.
 
Back
Top