I have an MS Access database that contains 520,000 business records. Attached is a sample of records from that database in excel format.
I want a tool? creating that will allow me to sort the database by various criteria and then allow me to export the results in either Access or Excel formats.
The search criteria would include - Town, County, Business Type (SIC2), Employee Band
For example, if I might want a list of all business that are included in a certain 'County' such as Staffordshire or Hertfordshire or Surrey, and then to export this as a file.
I am open to suggestions as to the best way to do this. It could either be a tool that runs in MS Access or it can be a stand alone application that allows me to import the database and then carry out the queries.
## Deliverables
Database data? sample attached