I have been working on excel and everything seemed to be working fine, until the amount of data that I need to process increased enormously.
I have never used MS access but thought that it could help me to improve the processing time for dealing with the huge data.
I have an excel sheet that has certain fields which i can import into the MS Access Table.
The sheet has the following fields as columns:
1) Name
2) Age
3) Address
4) Maths
5) Science
6) English
7) Spanish
For the sake of simplicity, suppose there are 10 rows of data where in the names of the students may be duplicate.
What I need to do is to find the unique names of the students and see how many times there name is appearing.
For example, if Mark appears 4 times and julie appears 2 times and jack appears 4 times in the 10 rows, then I need to have a count 4 next to their names( next cell) so that I can create a graph.
Mark 4
Julie 2
Jack 4
This i will export to excel and create graph.
I have a working model of this requirement in excel however, it crashes because of the amount of data.
Requesting assistance to understand and complete task using MS Access.