Should I use Excel or Access for a project – I have about 100 records to deal with.
If you have as few records as these the benefits of using Excel outweigh the problems. You can’t query the data in the same way as Access but in this caseĀ AutoFilter will do the job adequately. If you use Access you will need to have access to someone who has the skills for to use this. Finding someone with Excel skills is easier.
Thanks for your question – Tim.