Hi all,
I have a made a huge database in excel but since the size has increased too much I am planning to migrate it into Access.
So far I have learnt how to make basic database in Access but I understand calculated fields can't/should not be made and saved in Access.
Lets say I have data for 2 years in separate tables as follows:
Table2011
Company Net Sales PAT
A 1000 100
B 2000 150
C 3000 120
Table2010
Company Net Sales PAT
A 800 90
B 2200 180
C 2500 90
In excel I was able to make a summary tables as follows
Summary Table1
Company Sales growth PAT growth
A 25% 11%
B -10% -15%
C 20% -25%
Summary Table 2 2011 2010
Aggregate Sales (A + B + C) 6000 5500
Aggregate PAT (A + B + C) 370 360
Sales growth 10%
PAT growth 1%
I need these tables for my further VBA programming.
1. Can I make and save such tables in Access?
2. Is there any advantage in moving to Access or should I continue using Excel for the same?